Home
last modified time | relevance | path

Searched refs:query (Results 176 – 200 of 601) sorted by relevance

12345678910>>...25

/php-src/ext/mysqli/tests/
H A Dmysqli_reap_async_query.phpt39 … printf("[%03d + 4] Cannot fetch and no error set - non resultset query (no SELECT)!\n", $offset);
53 // Connections on which no query has been sent - 1
55 $link->query("SELECT 1 AS _one", MYSQLI_ASYNC | MYSQLI_STORE_RESULT);
63 $link->query("SELECT 2 AS _two", MYSQLI_ASYNC | MYSQLI_USE_RESULT);
H A Dbug35517.phpt15 $mysql->query("CREATE TABLE temp (id INT UNSIGNED NOT NULL)");
16 … $mysql->query("INSERT INTO temp (id) VALUES (3000000897),(3800001532),(3900002281),(3100059612)");
34 $mysql->query("DROP TABLE temp");
H A Dbug35759.phpt16 $mysql->query("DROP TABLE IF EXISTS test");
24 if (!$mysql->query($create)) {
33 if (!$mysql->query("INSERT INTO test (a0) VALUES ('')"))
H A Dmysqli_fetch_assoc_oo.phpt15 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
27 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
28 printf("[007] Cannot run query, [%d] %s\n", $mysqli->errno, $mysqli->error);
H A Dbug51647.phpt22 if ($res = $link->query('SHOW VARIABLES LIKE "have_ssl"')) {
25 if ($link->errno == 1064 && ($res = $link->query("SHOW VARIABLES"))) {
54 if (!$res = $link->query('SHOW STATUS like "Ssl_cipher"')) {
57 if ($res = $link->query("SHOW STATUS")) {
84 if (!$res = $link->query('SHOW STATUS like "Ssl_cipher"')) {
87 if ($res = $link->query("SHOW STATUS")) {
H A Dmysqli_fetch_all_oo.phpt13 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
21 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
29 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
37 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
48 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
58 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
59 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error);
65 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) {
66 printf("[018] Cannot run query, [%d] %s\n",
84 if (!$link->query("DROP TABLE IF EXISTS test")) {
[all …]
H A Dmysqli_allow_local_infile_overrides_local_infile_directory.phpt31 if (!$link->query("DROP TABLE IF EXISTS test")) {
35 if (!$link->query("CREATE TABLE test (id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)) {
40 if (!$link->query("LOAD DATA LOCAL INFILE '".$filepath."' INTO TABLE test")) {
69 if (!$link->query('DROP TABLE IF EXISTS test')) {
H A Dmysqli_local_infile_directory_vs_open_basedir.phpt31 if (!$link->query("DROP TABLE IF EXISTS test")) {
35 if (!$link->query("CREATE TABLE test (id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)) {
40 if (!$link->query("LOAD DATA LOCAL INFILE '".$filepath."' INTO TABLE test")) {
57 if (!$link->query('DROP TABLE IF EXISTS test')) {
/php-src/ext/pdo_pgsql/tests/
H A Dbug46274_2.phpt19 @$db->query("SET bytea_output = 'escape'");
23 $db->query('CREATE TABLE test_one_blob_46274_2 (id SERIAL NOT NULL, blob1 BYTEA)');
51 $res = $db->query("SELECT blob1 from test_one_blob_46274_2");
71 $db->query('DROP TABLE IF EXISTS test_one_blob_46274_2');
/php-src/ext/pdo_mysql/tests/
H A Dbug63185.phpt26 $st = $pdo->query("CALL {$procedure}()");
36 $st = $pdo->query("CALL {$procedure}()");
49 $pdo->query('DROP PROCEDURE IF EXISTS test_procedure_error_at_second_63185');
H A Dbug_74376.phpt20 $stmt = $db->query("SELECT (SELECT 1 UNION SELECT 2)");
26 Warning: PDO::query(): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 ro…
H A Dpdo_mysql_pconnect.phpt24 $stmt = $db2->query('SELECT @pdo_persistent_connection AS _pers');
29 $stmt = $db1->query('SELECT CONNECTION_ID() AS _con1');
33 $stmt = $db2->query('SELECT CONNECTION_ID() AS _con2');
43 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1');
67 $stmt = $db1->query('SELECT CONNECTION_ID() AS _con1');
73 $stmt = $db2->query('SELECT CONNECTION_ID() AS _con2');
H A Dpdo_mysql_closecursor_error.phpt2 Error during closeCursor() of multi query
16 $stmt = $db->query('SELECT 1; SELECT x FROM does_not_exist');
H A Dpdo_mysql_inTransaction.phpt21 foreach (['exec', 'query', 'execute'] as $w) {
27 case'query':
28 $db->query($command)->execute();
62 // DDL query causes an implicit commit.
H A Dpdo_mysql_subclass.phpt28 public function query(...$args): PDOStatement|false {
30 return parent::query(...$args);
58 $stmt = $db->query('SELECT * FROM test_subclass ORDER BY id ASC');
84 query('SELECT * FROM test_subclass ORDER BY id ASC')
H A Dpdo_mysql_stmt_fetchobject_ctor_args.phpt12 $query = "SELECT '', NULL, \"\" FROM DUAL";
13 $stmt = $db->prepare($query);
30 $query = "SELECT id FROM {$table} ORDER BY id ASC LIMIT 1";
31 $stmt = $db->prepare($query);
H A Dbug66878.phpt17 $stmt = $pdo->query($sql);
23 $stmt = $pdo->query($sql);
H A Dbug79872.phpt2 Bug #79872: Can't execute query with pending result sets
20 var_dump($db->query('SELECT @foo')->fetchAll());
H A Dbug_33689.phpt2 PDO MySQL Bug #33689 (query() execute() and fetch() return false on valid select queries)
18 var_dump($db->query('SELECT * FROM test_33689'));
19 foreach ($db->query('SELECT * FROM test_33689') as $row) {
/php-src/ext/mysqlnd/
H A Dmysqlnd_connection.c1022 char * query; local
1748 char * query; local
1759 if (!query) {
1764 enum_func_status ret = conn->m->query(conn, query, query_len);
1798 char * query; local
1805 if (!query) {
1810 enum_func_status ret = conn->m->query(conn, query, query_len);
1833 char *query; local
1835 if (!query) {
1858 char *query; local
[all …]
/php-src/ext/sqlite3/tests/
H A Dsqlite3_16_select_no_results.phpt2 SQLite3::query SELECT with no results
15 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
H A Dsqlite3_20_error.phpt11 $result = $db->query("SELECT * FROM non_existent_table");
23 Warning: SQLite3::query(): Unable to prepare statement: no such table: non_existent_table in %s on …
H A Dsqlite3_04_update.phpt2 SQLite3::query UPDATE tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
H A Dsqlite3_05_delete.phpt2 SQLite3::query DELETE tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
/php-src/ext/dom/tests/
H A Dphp_function_edge_cases.phpt14 $xpath->query("//a[php:function(3)]");
19 $xpath->query("//a[php:function()]");

Completed in 31 milliseconds

12345678910>>...25