Lines Matching refs:stmt
18 if (!$stmt = mysqli_stmt_init($link))
21 // stmt object status test
23 mysqli_stmt_fetch($stmt);
28 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
29 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
31 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
34 if (!mysqli_stmt_execute($stmt))
35 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
37 if (!mysqli_stmt_store_result($stmt))
38 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 if (is_object($tmp = mysqli_stmt_store_result($stmt)))
43 mysqli_stmt_close($stmt);
45 if (!$stmt = mysqli_stmt_init($link))
48 // stmt object status test
50 mysqli_stmt_fetch($stmt);
55 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
56 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
61 if (!mysqli_stmt_execute($stmt))
62 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
64 if (! ($tmp = mysqli_stmt_get_result($stmt)) instanceof mysqli_result)
68 mysqli_stmt_close($stmt);
70 if (!$stmt = mysqli_stmt_init($link))
73 // stmt object status test
75 mysqli_stmt_get_result($stmt);
80 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
81 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
86 if (!mysqli_stmt_execute($stmt))
87 printf("[023] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 if (! ($tmp = mysqli_stmt_get_result($stmt)) instanceof mysqli_result)
92 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
95 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) {
96 printf("[026] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
101 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
104 mysqli_stmt_close($stmt);
107 if (!$stmt = mysqli_stmt_init($link))
110 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
111 printf("[031] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
113 if (!mysqli_stmt_attr_set($stmt, MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY))
114 printf("[032] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
116 if (!mysqli_stmt_execute($stmt))
117 printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 $result = mysqli_stmt_get_result($stmt);
124 if (!$stmt = mysqli_stmt_init($link))
127 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
128 printf("[035] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
130 if (!mysqli_stmt_execute($stmt))
131 printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
135 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
138 if (! ($result = mysqli_stmt_get_result($stmt)) instanceof mysqli_result)
141 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
143 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
145 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
147 printf("[040] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
159 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
162 mysqli_stmt_close($stmt);
165 mysqli_stmt_fetch($stmt);