/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_get_result_metadata.phpt | 16 if (!$stmt = mysqli_stmt_init($link)) 20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 22 if (!mysqli_stmt_execute($stmt)) 23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 41 mysqli_stmt_close($stmt); 47 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 57 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug44897.phpt | 33 if (!$stmt = $link->prepare('CALL p(?, ?)')) 36 if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute()) 37 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error); 40 if (!$stmt->bind_result($out_new_label) || !$stmt->fetch()) 41 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error); 47 $stmt->close();
|
H A D | mysqli_stmt_get_result_bit.phpt | 54 if (!$stmt = mysqli_stmt_init($link)) 84 if (!mysqli_stmt_prepare($stmt, $sql) || 85 !mysqli_stmt_execute($stmt)) 86 … printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 89 if (!mysqli_stmt_prepare($stmt, $sql) || 90 !mysqli_stmt_execute($stmt)) 91 … printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 93 if (!$res = mysqli_stmt_get_result($stmt)) 94 … printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 121 mysqli_stmt_close($stmt);
|
H A D | 005.phpt | 25 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 26 mysqli_stmt_bind_result($stmt, $c1, $c2); 27 mysqli_stmt_execute($stmt); 28 mysqli_stmt_fetch($stmt); 36 mysqli_stmt_fetch($stmt); 38 mysqli_stmt_close($stmt);
|
H A D | bug45289.phpt | 20 if (!($stmt = $link->prepare('SELECT id, label FROM test WHERE id=? LIMIT 1'))) 23 if (!$stmt->bind_param('i', $id) || !$stmt->execute()) 24 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | 046.phpt | 22 $stmt = mysqli_prepare($link, "DELETE FROM test_affected WHERE foo=?"); 23 mysqli_stmt_bind_param($stmt, "i", $c1); 27 mysqli_stmt_execute($stmt); 28 $x = mysqli_stmt_affected_rows($stmt); 30 mysqli_stmt_close($stmt);
|
H A D | 009.phpt | 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8); 43 mysqli_stmt_execute($stmt); 44 $rc = mysqli_stmt_fetch($stmt); 57 mysqli_stmt_close($stmt); 68 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch_uint"); 69 mysqli_stmt_bind_result($stmt, $c1, $c2); 70 mysqli_stmt_execute($stmt); 71 $rc = mysqli_stmt_fetch($stmt); 75 mysqli_stmt_close($stmt);
|
H A D | bug45019.phpt | 27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C… 31 if (!$stmt->bind_result($column1) || !$stmt->execute()) 32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 35 while ($stmt->fetch()) { 48 $stmt->close();
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_types_zerofill.phpt | 24 $stmt->bindValue(1, $offset); 25 $stmt->bindValue(2, $value); 27 if (!$stmt->execute()) { 38 $stmt = $db->query('SELECT id, label FROM test'); 39 $row = $stmt->fetch(PDO::FETCH_ASSOC); 40 $stmt->closeCursor(); 78 $stmt = $db->query('SELECT id, label FROM test'); 79 $row_string = $stmt->fetch(PDO::FETCH_ASSOC); 80 $stmt->closeCursor(); 95 $stmt->execute(); [all …]
|
H A D | pdo_mysql_bit.phpt | 26 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 27 $stmt->bindValue(1, $offset); 28 $stmt->bindValue(2, $value); 29 if (!$stmt->execute()) { 30 printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true)); 33 $stmt = $db->query('SELECT id, label FROM test'); 34 $row = $stmt->fetch(PDO::FETCH_ASSOC);
|
H A D | pdo_mysql_prepare_native_mixed_style.phpt | 20 $stmt = $db->query('DELETE FROM test'); 21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)'); 22 $stmt->execute(array('a', 'b')); 23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label… 24 $stmt->execute(array(1, 1)); 25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_mysql_errorinfo.phpt | 48 $stmt = $db->query('SELECT id, label FROM test'); 49 $stmt2 = &$stmt; 51 check_error($offset + 4, $stmt); 54 @$stmt->execute(); 56 check_error($offset + 6, $stmt, '42S02'); 59 @$stmt = $db->query('SELECT id, label FROM unknown'); 63 $stmt = $db->query('SELECT id, label FROM test'); 65 check_error($offset + 10, $stmt); 72 check_error($offset + 13, $stmt); 80 check_error($offset + 17, $stmt);
|
/PHP-7.4/ext/pdo_sqlite/ |
H A D | php_pdo_sqlite_int.h | 64 sqlite3_stmt *stmt; member 71 extern int _pdo_sqlite_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, const char *file, int line); 73 #define pdo_sqlite_error_stmt(s) _pdo_sqlite_error(stmt->dbh, stmt, __FILE__, __LINE__)
|
/PHP-7.4/ext/pdo_odbc/tests/ |
H A D | bug44643.phpt | 14 $stmt = $db->prepare($sql); 16 $stmt->bindParam(':id1', $id1, PDO::PARAM_INT); 18 $stmt->bindParam(':id2', $id2, PDO::PARAM_INT); 19 var_dump($stmt->execute());
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | bug46274_2.phpt | 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 35 $stmt->bindparam(':id', $id); 36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 37 $stmt->execute(); 45 $stmt->bindparam(':id', $id); 46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 47 $stmt->execute();
|
/PHP-7.4/ext/oci8/tests/ |
H A D | define.phpt | 22 $stmt = oci_parse($c, "select string from define_tab"); 27 oci_define_by_name($stmt, "STRING", $string, 20); 29 oci_execute($stmt); 31 while (oci_fetch($stmt)) {
|
H A D | define_old.phpt | 22 $stmt = ociparse($c, "select string from define_old_tab"); 27 ocidefinebyname($stmt, "STRING", $string, 20); 29 ociexecute($stmt); 31 while (ocifetch($stmt)) {
|
/PHP-7.4/ext/sqlite3/tests/ |
H A D | bug72571.phpt | 10 $stmt = $db->prepare("select 1 = ?"); 14 $stmt->bindParam(0, $i); 16 var_dump($stmt->execute());
|
H A D | sqlite3_33_reset.phpt | 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 17 $stmt->bindValue(':id', 1, SQLITE3_INTEGER); 18 $stmt->reset("dummy"); 19 $stmt->reset();
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_030.phpt | 64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 65 var_dump(get_class($stmt)); 67 $stmt->execute($row); 70 unset($stmt); 77 $stmt = $db->query('SELECT * FROM test'); 78 var_dump(get_class($stmt)); 79 var_dump(get_class($stmt->dbh)); 83 foreach($stmt as $obj) {
|
H A D | pdo_006.phpt | 22 $stmt = $db->prepare('SELECT val, id from test'); 24 $stmt->execute(); 25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_GROUP)); 27 $stmt->execute(); 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_GROUP));
|
H A D | pdo_023.phpt | 53 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx'))); 54 $stmt->execute(); 55 return $stmt; 68 $stmt = $db->query('SELECT val, id FROM test'); 69 var_dump($stmt); 70 var_dump($stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE)); 72 $stmt = NULL;
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | datetime_convert.phpt | 16 $stmt = $db->query($sql); 17 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 22 $stmt = $db->query($sql); 23 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
|
H A D | datetime2.phpt | 17 $stmt = $db->query($sql); 18 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 22 $stmt = $db->query($sql); 23 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | disable_prepares.phpt | 17 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array( 26 $stmt->execute(); 27 $first = $stmt->fetchAll(); 36 $stmt->execute(); 37 $second = $stmt->fetchAll();
|