Home
last modified time | relevance | path

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

12345678910>>...24

/php-src/ext/mysqli/tests/
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_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')) {
H A Dmysqli_pconn_limits.phpt18 printf("[001] Cannot run query, [%d] %s\n",
30 printf("[003] Cannot run query, [%d] %s\n",
44 printf("[005] Cannot run query, [%d] %s\n",
57 printf("[007] Cannot run query, [%d] %s\n",
71 printf("[009] Cannot run query, [%d] %s\n",
H A Dbug52891.phpt17 if (!$link->query("DROP TABLE IF EXISTS tuint") ||
18 !$link->query("DROP TABLE IF EXISTS tsint")) {
22 if (!$link->query("CREATE TABLE tuint(a BIGINT UNSIGNED) ENGINE=" . $engine) ||
23 !$link->query("CREATE TABLE tsint(a BIGINT) ENGINE=" . $engine)) {
82 $result = $link->query("SELECT * FROM tsint ORDER BY a ASC");
83 $result2 = $link->query("SELECT * FROM tuint ORDER BY a ASC");
H A Dbug55283.phpt22 if ($res = $link->query('SHOW VARIABLES LIKE "have_ssl"')) {
25 if ($link->errno == 1064 && ($res = $link->query("SHOW VARIABLES"))) {
54 $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'");
62 $r2 = $link2->query("SHOW STATUS LIKE 'Ssl_cipher'");
H A Dbug34810.phpt24 $mysql->query("DROP TABLE IF EXISTS test_warnings");
25 $mysql->query("CREATE TABLE test_warnings (a int not null)");
26 $mysql->query("SET sql_mode=''");
27 $mysql->query("INSERT INTO test_warnings VALUES (1),(2),(NULL)");
/php-src/ext/pdo_mysql/tests/
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 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_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 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_exec_load_data.phpt12 $stmt = $db->query('SELECT USER() as _user');
20 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'");
64 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'");
79 $stmt = $db->query('SELECT id, col1 FROM test_mysql_exec_load_data ORDER BY id ASC');
102 $db->query('DROP TABLE IF EXISTS test_mysql_exec_load_data');
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) {
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());
/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_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");
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 Dbug69972.phpt9 $result = $db->query("SELECT * FROM non_existent_table");
21 Warning: SQLite3::query(): Unable to prepare statement: no such table: non_existent_table in %sbug6…
/php-src/ext/dom/tests/
H A Dphp_function_edge_cases.phpt14 $xpath->query("//a[php:function(3)]");
19 $xpath->query("//a[php:function()]");
H A Dbug36756.phpt12 $node = $xpath->query('/root')->item(0);
19 $node = $xpath->query('//child')->item(0);
/php-src/ext/pdo/tests/
H A Dpdo_030.phpt53 function query($sql, ...$rest): PDOStatement|false
56 return parent::query($sql);
78 $stmt = $db->query('SELECT * FROM test030');
115 PDODatabase::query()

Completed in 31 milliseconds

12345678910>>...24