Home
last modified time | relevance | path

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

12345678910>>...22

/PHP-8.1/ext/pdo_sqlite/tests/
H A Dpdo_fetch_func_001.phpt15 $st = $db->query('SELECT * FROM testing');
18 $st = $db->query('SELECT name FROM testing');
22 $st = $db->query('SELECT * FROM testing');
29 $st = $db->query('SELECT * FROM testing');
36 $st = $db->query('SELECT * FROM testing');
43 $st = $db->query('SELECT * FROM testing');
50 $st = $db->query('SELECT * FROM testing');
82 $st = $db->query('SELECT * FROM testing');
86 $st = $db->query('SELECT * FROM testing');
93 $st = $db->query('SELECT * FROM testing');
[all …]
/PHP-8.1/Zend/tests/variadic/
H A Dremoving_parameter_error.phpt7 public function query($query, ...$params);
11 public function query(...$params) { }
/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_affected_rows_oo.phpt28 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
34 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
41 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
51 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
57 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
70 if (!$mysqli->query("REPLACE INTO test(id, label) values (4, 'd')"))
76 if (!$mysqli->query("REPLACE INTO test(id, label) values (5, 'e')"))
82 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
88 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
95 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 $link->query("SET @@session.old_passwords=2");
61 $link->query('DROP USER shatest');
62 $link->query("DROP USER shatest@localhost");
70 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
75 if (!$link->query("DROP TABLE IF EXISTS test") ||
76 !$link->query("CREATE TABLE test (id INT)") ||
77 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
169 $link->query('DROP USER shatest');
[all …]
H A Dmysqli_expire_password.phpt20 $result = $link->query("select @@disconnect_on_expired_password");
50 if (!$link->query("DROP TABLE IF EXISTS test") ||
51 !$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)"))
73 $link->query("SELECT id FROM test WHERE id = 1");
84 $link->query("SELECT id FROM test WHERE id = 1");
95 $link->query("SELECT id FROM test WHERE id = 1");
107 if (!$link->query("SET PASSWORD='expiretest'")) {
108 $link->query("SET PASSWORD=PASSWORD('expiretest')");
111 if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
122 $link->query("SELECT id FROM test WHERE id = 1");
[all …]
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 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 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 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 …]
H A D067.phpt22 function open_cursor($mysql, $query) {
23 if (!is_object($stmt = $mysql->prepare($query))) {
25 $query, $mysql->errno, $mysql->error);
43 $mysql->query("DROP TABLE IF EXISTS cursor$i");
44 $mysql->query("CREATE TABLE cursor$i (a int not null) ENGINE=" . $engine);
45 $mysql->query("INSERT INTO cursor$i VALUES (1),(2),(3),(4),(5),(6)");
H A Dbug66124.phpt32 $link->query($table_drop);
33 $link->query($table_create);
52 $result = $link->query($table_select);
65 $link->query($table_drop);
66 $link->query($table_create);
81 $result = $link->query($table_select);
/PHP-8.1/ext/mbstring/tests/
H A Dmb_parse_str.phpt14 function test($query) {
17 mb_parse_str($query, $array);
22 foreach ($queries as $query) {
23 test($query);
H A Dmb_parse_str02.phpt14 function test($query) {
18 mb_parse_str($query, $array);
24 foreach ($queries as $query) {
25 test($query);
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug43925.phpt17 @$dbh->query('DROP TABLE nodes');
19 $dbh->query('
28 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);');
29 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);');
30 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
55 $dbh->query('DROP TABLE nodes');
/PHP-8.1/ext/pdo_firebird/tests/
H A Dexecute_block.phpt31 $query = $dbh->prepare($sql);
32 $query->execute(['d' => 1, 'e' => 2]);
33 $row = $query->fetch(\PDO::FETCH_OBJ);
37 unset($query);
/PHP-8.1/ext/sqlite3/
H A Dsqlite3.stub.php55 public function prepare(string $query): SQLite3Stmt|false {} argument
58 public function exec(string $query): bool {} argument
61 public function query(string $query): SQLite3Result|false {} function in SQLite3
64 public function querySingle(string $query, bool $entireRow = false): mixed {} argument
91 private function __construct(SQLite3 $sqlite3, string $query) {} argument
/PHP-8.1/ext/sqlite3/tests/
H A Dsqlite3_39_toggleExtended.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)");
22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)");
34 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
38 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
/PHP-8.1/Zend/tests/
H A Dbug31177.phpt7 public function query() {
12 return new DbGowRecordSet($this->query());
16 new DbGowRecordSet($this->query());
/PHP-8.1/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-8.1/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 …]
/PHP-8.1/ext/pdo/
H A Dpdo_dbh.stub.php38 public function prepare(string $query, array $options = []): PDOStatement|false {} argument
41 …public function query(string $query, ?int $fetchMode = null, mixed ...$fetchModeArgs): PDOStatemen… function in PDO
/PHP-8.1/ext/dom/tests/
H A Dxpath_domnamespacenode_advanced.phpt2 DOMXPath::query() can return DOMNodeList with DOMNameSpaceNode items - advanced variation
16 $query = '//namespace::*';
20 foreach ($xpath->query($query) as $attribute) {
27 foreach ($xpath->query($query) as $attribute) {

Completed in 33 milliseconds

12345678910>>...22