mysqli_stmt_attr_set.phpt - OpenGrok cross reference for /PHP-8.3/ext/mysqli/tests/mysqli_stmt_attr

Lines Matching refs:stmt
22     $stmt = mysqli_stmt_init($link);
24         mysqli_stmt_attr_set($stmt, 0, 0);
29     $stmt->prepare("SELECT * FROM test");
32         mysqli_stmt_attr_set($stmt, -1, 0);
38         $stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, -1);
42     $stmt->close();
48     $stmt = mysqli_stmt_init($link);
49     $stmt->prepare("SELECT label FROM test");
50     $stmt->execute();
51     $stmt->store_result();
52     $res = $stmt->result_metadata();
61     $stmt->close();
64     $stmt = mysqli_stmt_init($link);
65     $stmt->prepare("SELECT label FROM test");
66     var_dump($stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 1));
67     $res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
70     $stmt->execute();
71     $stmt->store_result();
72     $res = $stmt->result_metadata();
81     $stmt->close();
84     $stmt = mysqli_stmt_init($link);
85     $stmt->prepare("SELECT label FROM test");
86     $stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 0);
87     $res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
90     $stmt->execute();
91     $stmt->store_result();
92     $res = $stmt->result_metadata();
101     $stmt->close();
108     $stmt = mysqli_stmt_init($link);
109     $stmt->prepare("SELECT id, label FROM test");
113         $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, -1);
118 …if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_FOR_UPDATE)…
121 …if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_SCROLLABLE)…
124 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
127 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
130     $stmt->close();
132     $stmt = mysqli_stmt_init($link);
133     $stmt->prepare("SELECT id, label FROM test");
134     $stmt->execute();
136     $stmt->bind_result($id, $label);
138     while ($stmt->fetch())
140     $stmt->close();
144     $stmt = mysqli_stmt_init($link);
145     $stmt->prepare("SELECT id, label FROM test");
146 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
148     $stmt->execute();
150     $stmt->bind_result($id, $label);
152     while ($stmt->fetch())
154     $stmt->close();
161     $stmt = mysqli_stmt_init($link);
162     $stmt->prepare("SELECT id, label FROM test");
163 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
165     $stmt->execute();
167     $stmt->bind_result($id, $label);
169     while ($stmt->fetch())
171     $stmt->close();
183     $stmt = mysqli_stmt_init($link);
184     $stmt->prepare("SELECT id, label FROM test");
187         $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 0);
192     if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 1)))
194     $stmt->execute();
196     $stmt->bind_result($id, $label);
198     while ($stmt->fetch())
200     $stmt->close();
205     $stmt = mysqli_stmt_init($link);
206     $stmt->prepare("SELECT label FROM test");
207     if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, -1)))
209     $stmt->close();
211     $stmt = mysqli_stmt_init($link);
212     $stmt->prepare("SELECT label FROM test");
213     if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, PHP_INT_MAX)))
215     $stmt->close();
217     $stmt = mysqli_stmt_init($link);
218     $stmt->prepare("SELECT id, label FROM test");
219     if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 2)))
221     $stmt->execute();
223     $stmt->bind_result($id, $label);
225     while ($stmt->fetch())
227     $stmt->close();