Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.0/ext/sqlite3/tests/
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.0/ext/pdo_mysql/tests/
H A Dpdo_mysql_fetch_both.phpt15 function fetch($offset, &$db, $query, $expect = null) {
18 $stmt = $db->query('SELECT 1');
21 $stmt = $db->query('SELECT 1');
24 $stmt = $db->query('SELECT 1');
H A Dbug79596.phpt18 $pdo->query('CREATE TABLE bug79596 (broken FLOAT(2,1))');
19 $pdo->query('INSERT INTO bug79596 VALUES(4.9)');
20 var_dump($pdo->query('SELECT broken FROM bug79596')->fetchColumn(0));
H A Dbug66141.phpt2 Bug #66141 (mysqlnd quote function is wrong with NO_BACKSLASH_ESCAPES after failed query)
18 $db->query('set session sql_mode="NO_BACKSLASH_ESCAPES"');
24 $db->query('something that throws an exception');
34 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
H A Dpdo_mysql_stmt_closecursor.phpt22 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
23 // query() shall fail!
24 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
29 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
33 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
56 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
58 $stmt2 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
61 $stmt1 = $db->query('SELECT id, label FROM test ORDER BY id ASC');
157 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
162 …query(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered querie…
[all …]
H A Dlast_insert_id.phpt15 print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)"));
17 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test (num) VALUES (451)"));
/PHP-8.0/ext/mysqli/tests/
H A Dmysqli_next_result_error.phpt2 Error in multi query
30 $mysqli->query("DROP PROCEDURE IF EXISTS p");
31 $mysqli->query('CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT 1; SELECT foobar FROM table_that_d…
47 $mysqli->query("DROP PROCEDURE IF EXISTS p");
H A Dbug77956.phpt26 if (!$link->query("DROP TABLE IF EXISTS test")) {
29 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
34 if (!$link->query("SELECT 1 FROM DUAL"))
36 if (!$link->query("LOAD DATA LOCAL INFILE 'bug77956.data' INTO TABLE test")) {
51 if (!$link->query('DROP TABLE IF EXISTS test')) {
58 Warning: mysqli::query(): LOAD DATA LOCAL INFILE forbidden in %s on line %d
H A Dbug33491.phpt15 public function query_single($query) {
16 $result = parent::query($query);
H A Dbug68077.phpt33 if (!$link->query("DROP TABLE IF EXISTS test")) {
37 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
44 if (!$link->query("SELECT 1 FROM DUAL"))
47 …if (!$link->query("LOAD DATA LOCAL INFILE '" . str_replace("\\", "/", __DIR__) . "/bug53503.data'…
55 if (!$link->query("LOAD DATA LOCAL INFILE '" . __DIR__ . "/bug53503.data' INTO TABLE test")) {
72 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
H A Dmysqli_stmt_datatype_change.phpt22 $c1->query("use $db");
23 $c2->query("use $db");
24 $c1->query("drop table if exists type_change");
25 $c1->query("create table type_change(a int, b char(10)) ENGINE = " . $engine);
26 $c1->query("insert into type_change values (1, 'one'), (2, 'two')");
40 var_dump($c2->query("alter table type_change drop a"));
/PHP-8.0/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");
H A Dbug75451.phpt2 Bug #75451 (Assertion fails while foreach on empty xpath query)
12 foreach($xpath->query('/root/noexist') as $child) {
H A Dbug69373.phpt2 Bug #69373 References to deleted XPath query results
11 $all = $xpath->query('//*');
H A DDOMNode_C14N_basic.phpt34 var_dump($node->C14N(false, false, ['query' => []]));
41 DOMNode::C14N(): Argument #3 ($xpath) must have a "query" key
42 DOMNode::C14N(): Argument #3 ($xpath) "query" option must be a string, array given
/PHP-8.0/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.phpt152 ["query"]=>
163 ["query"]=>
174 ["query"]=>
187 ["query"]=>
233 ["query"]=>
312 ["query"]=>
338 ["query"]=>
353 ["query"]=>
364 ["query"]=>
377 ["query"]=>
[all …]
/PHP-8.0/ext/pdo_pgsql/tests/
H A Dbug62479.phpt52 $pdo->query($sql);
54 $result = $testConn->query($testQuery)->fetch();
59 $pdo->query($dropUser);
63 $pdo->query($sql);
66 $result = $testConn->query($testQuery)->fetch();
71 $pdo->query($dropUser);
/PHP-8.0/ext/oci8/tests/
H A Dlob_018.phpt43 $query = 'select * from lob_018_tab order by mykey asc';
44 $statement = oci_parse ($c, $query);
54 $query = 'select * from lob_018_tab order by mykey desc';
55 $statement = oci_parse ($c, $query);
74 $query = 'select * from lob_018_tab where mykey = 3';
75 $statement = oci_parse ($c, $query);
/PHP-8.0/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)) {
/PHP-8.0/ext/pdo/tests/
H A Dbug_69356.phpt2 PDO Common: Bug #69356 (PDOStatement::debugDumpParams() truncates query)
8 if (!strncasecmp(getenv('PDOTEST_DSN'), 'oci', strlen('oci'))) die('skip query not supported');
19 $stmt = $db->query("
21 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
33 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
/PHP-8.0/ext/mysqli/
H A Dmysqli_report.c52 void php_mysqli_report_index(const char *query, unsigned int status) { in php_mysqli_report_index() argument
62 php_mysqli_throw_sql_exception("00000", 0, "%s used in query/prepared statement %s", index, query); in php_mysqli_report_index()
/PHP-8.0/ext/soap/tests/
H A Dbug80672.phpt9 $query = $soap->query(array('sXML' => 'something'));
/PHP-8.0/ext/pdo_oci/tests/
H A Dbug57702.phpt18 $query = "begin execute immediate 'drop table bug57702'; exception when others then if sqlcode <> -…
19 $stmt = $db->prepare($query);
22 $query = "create table bug57702 (id number, data1 blob, data2 blob)";
23 $stmt = $db->prepare($query);
65 foreach($db->query("select data1 as d1, data2 as d2 from bug57702 order by id") as $row) {
91 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
114 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
133 foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
142 $query = "drop table bug57702";
143 $stmt = $db->prepare($query);

Completed in 53 milliseconds

12345678910>>...20