/PHP-8.3/ext/mysqli/tests/ |
H A D | mysqli_stmt_fetch_bit.phpt | 32 if (!$stmt = mysqli_stmt_init($link)) 40 if (!mysqli_stmt_prepare($stmt, $sql) || 41 !mysqli_stmt_execute($stmt)) 42 … printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 46 if (!mysqli_stmt_prepare($stmt, $sql) || 47 !mysqli_stmt_execute($stmt) || 48 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label)) 49 … printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 if (!mysqli_stmt_fetch($stmt)) 52 … printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug35103.phpt | 27 $stmt = $mysql->prepare("SELECT a FROM test_bint ORDER BY a"); 28 $stmt->bind_result($v); 29 $stmt->execute(); 33 $stmt->fetch(); 36 $stmt->close(); 40 $stmt = $mysql->prepare("SELECT a FROM test_buint ORDER BY a"); 41 $stmt->bind_result($v2); 42 $stmt->execute(); 46 $stmt->fetch(); 49 $stmt->close();
|
H A D | 063.phpt | 15 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL"); 16 $stmt->execute(); 17 $stmt->bind_result($foo); 18 $stmt->fetch(); 19 $stmt->close(); 25 $stmt = new mysqli_stmt($mysql, "SELECT invalid FROM DUAL");
|
H A D | mysqli_stmt_bind_result_format.phpt | 67 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 74 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 81 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 91 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 98 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 116 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 138 mysqli_stmt_close($stmt); 284 mysqli_stmt_close($stmt); 297 if (!$stmt->execute()) { 323 $stmt->free_result(); [all …]
|
H A D | mysqli_stmt_bind_param.phpt | 24 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 116 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 118 mysqli_stmt_close($stmt); 338 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 343 printf("[2001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 348 printf("[2002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 363 $stmt->errno, $stmt->error); 366 if (!$stmt->execute()) 367 printf("[2006] [%d] %s\n", $stmt->errno, $stmt->error); 388 $values['id'], mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | 023.phpt | 28 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)"); 29 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7); 38 mysqli_stmt_execute($stmt); 39 mysqli_stmt_close($stmt); 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 43 mysqli_stmt_execute($stmt); 44 mysqli_stmt_fetch($stmt); 50 mysqli_stmt_close($stmt);
|
H A D | 024.phpt | 28 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)"); 29 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7); 39 mysqli_stmt_execute($stmt); 40 mysqli_stmt_close($stmt); 42 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 43 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 44 mysqli_stmt_execute($stmt); 45 mysqli_stmt_fetch($stmt); 51 mysqli_stmt_close($stmt);
|
/PHP-8.3/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_fetch_table_names.phpt | 17 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 18 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 19 $stmt->closeCursor(); 22 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 24 $stmt->closeCursor();
|
H A D | bug_pecl_12925.phpt | 22 $stmt = $db->prepare("UPDATE test SET id = 'b'"); 23 $stmt->execute(); 24 $stmt = $db->prepare("UPDATE test SET id = 'c'"); 25 $stmt->execute(); 26 $stmt = $db->prepare('SELECT id FROM test'); 27 $stmt->execute(); 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 29 $stmt->closeCursor();
|
H A D | pdo_mysql_prepare_native_placeholder_everywhere.phpt | 26 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC'); 27 $stmt->execute(array('id', 'label', 'label')); 28 if ('00000' !== $stmt->errorCode()) 30 var_export($stmt->errorCode(), true), 31 var_export($stmt->errorInfo(), true)); 32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 41 $stmt->execute(array('id', 'label', 'label')); 42 if ('00000' !== $stmt->errorCode()) 44 var_export($stmt->errorCode(), true), 45 var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_stmt_columncount.phpt | 26 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test"); 27 $stmt->execute(); 28 var_dump($stmt->columnCount()); 30 $stmt = $db->query('SELECT * FROM test'); 31 var_dump($stmt->columnCount()); 44 … $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test"); 45 $stmt->execute(); 46 var_dump($stmt->columnCount()); 48 $stmt = $db->query('SELECT * FROM test'); 49 var_dump($stmt->columnCount());
|
H A D | pdo_mysql_prepare_native.phpt | 21 $stmt = @$db->prepare($query); 23 $stmt = $db->prepare($query); 45 if (!is_object($stmt)) 55 $ret = $stmt->execute($input_params); 61 $tmp = $stmt->errorInfo(); 95 return $stmt; 118 $row = $stmt->fetch(PDO::FETCH_ASSOC); 171 if (is_object($stmt)) { 240 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); 302 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); [all …]
|
/PHP-8.3/ext/mysqlnd/ |
H A D | mysqlnd_ps_codec.c | 551 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_prepare_param_types() 651 if (Z_ISREF(stmt->param_bind[j].zv) && Z_REFVAL(stmt->param_bind[j].zv) == the_var) { in mysqlnd_stmt_execute_calculate_param_values_size() 664 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_calculate_param_values_size() 802 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local 815 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 839 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params() 841 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 857 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 878 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local 886 int4store(p, stmt->stmt_id); in mysqlnd_stmt_execute_generate_request() [all …]
|
/PHP-8.3/ext/pdo/tests/ |
H A D | pdo_038.phpt | 17 function fetchColumn($stmt, $index) { 18 $stmt->execute(); 19 return $stmt->fetchColumn($index); 34 $stmt = $conn->prepare($query); 37 var_dump(fetchColumn($stmt, -1)); 41 var_dump(fetchColumn($stmt, 0)); 43 var_dump(fetchColumn($stmt, 1));
|
H A D | pdo_032.phpt | 25 $stmt = $db->prepare('SELECT * from test'); 26 $stmt->execute(); 27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt->closeCursor(); 32 $stmt = $db->prepare('SELECT * from test'); 33 $stmt->execute(); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 35 $stmt->closeCursor();
|
H A D | gh8626.phpt | 28 $stmt = $db->prepare('INSERT INTO test VALUES(?)'); 31 var_dump($stmt->execute([null]), $stmt->errorCode()); 32 $errorInfo = $stmt->errorInfo(); 35 $stmt->closeCursor(); // sqlite 38 var_dump($stmt->execute([1]), $stmt->errorCode()); 39 $errorInfo = $stmt->errorInfo();
|
H A D | debug_emulated_prepares.phpt | 24 $stmt = $db->query('SELECT 1'); 27 var_dump($stmt->debugDumpParams()); 29 $stmt = $db->prepare('SELECT :bool, :int, :string, :null'); 30 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL); 31 $stmt->bindValue(':int', 123, PDO::PARAM_INT); 32 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR); 33 $stmt->bindValue(':null', null, PDO::PARAM_NULL); 34 $stmt->execute(); 37 var_dump($stmt->debugDumpParams());
|
H A D | pdo_012.phpt | 24 $stmt = $db->query($SELECT, PDO::FETCH_NUM); 25 var_dump($stmt->fetchAll()); 38 unset($stmt); 40 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test'); 41 var_dump($stmt->fetchAll()); 43 unset($stmt); 45 $stmt = $db->query($SELECT, PDO::FETCH_NUM); 46 $stmt->setFetchMode(PDO::FETCH_CLASS, 'Test', array('Changed')); 47 var_dump($stmt->fetchAll());
|
/PHP-8.3/ext/oci8/tests/ |
H A D | statement_cache.phpt | 20 $stmt = oci_parse($pc, "select 1+3 from dual"); 21 oci_execute($stmt); 22 var_dump(oci_fetch_array($stmt)); 24 $stmt = oci_parse($pc, "select 1+3 from dual"); 25 oci_execute($stmt); 26 var_dump(oci_fetch_array($stmt));
|
/PHP-8.3/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_client_identifier.phpt | 20 $stmt = $dbh->query($query); 21 $row = $stmt->fetch(); 27 $stmt = $dbh->query($query); 28 $row = $stmt->fetch(); 34 $stmt = $dbh->query($query); 35 $row = $stmt->fetch(); 41 $stmt = $dbh->query($query); 42 $row = $stmt->fetch();
|
H A D | pdo_oci_attr_client_info.phpt | 20 $stmt = $dbh->query($query); 21 $row = $stmt->fetch(); 27 $stmt = $dbh->query($query); 28 $row = $stmt->fetch(); 34 $stmt = $dbh->query($query); 35 $row = $stmt->fetch(); 41 $stmt = $dbh->query($query); 42 $row = $stmt->fetch();
|
/PHP-8.3/ext/pdo/ |
H A D | pdo_sql_parser.re | 142 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "mixed named and positional parameters"); 147 params = stmt->bound_params; 172 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) { 218 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined"); 221 if (stmt->dbh->methods->quoter) { 240 plc->quoted = stmt->dbh->methods->quoter(stmt->dbh, buf, param->param_type); 248 strncpy(stmt->error_code, stmt->dbh->error_code, 6); 253 pdo_raise_impl_error(stmt->dbh, stmt, "HY105", "Expected a stream resource"); 285 strncpy(stmt->error_code, stmt->dbh->error_code, 6); 289 plc->quoted = stmt->dbh->methods->quoter(stmt->dbh, buf, param_type); [all …]
|
/PHP-8.3/ext/pdo_sqlite/tests/ |
H A D | bug_63916-2.phpt | 15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 16 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 17 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 18 $stmt->execute(); 20 $stmt = $conn->query('SELECT num FROM users'); 21 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
H A D | bug_63916.phpt | 15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 16 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 17 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 18 $stmt->execute(); 20 $stmt = $conn->query('SELECT num FROM users'); 21 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
/PHP-8.3/ext/sqlite3/tests/ |
H A D | sqlite3stmt_getsql.phpt | 12 $stmt = $db->prepare('SELECT :a, :b, ?;'); 14 $stmt->bindValue(':a', 42); 15 $stmt->bindValue(':b', 'php'); 16 $stmt->bindValue(3, 43); 19 var_dump($stmt->getSQL(false)); 22 var_dump($res = $stmt->execute());
|