/PHP-8.3/ext/pdo_mysql/tests/ |
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 …]
|
H A D | pdo_mysql_stmt_bindcolumn.phpt | 23 $stmt->execute(); 26 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT)) 28 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 32 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 35 while ($stmt->fetch(PDO::FETCH_BOUND)) { 44 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 63 $stmt->execute(); 66 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT)) 68 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 72 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); [all …]
|
/PHP-8.3/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.3/ext/mysqli/tests/ |
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 | 13 $stmt = mysqli_stmt_init($link); 15 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 17 mysqli_stmt_close($stmt); 18 $stmt = mysqli_stmt_init($link); 31 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 55 mysqli_stmt_close($stmt); 94 mysqli_stmt_close($stmt); 137 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 291 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_errno.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 17 if (0 !== ($tmp = mysqli_stmt_errno($stmt))) 20 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 24 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 27 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 28 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 31 if (0 != ($tmp = mysqli_stmt_errno($stmt))) 36 if (true === ($tmp = mysqli_stmt_execute($stmt))) 40 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 43 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_error.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 17 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 20 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 24 if ('' === ($tmp = mysqli_stmt_error($stmt))) 27 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 28 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt)); 31 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 36 if (true === ($tmp = mysqli_stmt_execute($stmt))) 40 if ('' === ($tmp = mysqli_stmt_error($stmt))) 43 mysqli_stmt_close($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_send_long_data_packet_size_mysqlnd.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 23 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 27 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label)) 28 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 54 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 57 if (true !== mysqli_stmt_execute($stmt)) 58 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 82 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 85 if (false !== ($tmp = mysqli_stmt_execute($stmt))) 87 … 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.3/ext/pdo_sqlite/tests/ |
H A D | bug46139.phpt | 19 $stmt = $db->query("SELECT 'foo' test, 1"); 20 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 21 $r1 = $stmt->fetch(); 24 $stmt = $db->query("SELECT 'foo' test, 1"); 25 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 26 $r1 = $stmt->fetchAll(); 29 $stmt = $db->query("SELECT 'foo' test, 1"); 30 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person'); 31 $r1 = $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE);
|
H A D | bug33841.phpt | 12 $stmt = $db->prepare("INSERT INTO test_33841 VALUES ( :text )"); 13 $stmt->bindParam(':text', $name); 15 var_dump($stmt->execute(), $stmt->rowCount()); 17 $stmt = $db->prepare("UPDATE test_33841 SET text = :text "); 18 $stmt->bindParam(':text', $name); 20 var_dump($stmt->execute(), $stmt->rowCount());
|
/PHP-8.3/ext/oci8/tests/ |
H A D | bind_empty.phpt | 26 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name"); 27 oci_bind_by_name($stmt, ":name", $name); 29 var_dump(oci_execute($stmt)); 35 oci_bind_by_name($stmt, ":name", $name); 37 var_dump(oci_execute($stmt)); 42 $res = oci_execute($stmt); 45 $res = oci_execute($stmt); 49 oci_bind_by_name($stmt, ":name", $name); 51 var_dump(oci_execute($stmt)); 62 oci_bind_by_name($stmt, ":name", $name); [all …]
|
H A D | bug71422.phpt | 22 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1'); 23 oci_execute($stmt); 24 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 28 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes… 30 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT); 31 oci_execute($stmt); 32 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 36 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test… 38 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR); 39 oci_execute($stmt); [all …]
|
H A D | define4.phpt | 26 $stmt = oci_parse($c, "select value, string from define4_tab"); 30 var_dump(oci_define_by_name($stmt, "STRING", $string)); 32 oci_execute($stmt); 36 while (oci_fetch($stmt)) { 37 var_dump(oci_result($stmt, 'VALUE')); 39 var_dump(oci_result($stmt, 'STRING')); 41 var_dump(oci_result($stmt, 'VALUE')); 42 var_dump(oci_result($stmt, 'STRING')); 46 var_dump(oci_free_statement($stmt)); 50 var_dump(oci_result($stmt, 'STRING'));
|
/PHP-8.3/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.3/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.3/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.3/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.3/ext/pdo/tests/ |
H A D | pdo_026.phpt | 50 $stmt->setFetchMode(PDO::FETCH_ASSOC); 51 $stmt->execute(); 52 return $stmt; 61 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 62 var_dump(get_class($stmt)); 64 $stmt->execute($row); 67 unset($stmt); 69 $stmt = $db->query('SELECT * FROM test'); 70 var_dump(get_class($stmt)); 71 var_dump(get_class($stmt->dbh)); [all …]
|