Home
last modified time | relevance | path

Searched refs:query (Results 26 – 50 of 427) sorted by relevance

12345678910>>...18

/PHP-7.0/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_lastinsertid.phpt9 $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
12 var_dump($db->query('SELECT * FROM foo'));
16 $db->query('DROP TABLE foo');
H A Dpdo_sqlite_createaggregate.phpt10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
18 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
22 $db->query('DROP TABLE foobar');
H A Dpdo_sqlite_createfunction.phpt10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
19 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
23 $db->query('DROP TABLE foobar');
H A Dpdo_fetch_func_001.phpt15 $st = $db->query('SELECT * FROM testing');
18 $st = $db->query('SELECT name FROM testing');
21 $st = $db->query('SELECT * FROM testing');
24 $st = $db->query('SELECT * FROM testing');
27 $st = $db->query('SELECT * FROM testing');
30 $st = $db->query('SELECT * FROM testing');
33 $st = $db->query('SELECT * FROM testing');
62 $st = $db->query('SELECT * FROM testing');
65 $st = $db->query('SELECT * FROM testing');
68 $st = $db->query('SELECT * FROM testing');
[all …]
/PHP-7.0/ext/pdo_dblib/tests/
H A Dtimeout.phpt2 PDO_DBLIB: Set query timeouts
21 … timeout attribute, set after instance created, will affect query timeout, causing this query to f…
34 …timeout attribute, set after instance created, will control query timeout, causing this query to f…
47 // regular timeout attribute will affect query timeout, causing this query to fail
59 // pdo_dblib-specific timeout attribute will control query timeout, causing this query to fail
H A Dbug_68957.phpt2 PDO_DBLIB bug #68957 PDO::query doesn't support several queries
12 $query = "declare @myInt int = 1; select @myInt;";
13 $stmt = $db->query($query);
/PHP-7.0/ext/mysqli/tests/
H A Dmysqli_autocommit_oo.phpt31 if (!$mysqli->query('SET AUTOCOMMIT = 0'))
52 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
59 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
62 if (!$mysqli->query('ROLLBACK'))
74 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
77 if (!$mysqli->query('SET AUTOCOMMIT = 1'))
95 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
98 if (!$mysqli->query('ROLLBACK'))
108 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
111 if (!$mysqli->query('COMMIT'))
[all …]
H A Dmysqli_affected_rows_oo.phpt25 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
38 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
48 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
54 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
67 if (!$mysqli->query("REPLACE INTO test(id, label) values (4, 'd')"))
73 if (!$mysqli->query("REPLACE INTO test(id, label) values (5, 'e')"))
79 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
85 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
92 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
[all …]
H A Dmysqli_pam_sha256_public_key_option_invalid.phpt23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
59 if (!$link->query("SET @@session.old_passwords=2")) {
63 $link->query('DROP USER shatest');
64 $link->query("DROP USER shatest@localhost");
77 if (!$link->query("DROP TABLE IF EXISTS test") ||
78 !$link->query("CREATE TABLE test (id INT)") ||
79 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
107 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
170 $link->query('DROP USER shatest');
[all …]
H A Dbug53503.phpt2 Bug #53503 (mysqli::query returns false after successful LOAD DATA query)
26 if (!$link->query("DROP TABLE IF EXISTS test")) {
30 …if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)…
37 if (!$link->query("SELECT 1 FROM DUAL"))
40 if (!$link->query("LOAD DATA LOCAL INFILE 'bug53503.data' INTO TABLE test")) {
57 if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
H A Dbug52082.phpt17 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
18 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
20 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
21 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
H A Dbug35103.phpt18 $mysql->query("DROP TABLE IF EXISTS test_bint");
19 $mysql->query("CREATE TABLE test_bint (a bigint(20) default NULL) ENGINE=MYISAM");
20 …$mysql->query("INSERT INTO test_bint VALUES (9223372036854775807),(-9223372036854775808),(-2147483…
22 $mysql->query("DROP TABLE IF EXISTS test_buint");
23 $mysql->query("CREATE TABLE test_buint (a bigint(20) unsigned default NULL)");
24 …$mysql->query("INSERT INTO test_buint VALUES (18446744073709551615),(9223372036854775807),(9223372…
H A Dbug34785.phpt14 public function __construct($link, $query) {
15 parent::__construct($link, $query);
21 public function __construct($link, $query) {
22 parent::__construct($link, $query);
H A Dmysqli_expire_password.phpt42 if (!$link->query("DROP TABLE IF EXISTS test") ||
43 !$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)"))
65 $link->query("SELECT id FROM test WHERE id = 1");
76 $link->query("SELECT id FROM test WHERE id = 1");
87 $link->query("SELECT id FROM test WHERE id = 1");
88 printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error);
99 $link->query("SET PASSWORD=PASSWORD('expiretest')");
101 if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
112 $link->query("SELECT id FROM test WHERE id = 1");
113 if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
[all …]
H A Dmysqli_last_insert_id.phpt19 if (!($res = $link->query("SELECT LAST_INSERT_ID() AS _id"))) {
33 if (!$link->query("DROP TABLE IF EXISTS test") ||
35 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
49 if (!($res = $link->query("SELECT 1 FROM DUAL")))
65 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
80 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
95 if (!$link->query("SET @myvar=1"))
108 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
116 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
124 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
[all …]
/PHP-7.0/ext/sqlite3/tests/
H A Dsqlite3stmt_reset_params.phpt18 $query = "SELECT name FROM foobar WHERE id = 1";
20 echo "Prepare query\n";
21 $stmt = $db->prepare($query);
23 echo "Reset query\n";
41 Prepare query
42 Reset query
H A Dsqlite3stmt_paramCount_basic.phpt27 foreach($queryArray as $key => $query) {
28 $stmt = $db->prepare($query);
30 echo 'Param count for query ' . ($key + 1) . ":\n";
49 Param count for query 1:
51 Param count for query 2:
53 Param count for query 3:
55 Param count for query 4:
/PHP-7.0/ext/standard/tests/url/
H A Dbug69976.phpt14 ["query"]=>
20 ["query"]=>
26 ["query"]=>
32 ["query"]=>
/PHP-7.0/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_multi_statements.phpt26 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
32 // A single query with a trailing delimiter.
33 $stmt = $db->query('SELECT 1 AS value;');
38 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (3)', $table, $table));
43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
45 // A single query with a trailing delimiter.
46 $stmt = $db->query('SELECT 1 AS value;');
/PHP-7.0/ext/mbstring/tests/
H A Dmb_parse_str.phpt16 function test($query) {
19 mb_parse_str($query, $array);
23 mb_parse_str($query);
27 foreach ($queries as $query) {
28 test($query);
H A Dmb_parse_str02.phpt16 function test($query) {
20 mb_parse_str($query, $array);
25 mb_parse_str($query);
30 foreach ($queries as $query) {
31 test($query);
/PHP-7.0/ext/oci8/tests/
H A Dbug38161.phpt10 $query = "begin if false then :bv := 1; end if; end;";
11 $stid = oci_parse($c, $query);
18 $query = "begin if false then :bv := 1; end if; end;";
19 $stid = oci_parse($c, $query);
/PHP-7.0/ext/pdo_pgsql/tests/
H A Dbug43925.phpt15 @$dbh->query('DROP TABLE nodes');
17 $dbh->query('
26 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);');
27 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);');
28 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
53 $dbh->query('DROP TABLE nodes');
/PHP-7.0/ext/pdo/
H A Dpdo.php8 $x->query("create table test(name string, value string)");
28 foreach ($x->query("select NAME, VALUE from test") as $row) {
40 foreach ($x->query("select NAME, VALUE from test", PDO_FETCH_COLUMN, 1) as $row) {
/PHP-7.0/Zend/tests/
H A Dbug31177.phpt7 public function query() {
12 return new DbGowRecordSet($this->query());
16 new DbGowRecordSet($this->query());

Completed in 27 milliseconds

12345678910>>...18