/PHP-8.3/ext/pdo/tests/ |
H A D | bug_44173.phpt | 24 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, []); 25 var_dump($stmt); 33 $stmt = $db->query("SELECT * FROM test", 'abc'); 40 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0); 41 var_dump($stmt); 49 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO); 50 var_dump($stmt); 58 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN); 59 var_dump($stmt); 67 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS); [all …]
|
H A D | bug_39656.phpt | 25 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?"); 26 $stmt->bindValue(1, 1, PDO::PARAM_INT ); 27 $stmt->execute(); 28 $row = $stmt->fetch(); 31 $stmt->execute(); 32 $stmt->closeCursor(); 33 $row = $stmt->fetch(); // this line will crash CLI
|
H A D | pdo_028.phpt | 19 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)'); 24 $stmt->bindValue($i+1, $v); 26 $stmt->execute(); 28 $stmt = $db->prepare('SELECT * from test'); 29 $stmt->execute(); 31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-8.3/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 28 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 29 $stmt->execute(array('test')); 30 if ('00000' !== $stmt->errorCode()) { 32 var_export($stmt->errorCode(), true), 33 var_export($stmt->errorInfo(), true)); 35 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 44 $stmt->execute(array('test')); 45 if ('00000' !== $stmt->errorCode()) 47 var_export($stmt->errorCode(), true), 48 var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_attr_multi_statements.phpt | 29 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table)); 30 $stmt->closeCursor(); 33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 36 $stmt = $db->query('SELECT 1 AS value;'); 37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 44 var_dump($stmt); 48 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 51 $stmt = $db->query('SELECT 1 AS value;'); [all …]
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 38 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 41 $stmt = $db->query('SELECT VERSION() as _version'); 42 $row = $stmt->fetch(PDO::FETCH_ASSOC); 54 $stmt = $db->prepare('CALL p()'); 55 $stmt->execute(); 57 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 58 } while ($stmt->nextRowset()); 60 $stmt->execute(); 62 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); [all …]
|
H A D | bug80458.phpt | 26 $stmt->execute(); 27 var_dump($stmt->fetchAll()); 43 $stmt->execute(); 44 var_dump($stmt->fetchAll()); 67 $stmt->execute(); 68 var_dump($stmt->fetchAll()); 84 $stmt->execute(); 85 var_dump($stmt->fetchAll()); 107 $stmt->execute(); 108 var_dump($stmt->fetchAll()); [all …]
|
H A D | pdo_mysql_errorcode.phpt | 39 $stmt = $db->query('SELECT id, label FROM test'); 40 $stmt2 = &$stmt; 42 check_error(4, $stmt); 45 @$stmt->execute(); 47 check_error(5, $stmt, '42S02'); 51 @$stmt = $db->query('SELECT id, label FROM unknown'); 55 $stmt = $db->query('SELECT id, label FROM test'); 57 check_error(9, $stmt); 63 check_error(12, $stmt); 71 check_error(16, $stmt);
|
H A D | change_column_count.phpt | 22 $stmt = $db->prepare('INSERT INTO test (id, name) VALUES(:id, :name)'); 23 $stmt->execute([ 28 $stmt = $db->prepare('SELECT * FROM test WHERE id = :id'); 29 $stmt->execute(['id' => 10]); 30 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC)); 33 $stmt->execute(['id' => 10]); 34 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 24 var_dump($stmt->errorInfo()); 25 $stmt->execute(); 26 var_dump($stmt->errorInfo()); 29 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 31 var_dump($stmt->execute()); 32 var_dump($stmt->errorInfo()); 47 var_dump($stmt); 50 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 51 var_dump($stmt->errorInfo()); 53 $stmt->execute(); [all …]
|
H A D | bug_45120.phpt | 20 $stmt = $db->prepare("SELECT 1 AS 'one'"); 21 if (true !== $stmt->execute()) 22 printf("[001] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 24 $res = $stmt->fetch(PDO::FETCH_ASSOC); 28 if (true !== $stmt->execute()) 29 printf("[003] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 31 $res = $stmt->fetch(PDO::FETCH_ASSOC);
|
/PHP-8.3/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_limits.phpt | 41 …$stmt_bind_param = 'return mysqli_stmt_bind_param($stmt, "' . $stmt_types . '", ' . $stmt_params .… 51 if (!$stmt = $link->prepare($insert)) { 55 if ($stmt->param_count != $num_params * $rows) { 59 printf("... statement with %d parameters prepared\n", $stmt->param_count); 63 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 72 if (!call_user_func_array(array($stmt, 'bind_param'), $param_ref)) { 73 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 77 if ($stmt->param_count != $num_params * $rows) { 82 if (!$stmt->execute()) { 83 printf("[%03d + 04] [%d] %s\n", $offset, $stmt->errno, $stmt->error); [all …]
|
H A D | mysqli_stmt_bind_param_type_juggling.phpt | 27 if (!$stmt = mysqli_stmt_init($link)) { 32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(col1, col2) VALUES (?, ?)")) { 33 … printf("[%03d + 4] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 37 if (!mysqli_stmt_bind_param($stmt, $bind_type1 . $bind_type2, $bind_value1, $bind_value1)) { 38 … printf("[%03d + 5] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt)) { 43 … printf("[%03d + 6] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 … printf("[%03d + 7] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 if (!mysqli_stmt_execute($stmt)) { 52 … printf("[%03d + 8] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_explain_metadata.phpt | 62 $stmt = mysqli_stmt_init($link); 64 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) { 65 if (!mysqli_stmt_store_result($stmt)) 66 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 68 if (!$res_meta = mysqli_stmt_result_metadata($stmt)) 69 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 100 $stmt->execute()) { 101 if (!$res_stmt = mysqli_stmt_get_result($stmt)) { 103 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 109 if ((mysqli_stmt_num_rows($stmt)) !== 0) { [all …]
|
H A D | 067.phpt | 22 if (!is_object($stmt = $mysql->prepare($query))) { 27 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 28 return $stmt; 45 $stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i"); 46 $stmt[$i]->execute(); 47 $stmt[$i]->bind_result($a[$i]); 52 while ($stmt[0]->fetch()) { 53 $stmt[1]->fetch(); 54 $stmt[2]->fetch(); 59 $stmt[$i]->close();
|
H A D | 020.phpt | 40 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)"); 41 mysqli_stmt_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7); 51 mysqli_stmt_execute($stmt); 52 mysqli_stmt_close($stmt); 54 $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM test_bind_result"); 56 mysqli_stmt_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7); 58 mysqli_stmt_execute($stmt); 59 mysqli_stmt_fetch($stmt); 65 mysqli_stmt_close($stmt);
|
H A D | 025.phpt | 28 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES(?,?,?,?,?,?,?)"); 29 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7); 39 mysqli_stmt_execute($stmt); 40 mysqli_stmt_close($stmt); 46 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 47 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 48 mysqli_stmt_execute($stmt); 49 mysqli_stmt_fetch($stmt); 55 mysqli_stmt_close($stmt);
|
H A D | bug70949.phpt | 20 if ($stmt = $mysql->prepare($sql)) 22 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 24 if ($stmt->bind_result($name)) { 26 if ($stmt->execute()) 28 while ($stmt->fetch()) 35 $stmt->free_result(); 36 $stmt->close();
|
H A D | 016.phpt | 19 if (!$stmt = mysqli_prepare($link, "SELECT @dummy")) 22 mysqli_stmt_bind_result($stmt, $dummy); 23 mysqli_stmt_execute($stmt); 24 mysqli_stmt_fetch($stmt); 28 mysqli_stmt_close($stmt);
|
/PHP-8.3/ext/pdo_oci/tests/ |
H A D | bug57702.phpt | 21 $stmt = $db->prepare($query); 22 $stmt->execute(); 25 $stmt = $db->prepare($query); 26 $stmt->execute(); 32 $stmt->bindParam(':id', $id); 37 $stmt->execute(); 55 $stmt->execute(); 56 $row = $stmt->fetch(PDO::FETCH_ASSOC); 78 $rs = $stmt->execute(); 145 $stmt = $db->prepare($query); [all …]
|
/PHP-8.3/ext/sqlite3/tests/ |
H A D | bug63921-32bit.phpt | 15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 16 $stmt->bindValue(':id', 1, SQLITE3_INTEGER); 17 $stmt->bindValue(':num', $num, SQLITE3_INTEGER); 18 $stmt->execute(); 20 $stmt = $conn->query('SELECT num FROM users'); 21 $result = $stmt->fetchArray();
|
H A D | bug63921-64bit.phpt | 15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 16 $stmt->bindValue(':id', 1, SQLITE3_INTEGER); 17 $stmt->bindValue(':num', $num, SQLITE3_INTEGER); 18 $stmt->execute(); 20 $stmt = $conn->query('SELECT num FROM users'); 21 $result = $stmt->fetchArray();
|
/PHP-8.3/ext/pdo_pgsql/tests/ |
H A D | debug_emulated_prepares.phpt | 18 $stmt = $db->prepare('SELECT :bool, :int, :string, :null'); 19 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL); 20 $stmt->bindValue(':int', 123, PDO::PARAM_INT); 21 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR); 22 $stmt->bindValue(':null', null, PDO::PARAM_NULL); 23 $stmt->execute(); 25 var_dump($stmt->debugDumpParams());
|
H A D | bug46274.phpt | 26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_1 (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 | define1.phpt | 26 $stmt = oci_parse($c, "select string from define1_tab"); 31 var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); 32 var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); 34 var_dump(oci_define_by_name($stmt, "", $string, 20)); 39 oci_execute($stmt); 41 while (oci_fetch($stmt)) {
|