Lines Matching refs:stmt

21     if (!$stmt = mysqli_stmt_init($link))
24 // stmt object status test
26 mysqli_stmt_fetch($stmt);
31 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
32 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
35 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
38 if (!mysqli_stmt_execute($stmt))
39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 if (!mysqli_stmt_store_result($stmt))
42 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
44 if (is_object($tmp = mysqli_stmt_store_result($stmt)))
47 mysqli_stmt_close($stmt);
49 if (!$stmt = mysqli_stmt_init($link))
52 // stmt object status test
54 mysqli_stmt_fetch($stmt);
59 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
60 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
66 if (!mysqli_stmt_execute($stmt))
67 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
69 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
73 mysqli_stmt_close($stmt);
75 if (!$stmt = mysqli_stmt_init($link))
78 // stmt object status test
80 mysqli_stmt_get_result($stmt);
85 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
86 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
91 if (!mysqli_stmt_execute($stmt))
92 printf("[023] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
94 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
97 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
100 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) {
101 printf("[026] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
106 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
109 mysqli_stmt_close($stmt);
112 if (!$stmt = mysqli_stmt_init($link))
115 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
116 printf("[031] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
118 if (!mysqli_stmt_attr_set($stmt, MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY))
119 printf("[032] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
121 if (!mysqli_stmt_execute($stmt))
122 printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
124 $result = mysqli_stmt_get_result($stmt);
129 if (!$stmt = mysqli_stmt_init($link))
132 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
133 printf("[035] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
135 if (!mysqli_stmt_execute($stmt))
136 printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
140 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
143 if (!is_object($tmp = $result = mysqli_stmt_get_result($stmt)))
146 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
148 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
150 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
152 printf("[040] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
162 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
165 mysqli_stmt_close($stmt);
168 mysqli_stmt_fetch($stmt);