/PHP-8.3/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_result_zerofill.phpt | 29 if (!($stmt = mysqli_prepare($link, 'SELECT zero FROM test LIMIT 1'))) { 36 if (!mysqli_stmt_bind_result($stmt, $result)) { 38 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt)) { 44 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 $res = mysqli_stmt_result_metadata($stmt); 50 mysqli_stmt_free_result($stmt);
|
H A D | 017.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'")) 19 mysqli_stmt_bind_result($stmt, $c0, $c1, $c2); 20 mysqli_stmt_execute($stmt); 22 mysqli_stmt_fetch($stmt); 23 mysqli_stmt_close($stmt);
|
H A D | bug33263.phpt | 23 $stmt = $mysql->prepare("SELECT DATABASE()"); 24 $stmt->execute(); 25 $stmt->bind_result($database); 26 $stmt->fetch(); 27 $stmt->close();
|
H A D | bug35759.phpt | 36 $stmt = $mysql->prepare("SELECT * FROM test"); 37 if ($stmt) { 39 $stmt->execute(); 40 $stmt->store_result(); 44 call_user_func_array(array($stmt, "bind_result"), $params); 45 $stmt->fetch(); 47 $stmt->close();
|
H A D | gh12107.phpt | 24 $stmt = $mysqli->prepare("call `gh12107`()"); 25 $stmt->execute(); 26 $stmt->bind_result($output); 27 var_dump($stmt->fetch()); 33 $stmt->execute(); 34 $stmt->bind_result($output); 35 var_dump($stmt->fetch());
|
H A D | mysqli_stmt_get_result_types.phpt | 36 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 mysqli_stmt_close($stmt); 54 mysqli_stmt_close($stmt); 59 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 mysqli_stmt_close($stmt); 65 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 66 mysqli_stmt_close($stmt); 73 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 98 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); [all …]
|
H A D | bug66124.phpt | 34 $stmt = $link->prepare($table_insert); 35 if (!$stmt) { 41 $stmt->bind_param('i', $id); 43 if ($stmt->execute()){ 44 echo "insert id:{$id}=>{$stmt->insert_id}\n"; 62 $stmt->close(); 68 $stmt = $link->prepare($table_insert); 69 $stmt->bind_param('s', $id); 73 if ($stmt->execute()){
|
H A D | mysqli_stmt_get_result_metadata_fetch_field.phpt | 23 if (!($stmt = mysqli_stmt_init($link)) || 24 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te… 25 !mysqli_stmt_execute($stmt)) 26 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 28 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) { 30 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) || 36 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 mysqli_stmt_close($stmt);
|
H A D | bug76386.phpt | 39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement 40 if ($stmt) { 41 $stmt->execute(); 44 $stmt->fetch(); 46 $stmt->free_result(); 67 $stmt = $link->prepare('SELECT * FROM t_test;'); 68 if ($stmt) { 69 $stmt->execute(); 71 $stmt->bind_result($tid, $t, $t2, $t4, $t6); 72 while ($stmt->fetch()) { [all …]
|
H A D | mysqli_change_user_prepared_statements.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'")) 22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) { 25 if ($stmt->errno == 0)
|
/PHP-8.3/ext/pdo_mysql/tests/ |
H A D | bug_39858.phpt | 41 $stmt = $db->prepare("CALL p()"); 42 $stmt->execute(); 44 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 45 } while ($stmt->nextRowset()); 47 $stmt = $db->prepare("CALL p()"); 48 $stmt->execute(); 50 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 51 } while ($stmt->nextRowset()); 52 $stmt->closeCursor();
|
/PHP-8.3/ext/pdo/tests/ |
H A D | bug_73234.phpt | 36 $stmt = $db->prepare('INSERT INTO test VALUES(:value)'); 38 $stmt->bindValue(':value', 0, PDO::PARAM_NULL); 39 $stmt->execute(); 41 $stmt->bindValue(':value', null, PDO::PARAM_NULL); 42 $stmt->execute(); 44 $stmt = $db->query('SELECT * FROM test'); 45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_019.phpt | 27 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx'); 29 $stmt->execute(); 30 $cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE); 35 $stmt->bindColumn('idx', $idx); 36 $stmt->bindColumn('txt', $txt); 37 $stmt->execute(); 39 while($stmt->fetch(PDO::FETCH_BOUND)) {
|
H A D | pdo_025.phpt | 31 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 33 $stmt->execute($row); 40 $stmt = $db->prepare('SELECT * FROM test'); 41 $stmt->setFetchMode(PDO::FETCH_INTO, new Test); 42 $stmt->execute(); 44 foreach($stmt as $obj) { 55 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail); 56 $stmt->execute(); 58 foreach($stmt as $obj) {
|
H A D | pdo_013.phpt | 24 $stmt = $db->prepare($SELECT); 26 $stmt->execute(); 27 $stmt->setFetchMode(PDO::FETCH_NUM); 28 foreach ($stmt as $data) 44 unset($stmt); 51 unset($stmt); 53 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW')); 55 foreach($stmt as $data)
|
/PHP-8.3/ext/sqlite3/tests/ |
H A D | sqlite3_28_clear_bindings.phpt | 19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); 24 $results = $stmt->execute(); 28 $stmt->reset(); 29 $stmt->clear(); 30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT)); 31 $results = $stmt->execute();
|
H A D | exception_from_toString.phpt | 17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)'); 18 $stmt->bindValue('i', 1234); 19 $stmt->bindValue('v', new throws); 22 $stmt->execute(); 28 $stmt->execute();
|
/PHP-8.3/ext/mysqlnd/ |
H A D | mysqlnd_driver.c | 188 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local 193 stmt = ret->data = mnd_ecalloc(1, sizeof(MYSQLND_STMT_DATA)); in MYSQLND_METHOD() 194 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD() 196 mysqlnd_error_info_init(&stmt->error_info_impl, 0); in MYSQLND_METHOD() 197 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD() 199 mysqlnd_upsert_status_init(&stmt->upsert_status_impl); in MYSQLND_METHOD() 200 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD() 201 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD() 203 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD() 204 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD() [all …]
|
/PHP-8.3/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_module.phpt | 22 $stmt = $dbh->query($query); 23 $row = $stmt->fetch(); 29 $stmt = $dbh->query($query); 30 $row = $stmt->fetch(); 36 $stmt = $dbh->query($query); 37 $row = $stmt->fetch();
|
/PHP-8.3/ext/pdo_pgsql/tests/ |
H A D | bug71885_2.phpt | 31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?"); 32 $stmt->execute(['b']); 33 var_dump($stmt->fetch()); 35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???"); 36 $stmt->execute(['a']); 37 var_dump($stmt->fetch());
|
H A D | bug46274_2.phpt | 26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_2 (blob1) VALUES (:foo)"); 33 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 34 $stmt->execute(); 37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 38 $stmt->execute(); 45 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 46 $stmt->execute(); 49 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 50 $stmt->execute();
|
/PHP-8.3/ext/oci8/tests/ |
H A D | error_bind.phpt | 26 $stmt = oci_parse($c, "insert into bind_test values (:name)"); 27 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR); 28 var_dump(oci_execute($stmt)); 32 var_dump(oci_execute($stmt)); 35 oci_bind_by_name($stmt, ":name", $c); 36 var_dump(oci_execute($stmt)); 41 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id"); 42 oci_bind_by_name($stmt, ":r_id", $c); 43 var_dump(oci_execute($stmt));
|
H A D | bug42841.phpt | 53 $stmt = oci_parse($c, $sql); 55 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR); 57 oci_execute($stmt, OCI_DEFAULT); 64 oci_free_statement($stmt); 71 $stmt = oci_parse($c, $sql); 73 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR); 75 oci_execute($stmt, OCI_DEFAULT); 82 oci_free_statement($stmt); 99 oci_bind_by_name($stmt, ':cur', $cur, -1, OCI_B_CURSOR); 100 oci_execute($stmt, OCI_DEFAULT); [all …]
|
/PHP-8.3/ext/pdo/ |
H A D | php_pdo_driver.h | 317 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt); 320 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt); 325 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt, 330 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno); 338 pdo_stmt_t *stmt, int colno, zval *result, enum pdo_param_type *type); 393 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt); 399 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt); 545 pdo_stmt_t *stmt; /* for convenience in dtor */ member 647 pdo_stmt_t *stmt; member 674 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, [all …]
|
/PHP-8.3/ext/pdo_firebird/tests/ |
H A D | bug_64037.phpt | 24 $stmt = $dbh->prepare($query); 25 $stmt->execute(); 26 $rows = $stmt->fetchAll(); 32 $stmt = $dbh->prepare('DELETE FROM price'); 33 $stmt->execute(); 39 unset($stmt);
|