/PHP-8.1/ext/oci8/tests/ |
H A D | bind_empty.phpt | 22 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name"); 23 oci_bind_by_name($stmt, ":name", $name); 25 var_dump(oci_execute($stmt)); 31 oci_bind_by_name($stmt, ":name", $name); 33 var_dump(oci_execute($stmt)); 38 $res = oci_execute($stmt); 41 $res = oci_execute($stmt); 45 oci_bind_by_name($stmt, ":name", $name); 47 var_dump(oci_execute($stmt)); 58 oci_bind_by_name($stmt, ":name", $name); [all …]
|
H A D | bug71422.phpt | 18 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1'); 19 oci_execute($stmt); 20 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 24 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes… 26 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT); 27 oci_execute($stmt); 28 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 32 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test… 34 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR); 35 oci_execute($stmt); [all …]
|
H A D | define4.phpt | 22 $stmt = oci_parse($c, "select value, string from define4_tab"); 26 var_dump(oci_define_by_name($stmt, "STRING", $string)); 28 oci_execute($stmt); 32 while (oci_fetch($stmt)) { 33 var_dump(oci_result($stmt, 'VALUE')); 35 var_dump(oci_result($stmt, 'STRING')); 37 var_dump(oci_result($stmt, 'VALUE')); 38 var_dump(oci_result($stmt, 'STRING')); 42 var_dump(oci_free_statement($stmt)); 46 var_dump(oci_result($stmt, 'STRING'));
|
/PHP-8.1/ext/pdo_mysql/tests/ |
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 …]
|
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 28 if (!$stmt->bindParam(1, $in)) 30 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 32 $stmt->execute(); 35 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT)) 37 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 39 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR)) 41 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 43 while ($stmt->fetch(PDO::FETCH_BOUND)) 49 $stmt->closeCursor(); 50 $stmt->execute(); [all …]
|
H A D | pdo_mysql_stmt_fetchobject_ctor_args.phpt | 13 $stmt = $db->prepare($query); 14 $ok = @$stmt->execute(); 29 $stmt = $db->prepare($query); 44 $stmt->execute(); 46 $obj = $stmt->fetchObject(Foo::class); 51 $stmt->execute(); 58 $stmt->execute(); 62 $stmt->execute(); 63 $obj = $stmt->fetchObject(Bar::class); 66 $stmt->execute(); [all …]
|
H A D | bug67004.phpt | 19 $stmt = $dbh->prepare("SELECT ?"); 21 $stmt->execute(["foo"]); 22 var_dump($stmt->fetchColumn(0)); 24 $stmt->execute(["bar"]); 25 var_dump($stmt->fetchColumn(0)); 27 $stmt = $dbh->prepare("SELECT ?"); 28 $stmt->execute(["baz"]); 29 var_dump($stmt->fetchColumn(0));
|
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 26 $stmt->execute(array('first row')); 27 if ('00000' !== $stmt->errorCode()) 29 var_export($stmt->errorCode(), true), 30 var_export($stmt->errorInfo(), true)); 33 $stmt->execute(); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 45 $stmt->execute(array('first row')); 46 if ('00000' !== $stmt->errorCode()) 48 var_export($stmt->errorCode(), true), 52 $stmt->execute(); [all …]
|
H A D | bug_44707.phpt | 13 $stmt = $db->query('SELECT VERSION() as _version'); 14 $row = $stmt->fetch(PDO::FETCH_ASSOC); 40 $stmt->bindParam(1, $id); 44 $stmt->execute(); 47 $stmt = $db->query('SELECT * FROM test'); 48 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 51 $stmt->bindParam(1, $id); 53 $stmt->bindParam(2, $mybool, PDO::PARAM_INT); 54 $stmt->execute(); 56 $stmt = $db->query('SELECT * FROM test'); [all …]
|
/PHP-8.1/ext/pdo_pgsql/ |
H A D | pgsql_statement.c | 127 stmt->driver_data = NULL; in pgsql_stmt_dtor() 137 bool in_trans = stmt->dbh->methods->in_transaction(stmt->dbh); in pgsql_stmt_execute() 183 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute() 218 stmt->bound_params ? in pgsql_stmt_execute() 228 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute() 257 if (in_trans && !stmt->dbh->methods->in_transaction(stmt->dbh)) { in pgsql_stmt_execute() 258 pdo_pgsql_close_lob_streams(stmt->dbh); in pgsql_stmt_execute() 286 if (stmt->bound_param_map && (namevar = zend_hash_find_ptr(stmt->bound_param_map, in pgsql_stmt_param_hook() 299 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook() 314 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook() [all …]
|
/PHP-8.1/ext/mysqli/tests/ |
H A D | mysqli_stmt_send_long_data_packet_size_libmysql.phpt | 16 if (!$stmt = mysqli_stmt_init($link)) 26 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 30 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label)) 31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 63 if (true !== mysqli_stmt_execute($stmt)) 64 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 80 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 83 if (false !== ($tmp = mysqli_stmt_execute($stmt))) 85 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_get_client_stats_ps.phpt | 25 if (!$stmt = mysqli_stmt_init($link)) 30 !mysqli_stmt_execute($stmt) || 31 !mysqli_stmt_store_result($stmt) || 33 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 36 while (mysqli_stmt_fetch($stmt)) 39 mysqli_stmt_free_result($stmt); 61 !mysqli_stmt_execute($stmt) || 63 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 66 while (mysqli_stmt_fetch($stmt)) 81 mysqli_stmt_free_result($stmt); [all …]
|
H A D | mysqli_stmt_bind_result.phpt | 14 $stmt = mysqli_stmt_init($link); 16 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 18 mysqli_stmt_close($stmt); 19 $stmt = mysqli_stmt_init($link); 32 printf("[004] [%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_close($stmt); 95 mysqli_stmt_close($stmt); 138 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 296 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | 026.phpt | 22 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 23 mysqli_stmt_bind_param($stmt, "sb", $c1, $c2); 27 mysqli_stmt_send_long_data($stmt, 1, "This is the first sentence."); 28 mysqli_stmt_send_long_data($stmt, 1, " And this is the second sentence."); 31 mysqli_stmt_execute($stmt); 32 mysqli_stmt_close($stmt); 34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 35 mysqli_stmt_bind_result($stmt, $d1, $d2); 36 mysqli_stmt_execute($stmt); 37 mysqli_stmt_fetch($stmt); [all …]
|
H A D | mysqli_stmt_errno.phpt | 15 if (!$stmt = mysqli_stmt_init($link)) 19 if (0 !== ($tmp = mysqli_stmt_errno($stmt))) 22 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 26 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 29 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 30 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 if (0 != ($tmp = mysqli_stmt_errno($stmt))) 38 if (true === ($tmp = mysqli_stmt_execute($stmt))) 42 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 45 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_error.phpt | 15 if (!$stmt = mysqli_stmt_init($link)) 19 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 22 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 26 if ('' === ($tmp = mysqli_stmt_error($stmt))) 29 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 30 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt)); 33 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 38 if (true === ($tmp = mysqli_stmt_execute($stmt))) 42 if ('' === ($tmp = mysqli_stmt_error($stmt))) 45 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_send_long_data_packet_size_mysqlnd.phpt | 16 if (!$stmt = mysqli_stmt_init($link)) 26 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 30 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label)) 31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 57 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 if (true !== mysqli_stmt_execute($stmt)) 61 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 85 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 88 if (false !== ($tmp = mysqli_stmt_execute($stmt))) 90 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug42378.phpt | 69 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 73 if (!mysqli_stmt_execute($stmt)) { 76 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 83 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 93 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 97 if (!mysqli_stmt_fetch($stmt)) { 100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 119 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 126 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 148 mysqli_stmt_free_result($stmt); [all …]
|
/PHP-8.1/ext/pdo_sqlite/tests/ |
H A D | bug46139.phpt | 18 $stmt = $db->query("SELECT 'foo' test, 1"); 19 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 20 $r1 = $stmt->fetch(); 23 $stmt = $db->query("SELECT 'foo' test, 1"); 24 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 25 $r1 = $stmt->fetchAll(); 28 $stmt = $db->query("SELECT 'foo' test, 1"); 29 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 30 $r1 = $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE);
|
/PHP-8.1/ext/pdo_dblib/tests/ |
H A D | bug_67130.phpt | 13 $stmt = $db->query('SELECT 1; SELECT 2; SELECT 3;'); 14 var_dump($stmt->fetch()); 15 var_dump($stmt->fetch()); 16 var_dump($stmt->nextRowset()); 17 var_dump($stmt->nextRowset()); 18 var_dump($stmt->fetch()); 19 var_dump($stmt->nextRowset());
|
H A D | batch_stmt_ins_exec.phpt | 26 $stmt = $db->query( 33 var_dump($stmt->rowCount()); 34 var_dump($stmt->nextRowset()); 37 var_dump($stmt->rowCount()); 38 var_dump($stmt->nextRowset()); 41 var_dump($stmt->rowCount()); 42 var_dump($stmt->nextRowset()); 45 var_dump($stmt->rowCount()); 46 var_dump($stmt->nextRowset()); 49 var_dump($stmt->rowCount()); [all …]
|
/PHP-8.1/ext/pdo_firebird/tests/ |
H A D | bug_48877.phpt | 26 $stmt = $dbh->prepare($query); 27 $stmt->bindParam(':paramno', $value, PDO::PARAM_STR); 28 $stmt->execute(); 29 $rows = $stmt->fetch(); 30 var_dump($stmt->fetch()); 31 var_dump($stmt->rowCount()); 34 $stmt = $dbh->prepare('DELETE FROM testz'); 35 $stmt->execute(); 41 unset($stmt);
|
/PHP-8.1/ext/sqlite3/tests/ |
H A D | bug77051.phpt | 11 $stmt = $db->prepare('SELECT :a, :b, ?;'); 14 $stmt->bindParam(':a', $a, SQLITE3_INTEGER); 15 $stmt->bindValue(':b', 'php'); 16 $stmt->bindValue(':b', 'PHP'); 17 $stmt->bindValue(3, 424242); 20 var_dump($res = $stmt->execute()); 29 var_dump($res = $stmt->execute()); 36 $stmt->bindValue(':b', 'TEST'); 37 $stmt->bindValue(3, '!!!'); 40 var_dump($res = $stmt->execute());
|
/PHP-8.1/ext/odbc/tests/ |
H A D | bug46050.phpt | 11 $stmt = odbc_prepare($conn, "SELECT 1"); 12 var_dump(odbc_execute($stmt)); 13 var_dump(odbc_fetch_array($stmt)); 14 var_dump(odbc_next_result($stmt)); 15 var_dump(odbc_execute($stmt)); 16 var_dump(odbc_fetch_array($stmt));
|
/PHP-8.1/ext/pdo_pgsql/tests/ |
H A D | large_objects.phpt | 28 $stmt->bindValue(1, 1); 33 $stmt->bindParam(2, $stm, PDO::PARAM_LOB); 34 $stmt->execute(); 38 $stmt = $db->prepare("SELECT * from test"); 40 $stmt->execute(); 42 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { 49 $stmt = $db->prepare("SELECT * from test"); 50 $stmt->execute(); 53 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { 60 $stmt = $db->prepare("SELECT * from test"); [all …]
|