/PHP-7.4/ext/mysqli/tests/ |
H A D | bug55653.phpt | 18 if (!($stmt = $link->stmt_init())) 21 if (!($stmt->prepare("SELECT ?")) || 22 !($stmt->bind_param("s", $in_and_out)) || 23 !($stmt->execute()) || 24 !($stmt->bind_result($in_and_out))) 25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 27 if (!$stmt->fetch()) 28 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
|
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 | 057.phpt | 23 mysqli_stmt_execute($stmt); 30 mysqli_stmt_close($stmt); 34 var_dump(mysqli_stmt_execute($stmt)); 35 var_dump(mysqli_stmt_reset($stmt)); 38 if ($stmt->affected_rows !== 0) 41 var_dump(mysqli_stmt_execute($stmt)); 43 var_dump(mysqli_stmt_reset($stmt)); 46 mysqli_stmt_execute($stmt); 47 $result1 = mysqli_stmt_result_metadata($stmt); 48 mysqli_stmt_store_result($stmt); [all …]
|
H A D | 058.phpt | 22 mysqli_stmt_bind_param($stmt, "is", $a, $b); 27 mysqli_stmt_execute($stmt); 29 mysqli_stmt_bind_param($stmt, "is", $c, $d); 34 mysqli_stmt_execute($stmt); 35 mysqli_stmt_close($stmt); 37 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 38 mysqli_stmt_execute($stmt); 40 mysqli_stmt_bind_result($stmt, $e, $f); 41 mysqli_stmt_fetch($stmt); 43 mysqli_stmt_bind_result($stmt, $g, $h); [all …]
|
H A D | mysqli_stmt_num_rows.phpt | 24 if (!$stmt = mysqli_stmt_init($link)) 30 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 34 if (!mysqli_stmt_execute($stmt)) { 35 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 40 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 mysqli_stmt_free_result($stmt); 74 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 76 if (mysqli_stmt_execute($stmt)) { 83 } while (mysqli_stmt_fetch($stmt)); 99 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [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);
|
H A D | mysqli_stmt_get_warnings.phpt | 40 if (!$stmt = mysqli_stmt_init($link)) 43 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt))) 46 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt)) 47 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt)) 50 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 55 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e… 56 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 62 !mysqli_stmt_execute($stmt)) 63 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
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 …]
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | batch_stmt_ins_up.phpt | 14 $stmt = $db->query( 23 var_dump($stmt->rowCount()); 24 var_dump($stmt->nextRowset()); 27 var_dump($stmt->rowCount()); 28 var_dump($stmt->nextRowset()); 31 var_dump($stmt->rowCount()); 32 var_dump($stmt->nextRowset()); 35 var_dump($stmt->rowCount()); 36 var_dump($stmt->nextRowset()); 39 var_dump($stmt->rowCount()); [all …]
|
H A D | bug_69592.phpt | 19 $stmt = $db->query($sql); 20 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 21 var_dump($stmt->nextRowset()); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 23 $stmt->closeCursor(); 29 $stmt = $db->query($sql); 30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 31 var_dump($stmt->nextRowset()); 32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 33 $stmt->closeCursor();
|
/PHP-7.4/ext/pdo_dblib/ |
H A D | dblib_stmt.c | 134 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbresults() returned FAIL"); in pdo_dblib_stmt_next_rowset_no_cancel() 146 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_next_rowset_no_cancel() 147 stmt->column_count = num_fields; in pdo_dblib_stmt_next_rowset_no_cancel() 165 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_next_rowset() 180 pdo_dblib_stmt_cursor_closer(stmt); in pdo_dblib_stmt_execute() 192 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_execute() 193 stmt->column_count = dbnumcols(H->link); in pdo_dblib_stmt_execute() 210 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_fetch() 236 col = &stmt->columns[colno]; in pdo_dblib_stmt_describe() 278 if (stmt->dbh->stringify) { in pdo_dblib_stmt_should_stringify_col() [all …]
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 29 if ('00000' !== $stmt->errorCode()) 31 var_export($stmt->errorCode(), true), 32 var_export($stmt->errorInfo(), true)); 36 $stmt->execute(); 48 if ('00000' !== $stmt->errorCode()) 50 var_export($stmt->errorCode(), true), 55 $stmt->execute(); 67 $stmt = $db->prepare($sql); 69 if ('00000' !== $stmt->errorCode()) 81 $stmt = $db->prepare($sql); [all …]
|
H A D | pdo_mysql_stmt_bindparam.phpt | 23 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 25 $stmt->execute(); 30 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 34 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 43 $stmt->execute(); 56 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 58 if (!$stmt->execute()) 60 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 64 $stmt->execute(); 69 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 30 if ('00000' !== $stmt->errorCode()) 32 var_export($stmt->errorCode(), true), 33 var_export($stmt->errorInfo(), true)); 37 if ('00000' !== $stmt->errorCode()) 39 var_export($stmt->errorCode(), true), 40 var_export($stmt->errorInfo(), true)); 50 if ('00000' !== $stmt->errorCode()) 52 var_export($stmt->errorCode(), true), 53 var_export($stmt->errorInfo(), true)); 57 if ('00000' !== $stmt->errorCode()) [all …]
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 65 $stmt->execute(); 79 $stmt->execute(); 92 $stmt->execute(); 93 check_result(11, $stmt, 1); 94 $stmt->execute(); 95 check_result(12, $stmt, 2); 97 $stmt->execute(); 98 check_result(13, $stmt, 1); 108 $stmt->execute(); 110 $stmt->execute(); [all …]
|
H A D | pdo_mysql_stmt_unbuffered_2050.phpt | 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 48 $stmt = PDO::query(<some query>) 52 $stmt->fetchAll() 56 $stmt = PDO::query(<some query>) 63 $stmt = PDO::query(<some query>) 68 current value of stmt: 78 PDO to $stmt. 91 $stmt->execute(); 95 $stmt->execute(); 98 unset($stmt); [all …]
|
/PHP-7.4/ext/pdo_firebird/tests/ |
H A D | bug_47415.phpt | 21 $stmt = $dbh->prepare($query); 22 $stmt->bindColumn('idx', $idx); 23 $stmt->bindColumn('txt', $txt); 24 $stmt->execute(); 25 $rows = $stmt->fetch(PDO::FETCH_BOUND); 26 var_dump($stmt->fetch()); 27 var_dump($stmt->rowCount()); 30 $stmt = $dbh->prepare('DELETE FROM testz'); 31 $stmt->execute(); 35 unset($stmt);
|
/PHP-7.4/ext/sqlite3/tests/ |
H A D | sqlite3stmt_getsql_expanded.phpt | 17 $stmt = $db->prepare('SELECT :a, :b, ?;'); 19 $stmt->bindValue(':a', 42); 20 $stmt->bindValue(':b', 'php'); 21 $stmt->bindValue(3, 43); 24 var_dump($stmt->getSQL(true)); 27 var_dump($res = $stmt->execute()); 32 $stmt->reset(); 35 $stmt->bindValue(':a', 'TEST'); 36 $stmt->bindValue(':b', '!!!'); 37 $stmt->bindValue(3, 40); [all …]
|
/PHP-7.4/ext/pdo_pgsql/ |
H A D | pgsql_statement.c | 129 stmt->driver_data = NULL; in pgsql_stmt_dtor() 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() 245 if (!stmt->executed && (!stmt->column_count || S->cols == NULL)) { in pgsql_stmt_execute() 282 if (stmt->bound_param_map && (namevar = zend_hash_find_ptr(stmt->bound_param_map, in pgsql_stmt_param_hook() 287 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", ZSTR_VAL(param->name)); in pgsql_stmt_param_hook() 295 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook() 299 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined"); in pgsql_stmt_param_hook() 309 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook() [all …]
|
/PHP-7.4/ext/oci8/tests/ |
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 …]
|
H A D | bug71422.phpt | 20 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1'); 21 oci_execute($stmt); 22 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 26 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes… 28 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT); 29 oci_execute($stmt); 30 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) { 34 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test… 36 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR); 37 oci_execute($stmt); [all …]
|
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 …]
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
H A D | bug33841.phpt | 14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )"); 15 $stmt->bindParam(':text', $name); 17 var_dump($stmt->execute(), $stmt->rowCount()); 19 $stmt = $db->prepare("UPDATE test SET text = :text "); 20 $stmt->bindParam(':text', $name); 22 var_dump($stmt->execute(), $stmt->rowCount());
|
/PHP-7.4/ext/pdo_odbc/ |
H A D | odbc_stmt.c | 145 if (stmt->executed) { in odbc_stmt_dtor() 146 SQLCloseCursor(S->stmt); in odbc_stmt_dtor() 149 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor() 152 free_cols(stmt, S); in odbc_stmt_dtor() 168 if (stmt->executed) { in odbc_stmt_execute() 169 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 172 rc = SQLExecute(S->stmt); in odbc_stmt_execute() 208 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 224 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 264 stmt->row_count = row_count; in odbc_stmt_execute() [all …]
|