Home
last modified time | relevance | path

Searched refs:query (Results 76 – 100 of 529) sorted by relevance

12345678910>>...22

/PHP-8.1/ext/pdo/tests/
H A Dpdo.inc3 function set_sql($name, $query)
7 $GLOBALS['SQL'][$name] = $query;
/PHP-8.1/ext/mysqli/tests/
H A Dbug77597.phpt16 $mysqli->query('DROP TABLE IF EXISTS test');
17 $mysqli->query('CREATE TABLE test (b int)');
18 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
H A Dmysqli_next_result_error.phpt2 Error in multi query
31 $mysqli->query("DROP PROCEDURE IF EXISTS p");
32 $mysqli->query('CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT 1; SELECT foobar FROM table_that_d…
48 $mysqli->query("DROP PROCEDURE IF EXISTS p");
H A Dmysqli_stmt_datatype_change.phpt23 $c1->query("use $db");
24 $c2->query("use $db");
25 $c1->query("drop table if exists type_change");
26 $c1->query("create table type_change(a int, b char(10)) ENGINE = " . $engine);
27 $c1->query("insert into type_change values (1, 'one'), (2, 'two')");
41 var_dump($c2->query("alter table type_change drop a"));
H A Dbug68077.phpt34 if (!$link->query("DROP TABLE IF EXISTS test")) {
38 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
45 if (!$link->query("SELECT 1 FROM DUAL"))
48 …if (!$link->query("LOAD DATA LOCAL INFILE '" . str_replace("\\", "/", __DIR__) . "/bug53503.data'…
56 if (!$link->query("LOAD DATA LOCAL INFILE '" . __DIR__ . "/bug53503.data' INTO TABLE test")) {
73 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
H A Dbug33491.phpt16 public function query_single($query) {
17 $result = parent::query($query);
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug62479.phpt54 $pdo->query($sql);
56 $result = $testConn->query($testQuery)->fetch();
61 $pdo->query($dropUser);
65 $pdo->query($sql);
68 $result = $testConn->query($testQuery)->fetch();
73 $pdo->query($dropUser);
/PHP-8.1/ext/standard/tests/url/
H A Dparse_url_basic_001.phpt144 ["query"]=>
155 ["query"]=>
166 ["query"]=>
179 ["query"]=>
225 ["query"]=>
304 ["query"]=>
330 ["query"]=>
345 ["query"]=>
356 ["query"]=>
369 ["query"]=>
[all …]
H A Dparse_url_unterminated.phpt150 ["query"]=>
161 ["query"]=>
172 ["query"]=>
185 ["query"]=>
231 ["query"]=>
310 ["query"]=>
336 ["query"]=>
351 ["query"]=>
362 ["query"]=>
375 ["query"]=>
[all …]
/PHP-8.1/ext/sqlite3/tests/
H A Dsqlite3_38_extended_error.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
30 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
H A Dsqlite3_enable_exceptions.phpt14 $db->query("SELECT * FROM non_existent_table");
19 $db->query("SELECT * FROM non_existent_table");
29 Warning: SQLite3::query(): no such table: non_existent_table in %s on line %d
H A Dexception_from_toString.phpt33 $query = $db->query("SELECT * FROM t");
34 while ($row = $query->fetchArray(SQLITE3_ASSOC)) {
/PHP-8.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_fetch_both.phpt16 function fetch($offset, &$db, $query, $expect = null) {
19 $stmt = $db->query('SELECT 1');
22 $stmt = $db->query('SELECT 1');
25 $stmt = $db->query('SELECT 1');
H A Dpdo_mysql_stmt_closecursor.phpt23 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
24 // query() shall fail!
25 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
30 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
34 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
57 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
59 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
62 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
158 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
163 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
[all …]
H A Dbug66141.phpt2 Bug #66141 (mysqlnd quote function is wrong with NO_BACKSLASH_ESCAPES after failed query)
19 $db->query('set session sql_mode="NO_BACKSLASH_ESCAPES"');
25 $db->query('something that throws an exception');
35 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
H A Dbug79596.phpt20 $pdo->query('CREATE TABLE bug79596 (broken FLOAT(2,1))');
21 $pdo->query('INSERT INTO bug79596 VALUES(4.9)');
22 var_dump($pdo->query('SELECT broken FROM bug79596')->fetchColumn(0));
H A Dpdo_mysql_errorcode.phpt31 or PDO->query() and invoke an error on the statement handle,
39 $stmt = $db->query('SELECT id, label FROM test');
51 @$stmt = $db->query('SELECT id, label FROM unknown');
55 $stmt = $db->query('SELECT id, label FROM test');
60 @$db->query('SELECT id, label FROM unknown');
/PHP-8.1/ext/pdo_firebird/tests/
H A Dbug_76452.phpt19 $query = $dbh->prepare("select * from test");
20 $query->execute();
21 var_dump($query->fetch());
/PHP-8.1/ext/pgsql/tests/
H A Dbug47199.phpt24 $query = pg_delete($dbh, $tbl_name, array('null_field' => NULL,'not_null_field' => 2), PGSQL_DML_ST…
26 echo $query, "\n";
28 $query = pg_update($dbh, $tbl_name, array('null_field' => NULL, 'not_null_field' => 0), array('not_…
30 echo $query, "\n";
/PHP-8.1/ext/oci8/tests/
H A Dlob_018.phpt45 $query = 'select * from lob_018_tab order by mykey asc';
46 $statement = oci_parse ($c, $query);
56 $query = 'select * from lob_018_tab order by mykey desc';
57 $statement = oci_parse ($c, $query);
76 $query = 'select * from lob_018_tab where mykey = 3';
77 $statement = oci_parse ($c, $query);
H A Dbug37220.phpt28 $query = "UPDATE bug37220_tab
31 $stmt = oci_parse ($c, $query);
41 $query = "select * from bug37220_tab";
42 $stmt = oci_parse ($c, $query);
/PHP-8.1/ext/dom/tests/
H A Dbug55700.phpt13 echo($xp->query('//prefix:root')->length . "\n");
18 echo($xp->query('//prefix:root')->length . "\n");
25 echo($xp->query('//prefix:root')->length . "\n");
/PHP-8.1/ext/pdo_oci/tests/
H A Dbug57702.phpt20 $query = "begin execute immediate 'drop table bug57702'; exception when others then if sqlcode <> -…
21 $stmt = $db->prepare($query);
24 $query = "create table bug57702 (id number, data1 blob, data2 blob)";
25 $stmt = $db->prepare($query);
67 foreach($db->query("select data1 as d1, data2 as d2 from bug57702 order by id") as $row) {
93 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
116 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
135 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
144 $query = "drop table bug57702";
145 $stmt = $db->prepare($query);
/PHP-8.1/ext/pdo_pgsql/
H A Dpgsql_driver.c598 char *query; in PHP_METHOD() local
633 efree(query); in PHP_METHOD()
634 query = NULL; in PHP_METHOD()
672 if (query) { in PHP_METHOD()
673 efree(query); in PHP_METHOD()
709 char *query; in PHP_METHOD() local
746 efree(query); in PHP_METHOD()
807 char *query; in PHP_METHOD() local
844 efree(query); in PHP_METHOD()
901 char *query; in PHP_METHOD() local
[all …]
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_tostring_exception.phpt37 $query = $db->query("SELECT * FROM t");
38 while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

Completed in 60 milliseconds

12345678910>>...22