/PHP-8.1/ext/pdo_sqlite/tests/ |
H A D | pdo_fetch_func_001.phpt | 15 $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 D | removing_parameter_error.phpt | 7 public function query($query, ...$params); 11 public function query(...$params) { }
|
/PHP-8.1/ext/mysqli/tests/ |
H A D | mysqli_affected_rows_oo.phpt | 28 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 D | mysqli_pam_sha256_public_key_option_invalid.phpt | 23 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 D | mysqli_expire_password.phpt | 20 $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 D | bug53503.phpt | 2 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 D | bug52082.phpt | 17 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 D | bug34785.phpt | 15 public function __construct($link, $query) { 16 parent::__construct($link, $query); 22 public function __construct($link, $query) { 23 parent::__construct($link, $query);
|
H A D | bug76386.phpt | 24 $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 D | bug35103.phpt | 19 $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 D | gh11550.phpt | 2 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 D | mysqli_last_insert_id.phpt | 20 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 D | 067.phpt | 22 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 D | bug66124.phpt | 32 $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 D | mb_parse_str.phpt | 14 function test($query) { 17 mb_parse_str($query, $array); 22 foreach ($queries as $query) { 23 test($query);
|
H A D | mb_parse_str02.phpt | 14 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 D | bug43925.phpt | 17 @$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 D | execute_block.phpt | 31 $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 D | sqlite3.stub.php | 55 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 D | sqlite3_39_toggleExtended.phpt | 10 $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 D | bug31177.phpt | 7 public function query() { 12 return new DbGowRecordSet($this->query()); 16 new DbGowRecordSet($this->query());
|
/PHP-8.1/ext/pdo/tests/ |
H A D | pdo_038.phpt | 23 $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 D | pear2coverage.phar | 1069 $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 D | pdo_dbh.stub.php | 38 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 D | xpath_domnamespacenode_advanced.phpt | 2 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) {
|