/PHP-8.3/ext/mysqli/tests/ |
H A D | mysqli_stmt_param_count.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 17 mysqli_stmt_param_count($stmt); 22 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) { 24 if (!mysqli_stmt_prepare($stmt, $query)) { 25 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_error($stmt)); 29 if ($expected !== ($tmp = mysqli_stmt_param_count($stmt))) 36 func_test_mysqli_stmt_param_count($stmt, "SELECT 1 AS a", 0, 10); 37 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20); 38 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30); 41 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_num_rows.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 19 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 23 if (!mysqli_stmt_execute($stmt)) { 24 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 29 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 38 mysqli_stmt_free_result($stmt); 63 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 65 if (mysqli_stmt_execute($stmt)) { 88 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 91 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_get_warnings.phpt | 27 if (!$stmt = mysqli_stmt_init($link)) 31 mysqli_stmt_get_warnings($stmt); 36 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt)) 37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 39 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt)) 40 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 46 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 52 !mysqli_stmt_execute($stmt)) 53 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 83 mysqli_stmt_close($stmt); [all …]
|
H A D | bug55653.phpt | 19 if (!($stmt = $link->stmt_init())) 22 if (!($stmt->prepare("SELECT ?")) || 23 !($stmt->bind_param("s", $in_and_out)) || 24 !($stmt->execute()) || 25 !($stmt->bind_result($in_and_out))) 26 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 28 if (!$stmt->fetch()) 29 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | mysqli_stmt_store_result.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 16 // stmt object status test 18 mysqli_stmt_store_result($stmt); 24 !mysqli_stmt_execute($stmt)) 25 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 31 !mysqli_stmt_execute($stmt)) 32 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 46 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 while (mysqli_stmt_fetch($stmt)) { 64 mysqli_stmt_close($stmt); [all …]
|
H A D | 057.phpt | 24 mysqli_stmt_execute($stmt); 31 mysqli_stmt_close($stmt); 35 var_dump(mysqli_stmt_execute($stmt)); 36 var_dump(mysqli_stmt_reset($stmt)); 39 if ($stmt->affected_rows !== 0) 42 var_dump(mysqli_stmt_execute($stmt)); 46 mysqli_stmt_execute($stmt); 47 $result1 = mysqli_stmt_result_metadata($stmt); 48 mysqli_stmt_store_result($stmt); 50 printf ("Rows: %d\n", mysqli_stmt_affected_rows($stmt)); [all …]
|
H A D | 045.phpt | 11 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 12 mysqli_stmt_execute($stmt); 14 if (!$stmt->field_count) { 17 $stmt->close(); 27 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 28 mysqli_stmt_execute($stmt); 30 mysqli_stmt_bind_result($stmt, $c1, $c2); 31 mysqli_stmt_fetch($stmt); 32 mysqli_stmt_close($stmt);
|
H A D | 058.phpt | 23 mysqli_stmt_bind_param($stmt, "is", $a, $b); 28 mysqli_stmt_execute($stmt); 30 mysqli_stmt_bind_param($stmt, "is", $c, $d); 35 mysqli_stmt_execute($stmt); 36 mysqli_stmt_close($stmt); 38 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 39 mysqli_stmt_execute($stmt); 41 mysqli_stmt_bind_result($stmt, $e, $f); 42 mysqli_stmt_fetch($stmt); 44 mysqli_stmt_bind_result($stmt, $g, $h); [all …]
|
H A D | mysqli_stmt_bind_param_check_param_no_change.phpt | 32 $stmt->bind_result($one); 33 $stmt->execute(); 34 $stmt->fetch(); 35 $stmt->free_result(); 49 $stmt->execute(); 52 $stmt->bind_result($one, $two); 53 $stmt->fetch(); 54 $stmt->free_result(); 64 $stmt->execute(); 65 $stmt->fetch(); [all …]
|
/PHP-8.3/ext/oci8/tests/ |
H A D | define3.phpt | 26 oci_bind_by_name($stmt,":id",$id); 29 oci_execute($stmt, OCI_DEFAULT); 39 oci_execute($stmt, OCI_DEFAULT); 46 oci_execute($stmt); 48 while (oci_fetch($stmt)) { 56 oci_execute($stmt); 58 while (oci_fetch($stmt)) { 65 oci_execute($stmt); 67 while (oci_fetch($stmt)) { 75 oci_execute($stmt); [all …]
|
H A D | bind_long_raw.phpt | 16 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); 17 oci_execute($stmt); 19 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); 23 oci_bind_by_name( $stmt, ":id", $i, -1); 24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI); 25 oci_execute($stmt, OCI_DEFAULT); 28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); 29 oci_execute($stmt); 31 $row = oci_fetch_row($stmt); 35 $stmt = oci_parse($c, "drop table phptestlngraw"); [all …]
|
H A D | bind_raw.phpt | 16 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 17 oci_execute($stmt); 19 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 24 oci_bind_by_name( $stmt, ":id", $i, -1); 25 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN); 26 oci_execute($stmt, OCI_DEFAULT); 29 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 30 oci_execute($stmt); 32 $row = oci_fetch_row($stmt); 36 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | bind_raw_2.phpt | 16 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 17 oci_execute($stmt); 19 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 24 oci_bind_by_name( $stmt, ":id", $i, -1); 25 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN); 26 oci_execute($stmt, OCI_DEFAULT); 29 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 30 oci_execute($stmt); 32 $row = oci_fetch_row($stmt); 36 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | define5.phpt | 28 $stmt = oci_parse($c, "select string from define5_tab where id = 1"); 29 oci_execute($stmt); 30 var_dump(oci_define_by_name($stmt, "STRING", $string)); 31 while (oci_fetch($stmt)) { 33 var_dump(oci_result($stmt, 'STRING')); 38 var_dump(oci_define_by_name($stmt, "STRING", $string)); 39 oci_execute($stmt); 41 while (oci_fetch($stmt)) { 47 oci_execute($stmt); 48 while (oci_fetch($stmt)) { [all …]
|
/PHP-8.3/ext/pdo_dblib/tests/ |
H A D | batch_stmt_ins_up.phpt | 15 $stmt = $db->query( 24 var_dump($stmt->rowCount()); 25 var_dump($stmt->nextRowset()); 28 var_dump($stmt->rowCount()); 29 var_dump($stmt->nextRowset()); 32 var_dump($stmt->rowCount()); 33 var_dump($stmt->nextRowset()); 36 var_dump($stmt->rowCount()); 37 var_dump($stmt->nextRowset()); 40 var_dump($stmt->rowCount()); [all …]
|
H A D | bug_69592.phpt | 20 $stmt = $db->query($sql); 21 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 22 var_dump($stmt->nextRowset()); 23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 24 $stmt->closeCursor(); 30 $stmt = $db->query($sql); 31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 32 var_dump($stmt->nextRowset()); 33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 34 $stmt->closeCursor();
|
/PHP-8.3/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 31 if ('00000' !== $stmt->errorCode()) 33 var_export($stmt->errorCode(), true), 38 $stmt->execute(); 39 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 50 if ('00000' !== $stmt->errorCode()) 57 $stmt->execute(); 69 $stmt = $db->prepare($sql); 70 $stmt->execute(array(':placeholder' => 1)); 71 if ('00000' !== $stmt->errorCode()) 83 $stmt = $db->prepare($sql); [all …]
|
H A D | pdo_mysql_stmt_bindparam.phpt | 24 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 26 $stmt->execute(); 31 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 35 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 44 $stmt->execute(); 57 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 59 if (!$stmt->execute()) 61 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 65 $stmt->execute(); 70 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 28 $stmt->nextRowSet(); 62 $stmt->execute(); 76 $stmt->execute(); 89 $stmt->execute(); 90 check_result(11, $stmt, 1); 91 $stmt->execute(); 92 check_result(12, $stmt, 2); 94 $stmt->execute(); 105 $stmt->execute(); 107 $stmt->execute(); [all …]
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 31 $stmt->execute(array(':placeholder' => 0)); 32 if ('00000' !== $stmt->errorCode()) 34 var_export($stmt->errorCode(), true), 38 $stmt->execute(array(':placeholder' => 0)); 39 if ('00000' !== $stmt->errorCode()) 41 var_export($stmt->errorCode(), true), 43 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 51 $stmt->execute(array(':placeholder' => 0)); 52 if ('00000' !== $stmt->errorCode()) 58 $stmt->execute(array(':placeholder' => 0)); [all …]
|
H A D | pdo_mysql_stmt_unbuffered_2050.phpt | 29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 49 $stmt = PDO::query(<some query>) 53 $stmt->fetchAll() 57 $stmt = PDO::query(<some query>) 64 $stmt = PDO::query(<some query>) 69 current value of stmt: 79 PDO to $stmt. 92 $stmt->execute(); 96 $stmt->execute(); 99 unset($stmt); [all …]
|
/PHP-8.3/ext/pdo_firebird/tests/ |
H A D | bug_47415.phpt | 24 $stmt = $dbh->prepare($query); 25 $stmt->bindColumn('idx', $idx); 26 $stmt->bindColumn('txt', $txt); 27 $stmt->execute(); 28 $rows = $stmt->fetch(PDO::FETCH_BOUND); 29 var_dump($stmt->fetch()); 30 var_dump($stmt->rowCount()); 33 $stmt = $dbh->prepare('DELETE FROM testz'); 34 $stmt->execute(); 38 unset($stmt);
|
/PHP-8.3/ext/sqlite3/tests/ |
H A D | sqlite3stmt_getsql_expanded.phpt | 18 $stmt = $db->prepare('SELECT :a, :b, ?;'); 20 $stmt->bindValue(':a', 42); 21 $stmt->bindValue(':b', 'php'); 22 $stmt->bindValue(3, 43); 25 var_dump($stmt->getSQL(true)); 28 var_dump($res = $stmt->execute()); 33 $stmt->reset(); 36 $stmt->bindValue(':a', 'TEST'); 37 $stmt->bindValue(':b', '!!!'); 38 $stmt->bindValue(3, 40); [all …]
|
/PHP-8.3/ext/pdo_firebird/ |
H A D | firebird_statement.c | 31 #define RECORD_ERROR(stmt) _firebird_error(NULL, stmt, __FILE__, __LINE__) argument 92 RECORD_ERROR(stmt); in firebird_stmt_dtor() 198 RECORD_ERROR(stmt); in firebird_stmt_execute() 211 if (!stmt->executed) { in firebird_stmt_fetch() 227 stmt->row_count++; in firebird_stmt_fetch() 311 RECORD_ERROR(stmt); in firebird_fetch_blob() 317 RECORD_ERROR(stmt); in firebird_fetch_blob() 377 RECORD_ERROR(stmt); in firebird_fetch_blob() 519 RECORD_ERROR(stmt); in firebird_bind_blob() 544 RECORD_ERROR(stmt); in firebird_bind_blob() [all …]
|
/PHP-8.3/ext/pdo_odbc/ |
H A D | odbc_stmt.c | 140 if (stmt->executed) { in odbc_stmt_dtor() 141 SQLCloseCursor(S->stmt); in odbc_stmt_dtor() 144 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor() 147 free_cols(stmt, S); in odbc_stmt_dtor() 163 if (stmt->executed) { in odbc_stmt_execute() 164 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 167 rc = SQLExecute(S->stmt); in odbc_stmt_execute() 209 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 225 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 268 stmt->row_count = row_count; in odbc_stmt_execute() [all …]
|