Home
last modified time | relevance | path

Searched refs:query (Results 51 – 75 of 576) sorted by relevance

12345678910>>...24

/php-src/ext/mysqli/tests/
H A Dbug34785.phpt15 public function __construct($link, $query) {
16 parent::__construct($link, $query);
22 public function __construct($link, $query) {
23 parent::__construct($link, $query);
H A Dbug76386.phpt24 $link->query('DROP TABLE IF EXISTS ts_test;');
25 $link->query(
34 $link->query(
54 $link->query('DROP TABLE IF EXISTS t_test;');
55 $link->query(
61 $link->query(
65 $link->query('INSERT INTO t_test VALUES ();');
101 $link->query('DROP TABLE ts_test;');
102 $link->query('DROP TABLE t_test;');
H A Dbug53503.phpt2 Bug #53503 (mysqli::query returns false after successful LOAD DATA query)
29 if (!$link->query("DROP TABLE IF EXISTS test")) {
33 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
40 if (!$link->query("SELECT 1 FROM DUAL"))
43 if (!$link->query("LOAD DATA LOCAL INFILE 'bug53503.data' INTO TABLE test")) {
60 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
H A Dbug35103.phpt19 $mysql->query("DROP TABLE IF EXISTS test_bint");
20 $mysql->query("CREATE TABLE test_bint (a bigint(20) default NULL) ENGINE=MYISAM");
21 …$mysql->query("INSERT INTO test_bint VALUES (9223372036854775807),(-9223372036854775808),(-2147483…
23 $mysql->query("DROP TABLE IF EXISTS test_buint");
24 $mysql->query("CREATE TABLE test_buint (a bigint(20) unsigned default NULL)");
25 …$mysql->query("INSERT INTO test_buint VALUES (18446744073709551615),(9223372036854775807),(9223372…
H A Dgh11550.phpt2 Bug GH-11550 (MySQL Statement has a empty query result when the response field has changed, also Se…
15 $link->query(<<<'SQL'
23 $link->query(<<<'SQL'
30 $link->query(<<<'SQL'
43 $link->query('DROP TABLE IF EXISTS test_gh11550');
H A Dmysqli_last_insert_id.phpt20 if (!($res = $link->query("SELECT LAST_INSERT_ID() AS _id"))) {
34 if (!$link->query("DROP TABLE IF EXISTS test") ||
36 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
50 if (!($res = $link->query("SELECT 1 FROM DUAL")))
66 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
81 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
96 if (!$link->query("SET @myvar=1"))
109 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
117 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
125 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
[all …]
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdo_sqlite_createafunction_trampoline.phpt10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate_trampoline (a INTEGER, b INTEGER)');
12 $stmt = $db->query('INSERT INTO test_pdo_sqlite_createaggregate_trampoline VALUES (1, -1), (2, -2),…
23 foreach ($db->query('SELECT strtoupper("test")') as $row) {
27 foreach ($db->query('SELECT strtoupper("test")') as $row) {
H A Dpdo_sqlite_createcollation.phpt12 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)');
14 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10…
18 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL…
23 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
H A Dpdosqlite_002.phpt13 $db->query('CREATE TABLE pdosqlite_002 (id INT AUTO INCREMENT, name TEXT)');
14 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP")');
15 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP6")');
19 foreach ($db->query('SELECT testing(name) FROM pdosqlite_002') as $row) {
/php-src/ext/pdo_mysql/tests/
H A Dpdomysql_001.phpt17 $db->query('CREATE TABLE pdomysql_001 (id INT, name TEXT)');
19 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP")');
20 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP6")');
22 foreach ($db->query('SELECT name FROM pdomysql_001') as $row) {
H A Dlast_insert_id.phpt15 print_r($db->query("CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)")…
17 print_r($db->query("INSERT INTO test_last_insert_id (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test_last_insert_id (num) VALUES (451)"));
27 $db->query('DROP TABLE IF EXISTS test_last_insert_id');
H A Dbug75177.phpt16 $pdo->query("CREATE TABLE test_75177 (`bit` BIT(8)) ENGINE=InnoDB");
17 $pdo->query("INSERT INTO test_75177 (`bit`) VALUES (1), (0b011), (0b01100)");
20 $ret = $pdo->query("SELECT * FROM test_75177")->fetchAll();
26 $ret = $pdo->query("SELECT * FROM test_75177")->fetchAll();
/php-src/ext/pdo_pgsql/tests/
H A Dpdopgsql_001.phpt19 $db->query('CREATE TABLE pdopgsql_001 (id INT, name TEXT)');
20 $db->query("INSERT INTO pdopgsql_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')");
22 foreach ($db->query('SELECT name FROM pdopgsql_001') as $row) {
32 $pdo->query("DROP TABLE IF EXISTS pdopgsql_001");
/php-src/ext/pdo_dblib/tests/
H A Dpdodblib_002.phpt20 $db->query("CREATE TABLE #pdo_dblib_002(name VARCHAR(32))");
21 $db->query("INSERT INTO #pdo_dblib_002 VALUES('PHP'), ('PHP6')");
23 foreach ($db->query('SELECT name FROM #pdo_dblib_002') as $row) {
33 $db->query('DROP TABLE IF EXISTS #pdo_dblib_002');
/php-src/ext/dom/tests/modern/html/parser/
H A DHTMLDocument_fromString_DOM_HTML_NO_DEFAULT_NS.phpt11 var_dump($xpath->query("//p"));
12 var_dump($xpath->query("//x:p"));
17 var_dump($xpath->query("//p"));
18 var_dump($xpath->query("//x:p"));
H A DHTMLDocument_fromFile_DOM_HTML_NO_DEFAULT_NS.phpt11 var_dump($xpath->query("//p"));
12 var_dump($xpath->query("//x:p"));
17 var_dump($xpath->query("//p"));
18 var_dump($xpath->query("//x:p"));
/php-src/ext/mbstring/tests/
H A Dmb_parse_str_error.phpt14 foreach ($queries as $query) {
15 echo "Query: " . bin2hex($query) . "\n";
18 mb_parse_str($query, $array);
/php-src/ext/pdo_firebird/tests/
H A Dexecute_block.phpt34 $query = $dbh->prepare($sql);
35 $query->execute(['d' => 1, 'e' => 2]);
36 $row = $query->fetch(\PDO::FETCH_OBJ);
40 unset($query);
H A Dpdofirebird_001.phpt17 $db->query('CREATE TABLE pdofirebird_001 (idx INT NOT NULL PRIMARY KEY, name VARCHAR(20))');
18 $db->query("INSERT INTO pdofirebird_001 VALUES (1, 'PHP')");
19 $db->query("INSERT INTO pdofirebird_001 VALUES (2, 'PHP6')");
21 foreach ($db->query('SELECT name FROM pdofirebird_001') as $row) {
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_lastinsertid.phpt9 $db->query('CREATE TABLE test_pdo_sqlite_lastinsertid (id INT AUTO INCREMENT, name TEXT)');
10 $db->query('INSERT INTO test_pdo_sqlite_lastinsertid VALUES (NULL, "PHP"), (NULL, "PHP6")');
11 var_dump($db->query('SELECT * FROM test_pdo_sqlite_lastinsertid'));
H A Dgh13998.phpt14 $db->query('CREATE TABLE test (a int, b int)');
15 $stmt = $db->query('INSERT INTO test VALUES (1, 1), (2, 2), (3, 3)');
19 $db->query('SELECT S(a) FROM test');
H A Dpdo_sqlite_createaggregate.phpt10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO test_pdo_sqlite_createaggregate VALUES (NULL, "PHP"), (NULL, "PHP6")');
17 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createaggregate') as $row) {
/php-src/ext/pdo/tests/
H A Dpdo_038.phpt23 $query = 'SELECT 1';
27 $query .= ' FROM DUAL';
30 $query .= ' FROM RDB$DATABASE';
34 $stmt = $conn->prepare($query);
/php-src/Zend/tests/
H A Dbug31177.phpt7 public function query() {
12 return new DbGowRecordSet($this->query());
16 new DbGowRecordSet($this->query());
/php-src/ext/phar/tests/files/
H A Dpear2coverage.phar1069 $result = $this->db->query($query);
1086 $result = $this->db->query($query);
1117 $result = $this->db->query($query);
1136 $result = $this->db->query($query);
1166 $result = $this->db->query($query);
1179 $result = $this->db->query($query);
1212 $result = $this->db->query($query);
1227 $result = $this->db->query($query);
1248 $result = $this->db->query($query);
1389 $result = $this->db->query($query);
[all …]

Completed in 52 milliseconds

12345678910>>...24