mysqli_store_result_copy.phpt - OpenGrok cross reference for /PHP-7.0/ext/mysqli/tests/mysqli_store_result

Lines Matching refs:res
26 	if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
29 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
31 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
33 	if (true !== ($tmp = mysqli_data_seek($res, 2)))
37 	var_dump($res->fetch_assoc());
39 	if (true !== ($tmp = mysqli_data_seek($res, 0)))
43 	while ($row = $res->fetch_assoc()) {
47 	mysqli_free_result($res);
56 	if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
59 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
61 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
66 		if (true === @mysqli_data_seek($res, $idx)) {
67 			$row = $res->fetch_assoc();
79 …if (!$res = mysqli_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DESC LIM…
83 	var_dump(mysqli_fetch_lengths($res));
84 	$fields = $res->fetch_fields();
85 	while ($row = $res->fetch_assoc()) {
86 		var_dump(mysqli_fetch_lengths($res));
88 	var_dump(mysqli_fetch_lengths($res));
90 …if (!$res = mysqli_real_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DES…
93 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
95 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
98 	var_dump(mysqli_fetch_lengths($res));
99 	$fields_copy = $res->fetch_fields();
100 	while ($row = $res->fetch_assoc()) {
101 		var_dump(mysqli_fetch_lengths($res));
103 	var_dump(mysqli_fetch_lengths($res));
117 	if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id DESC LIMIT 2"))
120 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
122 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
124 	foreach (mysqli_fetch_all($res, MYSQLI_ASSOC) as $row) {
128 	if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id DESC LIMIT 2"))
131 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
133 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
139 	var_dump($res->fetch_assoc());
141 	if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2"))
144 	if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
146 			gettype($res), $res, mysqli_errno($link), mysqli_error($link));
148 	/* user conn killed, res associated with conn, fetch from res */
150 	var_dump($res->fetch_assoc());
158 	if (!$res = mysqli_real_query($link, "INSERT INTO test(id, label) VALUES (100, 'z')"))
170 				if ($res = $link->store_result(MYSQLI_STORE_RESULT_COPY_DATA)) {
172 					var_dump($res->fetch_all());
173 					$res->free();
181 			$res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA);
183 			$tmp = mysqli_fetch_assoc($res);
189 			mysqli_free_result($res);