mysqli_store_result_copy.phpt - OpenGrok cross reference for /PHP-8.1/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));
67             if (true === @mysqli_data_seek($res, $idx)) {
68                 $row = $res->fetch_assoc();
83 …if (!$res = mysqli_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DESC LIM…
87     var_dump(mysqli_fetch_lengths($res));
88     $fields = $res->fetch_fields();
89     while ($row = $res->fetch_assoc()) {
90         var_dump(mysqli_fetch_lengths($res));
92     var_dump(mysqli_fetch_lengths($res));
94 …if (!$res = mysqli_real_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DES…
97     if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
99             gettype($res), $res, mysqli_errno($link), mysqli_error($link));
102     var_dump(mysqli_fetch_lengths($res));
103     $fields_copy = $res->fetch_fields();
104     while ($row = $res->fetch_assoc()) {
105         var_dump(mysqli_fetch_lengths($res));
107     var_dump(mysqli_fetch_lengths($res));
121     if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id DESC LIMIT 2"))
124     if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
126             gettype($res), $res, mysqli_errno($link), mysqli_error($link));
128     foreach (mysqli_fetch_all($res, MYSQLI_ASSOC) as $row) {
132     if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id DESC LIMIT 2"))
135     if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
137             gettype($res), $res, mysqli_errno($link), mysqli_error($link));
143     var_dump($res->fetch_assoc());
145     if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2"))
148     if (!is_object($res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA)))
150             gettype($res), $res, mysqli_errno($link), mysqli_error($link));
152     /* user conn killed, res associated with conn, fetch from res */
154     var_dump($res->fetch_assoc());
162     if (!$res = mysqli_real_query($link, "INSERT INTO test(id, label) VALUES (100, 'z')"))
174                 if ($res = $link->store_result(MYSQLI_STORE_RESULT_COPY_DATA)) {
176                     var_dump($res->fetch_all());
177                     $res->free();
185             $res = mysqli_store_result($link, MYSQLI_STORE_RESULT_COPY_DATA);
187             $tmp = mysqli_fetch_assoc($res);
193             mysqli_free_result($res);