/PHP-8.1/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_action.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_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.1/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated.phpt | 22 $stmt = @$db->prepare($query); 24 $stmt = $db->prepare($query); 50 $ret = @$stmt->execute($input_params); 52 $ret = $stmt->execute($input_params); 59 $tmp = $stmt->errorInfo(); 85 return $stmt; 100 $stmt = prepex(4, $db, 'SELECT 1 as "one"'); 101 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 297 $stmt = prepex(79, $db, $sql, array(-1)); 304 $stmt = prepex(81, $db, $sql, array(1)); [all …]
|
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 …]
|
/PHP-8.1/ext/mysqli/tests/ |
H A D | mysqli_stmt_execute_stored_proc_out.phpt | 34 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)')) 39 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out)) 40 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt)) 43 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt)) 50 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 58 if (!mysqli_stmt_close($stmt)) 59 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
|
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 | 26 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 118 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 120 mysqli_stmt_close($stmt); 340 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 345 printf("[2001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 350 printf("[2002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 365 $stmt->errno, $stmt->error); 368 if (!$stmt->execute()) 369 printf("[2006] [%d] %s\n", $stmt->errno, $stmt->error); 390 $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.1/ext/oci8/tests/ |
H A D | statement_cache.phpt | 19 $stmt = oci_parse($pc, "select 1+3 from dual"); 20 oci_execute($stmt); 21 var_dump(oci_fetch_array($stmt)); 23 $stmt = oci_parse($pc, "select 1+3 from dual"); 24 oci_execute($stmt); 25 var_dump(oci_fetch_array($stmt));
|
/PHP-8.1/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.1/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 | 27 $stmt = $db->prepare('INSERT INTO test VALUES(?)'); 30 var_dump($stmt->execute([null]), $stmt->errorCode()); 31 $errorInfo = $stmt->errorInfo(); 34 $stmt->closeCursor(); // sqlite 37 var_dump($stmt->execute([1]), $stmt->errorCode()); 38 $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());
|
/PHP-8.1/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.1/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());
|
/PHP-8.1/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.1/ext/pdo_pgsql/tests/ |
H A D | bug46274.phpt | 26 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)"); 33 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 34 $stmt->execute(); 37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 38 $stmt->execute(); 45 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 46 $stmt->execute(); 49 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 50 $stmt->execute();
|