Lines Matching refs:stmt

22     if (!$stmt = mysqli_stmt_init($link))
25 // stmt object status test
27 mysqli_stmt_fetch($stmt);
32 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
33 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
39 if (!mysqli_stmt_execute($stmt))
40 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_store_result($stmt))
43 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
45 if (is_object($tmp = mysqli_stmt_store_result($stmt)))
48 mysqli_stmt_close($stmt);
50 if (!$stmt = mysqli_stmt_init($link))
53 // stmt object status test
55 mysqli_stmt_fetch($stmt);
60 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
61 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
64 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
67 if (!mysqli_stmt_execute($stmt))
68 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
70 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
74 mysqli_stmt_close($stmt);
76 if (!$stmt = mysqli_stmt_init($link))
79 // stmt object status test
81 mysqli_stmt_get_result($stmt);
86 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
87 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
92 if (!mysqli_stmt_execute($stmt))
93 printf("[023] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
95 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
98 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
101 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) {
102 printf("[026] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
107 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
110 mysqli_stmt_close($stmt);
113 if (!$stmt = mysqli_stmt_init($link))
116 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
117 printf("[031] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 if (!mysqli_stmt_attr_set($stmt, MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY))
120 printf("[032] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
122 if (!mysqli_stmt_execute($stmt))
123 printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
125 $result = mysqli_stmt_get_result($stmt);
130 if (!$stmt = mysqli_stmt_init($link))
133 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
134 printf("[035] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
136 if (!mysqli_stmt_execute($stmt))
137 printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
141 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
144 if (!is_object($tmp = $result = mysqli_stmt_get_result($stmt)))
147 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
149 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
151 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
153 printf("[040] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
163 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
166 mysqli_stmt_close($stmt);
169 mysqli_stmt_fetch($stmt);