/PHP-8.1/ext/oci8/tests/ |
H A D | define3.phpt | 25 oci_bind_by_name($stmt,":id",$id); 28 oci_execute($stmt, OCI_DEFAULT); 38 oci_execute($stmt, OCI_DEFAULT); 45 oci_execute($stmt); 47 while (oci_fetch($stmt)) { 55 oci_execute($stmt); 57 while (oci_fetch($stmt)) { 64 oci_execute($stmt); 66 while (oci_fetch($stmt)) { 74 oci_execute($stmt); [all …]
|
H A D | bind_long_raw.phpt | 15 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); 16 oci_execute($stmt); 18 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); 22 oci_bind_by_name( $stmt, ":id", $i, -1); 23 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI); 24 oci_execute($stmt, OCI_DEFAULT); 27 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); 28 oci_execute($stmt); 30 $row = oci_fetch_row($stmt); 34 $stmt = oci_parse($c, "drop table phptestlngraw"); [all …]
|
H A D | bind_raw.phpt | 15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 16 oci_execute($stmt); 18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 23 oci_bind_by_name( $stmt, ":id", $i, -1); 24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN); 25 oci_execute($stmt, OCI_DEFAULT); 28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 29 oci_execute($stmt); 31 $row = oci_fetch_row($stmt); 35 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | bind_raw_2.phpt | 15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 16 oci_execute($stmt); 18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 23 oci_bind_by_name( $stmt, ":id", $i, -1); 24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN); 25 oci_execute($stmt, OCI_DEFAULT); 28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 29 oci_execute($stmt); 31 $row = oci_fetch_row($stmt); 35 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | define5.phpt | 24 $stmt = oci_parse($c, "select string from define5_tab where id = 1"); 25 oci_execute($stmt); 26 var_dump(oci_define_by_name($stmt, "STRING", $string)); 27 while (oci_fetch($stmt)) { 29 var_dump(oci_result($stmt, 'STRING')); 34 var_dump(oci_define_by_name($stmt, "STRING", $string)); 35 oci_execute($stmt); 37 while (oci_fetch($stmt)) { 43 oci_execute($stmt); 44 while (oci_fetch($stmt)) { [all …]
|
/PHP-8.1/ext/mysqli/tests/ |
H A D | mysqli_stmt_num_rows.phpt | 15 if (!$stmt = mysqli_stmt_init($link)) 21 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 25 if (!mysqli_stmt_execute($stmt)) { 26 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 31 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 40 mysqli_stmt_free_result($stmt); 65 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 67 if (mysqli_stmt_execute($stmt)) { 90 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 93 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_param_count.phpt | 15 if (!$stmt = mysqli_stmt_init($link)) 19 mysqli_stmt_param_count($stmt); 24 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) { 26 if (!mysqli_stmt_prepare($stmt, $query)) { 27 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_error($stmt)); 31 if ($expected !== ($tmp = mysqli_stmt_param_count($stmt))) 38 func_test_mysqli_stmt_param_count($stmt, "SELECT 1 AS a", 0, 10); 39 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20); 40 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30); 43 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_bind_param_check_param_no_change.phpt | 27 $stmt->bind_result($one); 28 $stmt->execute(); 29 $stmt->fetch(); 30 $stmt->free_result(); 44 $stmt->execute(); 47 $stmt->bind_result($one, $two); 48 $stmt->fetch(); 49 $stmt->free_result(); 59 $stmt->execute(); 60 $stmt->fetch(); [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 | 15 if (!$stmt = mysqli_stmt_init($link)) 18 // stmt object status test 20 mysqli_stmt_store_result($stmt); 26 !mysqli_stmt_execute($stmt)) 27 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 !mysqli_stmt_execute($stmt)) 34 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 53 while (mysqli_stmt_fetch($stmt)) { 66 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 | mysqli_stmt_get_warnings.phpt | 31 if (!$stmt = mysqli_stmt_init($link)) 35 mysqli_stmt_get_warnings($stmt); 40 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt)) 41 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt)) 44 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 50 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 56 !mysqli_stmt_execute($stmt)) 57 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 87 mysqli_stmt_close($stmt); [all …]
|
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 | 045.phpt | 12 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 13 mysqli_stmt_execute($stmt); 15 if (!$stmt->field_count) { 18 $stmt->close(); 28 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 29 mysqli_stmt_execute($stmt); 31 mysqli_stmt_bind_result($stmt, $c1, $c2); 32 mysqli_stmt_fetch($stmt); 33 mysqli_stmt_close($stmt);
|
/PHP-8.1/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.1/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 …]
|
/PHP-8.1/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.1/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.1/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() 203 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 219 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 259 stmt->row_count = row_count; in odbc_stmt_execute() [all …]
|
/PHP-8.1/ext/pdo_firebird/ |
H A D | firebird_statement.c | 31 #define RECORD_ERROR(stmt) _firebird_error(NULL, stmt, __FILE__, __LINE__) argument 87 RECORD_ERROR(stmt); in firebird_stmt_dtor() 193 RECORD_ERROR(stmt); in firebird_stmt_execute() 206 if (!stmt->executed) { in firebird_stmt_fetch() 222 stmt->row_count++; in firebird_stmt_fetch() 303 RECORD_ERROR(stmt); in firebird_fetch_blob() 309 RECORD_ERROR(stmt); in firebird_fetch_blob() 369 RECORD_ERROR(stmt); in firebird_fetch_blob() 511 RECORD_ERROR(stmt); in firebird_bind_blob() 536 RECORD_ERROR(stmt); in firebird_bind_blob() [all …]
|
/PHP-8.1/ext/pdo_sqlite/tests/ |
H A D | bug33841.phpt | 12 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )"); 13 $stmt->bindParam(':text', $name); 15 var_dump($stmt->execute(), $stmt->rowCount()); 17 $stmt = $db->prepare("UPDATE test SET text = :text "); 18 $stmt->bindParam(':text', $name); 20 var_dump($stmt->execute(), $stmt->rowCount());
|