/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_transaction.phpt | 13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)'); 17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")'); 20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction'); 23 $db->query('DROP TABLE test_pdo_sqlite_transaction'); 29 Warning: PDO::query(): SQLSTATE[HY000]: General error: 6 database table is locked in %s on line %d
|
H A D | pdo_fetch_func_001.phpt | 14 $st = $db->query('SELECT * FROM test_fetch_func_001'); 22 $st = $db->query('SELECT name FROM test_fetch_func_001'); 26 $st = $db->query('SELECT * FROM test_fetch_func_001'); 33 $st = $db->query('SELECT * FROM test_fetch_func_001'); 40 $st = $db->query('SELECT * FROM test_fetch_func_001'); 47 $st = $db->query('SELECT * FROM test_fetch_func_001'); 54 $st = $db->query('SELECT * FROM test_fetch_func_001'); 86 $st = $db->query('SELECT * FROM test_fetch_func_001'); 90 $st = $db->query('SELECT * FROM test_fetch_func_001'); 97 $st = $db->query('SELECT * FROM test_fetch_func_001'); [all …]
|
H A D | pdo_sqlite_createcollation.phpt | 11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)'); 13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10… 17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL… 22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_pam_sha256_public_key_option.phpt | 21 if (!($res = $link->query("SHOW PLUGINS"))) { 35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) { 57 $link->query("SET @@session.old_passwords=2"); 59 $link->query('DROP USER shatest'); 60 $link->query("DROP USER shatest@localhost"); 68 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') || 73 if (!$link->query("DROP TABLE IF EXISTS test") || 74 !$link->query("CREATE TABLE test (id INT)") || 75 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)")) 123 $link->query('DROP USER shatest'); [all …]
|
H A D | gh11438.phpt | 22 if (!($res = $link->query("SHOW PLUGINS"))) { 37 $link->query("SET @@session.old_passwords=2"); 39 $link->query('DROP USER shatest'); 40 $link->query("DROP USER shatest@localhost"); 42 if (!$link->query('CREATE USER shatest@"%" IDENTIFIED WITH sha256_password') || 43 !$link->query('CREATE USER shatest@"localhost" IDENTIFIED WITH sha256_password')) { 48 if (!$link->query('SET PASSWORD FOR shatest@"%" = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV… 49 …!$link->query('SET PASSWORD FOR shatest@"localhost" = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQ… 63 if (!$res = $link->query("SELECT USER()")) 84 $link->query('DROP USER shatest'); [all …]
|
H A D | bug75018.phpt | 17 $mysqli->query($sql); 20 $mysqli->query($sql); 23 $mysqli->query($sql); 25 $mysqli->query($sql); 28 $result = $mysqli->query($sql);
|
H A D | mysqli_affected_rows_oo.phpt | 25 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 D | mysqli_real_connect_compression_error.phpt | 2 Bug #80107 mysqli_query() fails for ~16 MB long query when compression is enabled 12 $result = $link->query("SHOW VARIABLES LIKE 'max_allowed_packet'"); 28 $mysqli->query("DROP TABLE IF EXISTS test"); 29 $mysqli->query("CREATE TABLE test (`blob` LONGBLOB NOT NULL) ENGINE=MyISAM"); 32 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')"); 43 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')");
|
H A D | mysqli_expire_password.phpt | 20 $result = $link->query("select @@disconnect_on_expired_password"); 46 if (!$link->query("DROP TABLE IF EXISTS test") || 47 !$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)")) 69 $link->query("SELECT id FROM test WHERE id = 1"); 80 $link->query("SELECT id FROM test WHERE id = 1"); 91 $link->query("SELECT id FROM test WHERE id = 1"); 103 if (!$link->query("SET PASSWORD='expiretest'")) { 104 $link->query("SET PASSWORD=PASSWORD('expiretest')"); 107 if ($res = $link->query("SELECT id FROM test WHERE id = 1")) 118 $link->query("SELECT id FROM test WHERE id = 1"); [all …]
|
H A D | mysqli_pam_sha256_public_key_option_invalid.phpt | 21 if (!($res = $link->query("SHOW PLUGINS"))) { 35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) { 57 $link->query("SET @@session.old_passwords=2"); 59 $link->query('DROP USER shatest'); 60 $link->query("DROP USER shatest@localhost"); 68 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') || 73 if (!$link->query("DROP TABLE IF EXISTS test") || 74 !$link->query("CREATE TABLE test (id INT)") || 75 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)")) 168 $link->query('DROP USER shatest'); [all …]
|
/php-src/ext/pdo_dblib/tests/ |
H A D | bug_68957.phpt | 2 PDO_DBLIB bug #68957 PDO::query doesn't support several queries 16 $query = "declare @myInt int = 1; select @myInt;"; 17 $stmt = $db->query($query);
|
H A D | pdodblib_001.phpt | 16 $db->query("CREATE TABLE #pdo_dblib_001(name VARCHAR(32)); "); 17 $db->query("INSERT INTO #pdo_dblib_001 VALUES('PHP'), ('PHP6');"); 19 foreach ($db->query('SELECT name FROM #pdo_dblib_001') as $row) { 29 $db->query('DROP TABLE IF EXISTS #pdo_dblib_001');
|
/php-src/ext/pdo/tests/ |
H A D | pdo_023.phpt | 53 function query($sql, ...$rest): PDOStatement|false 66 $db->query('CREATE TABLE test023(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))'); 67 $db->query("INSERT INTO test023 VALUES(0, 'A')"); 68 $db->query("INSERT INTO test023 VALUES(1, 'B')"); 71 $stmt = $db->query('SELECT val, id FROM test023'); 95 PDODatabaseX::query() 98 PDODatabaseX::query() 101 PDODatabaseX::query() 104 PDODatabaseX::query()
|
H A D | bug_69356.phpt | 2 PDO Common: Bug #69356 (PDOStatement::debugDumpParams() truncates query) 9 if (!strncasecmp(getenv('PDOTEST_DSN'), 'oci', strlen('oci'))) die('skip query not supported'); 20 $query = <<<'SQL' 22 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ… 35 $query .= $from; 37 $stmt = $db->query($query); 42 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_multi_statements.phpt | 29 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table)); 33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 35 // A single query with a trailing delimiter. 36 $stmt = $db->query('SELECT 1 AS value;'); 43 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (3)', $table, $table)); 48 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 50 // A single query with a trailing delimiter. 51 $stmt = $db->query('SELECT 1 AS value;'); 60 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_multi_statements'); 84 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
|
H A D | unsigned_bigint.phpt | 18 $pdo->query("CREATE TABLE $tbl (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB"); 19 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (18446744073709551615)"); 20 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (9223372036854775808)"); 21 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (1)"); 22 $result = $pdo->query("SELECT ubigint FROM $tbl")->fetchAll(PDO::FETCH_ASSOC);
|
H A D | pdo_mysql_parser.phpt | 29 foreach ($queries as $k => $query) { 30 $stmt = $db->prepare($query); 32 var_dump($query, $stmt->fetch(PDO::FETCH_NUM) == [0 => 1]); 43 foreach ($queries as $k => $query) { 44 $stmt = $db->prepare($query); 46 var_dump($query, $stmt->fetch(PDO::FETCH_NUM) == [0 => 1]);
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3stmt_paramCount_basic.phpt | 27 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:
|
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-src/ext/standard/tests/url/ |
H A D | bug69976.phpt | 14 ["query"]=> 20 ["query"]=> 26 ["query"]=> 32 ["query"]=>
|
/php-src/Zend/tests/variadic/ |
H A D | removing_parameter_error.phpt | 7 public function query($query, ...$params); 11 public function query(...$params) { }
|
/php-src/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_str_error.phpt | 14 foreach ($queries as $query) { 15 echo "Query: " . bin2hex($query) . "\n"; 18 mb_parse_str($query, $array);
|
/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdosqlite_001.phpt | 10 $db->query('CREATE TABLE pdosqlite_001 (id INT AUTO INCREMENT, name TEXT)'); 12 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP")'); 13 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP6")'); 17 foreach ($db->query('SELECT testing(name) FROM pdosqlite_001') as $row) {
|
/php-src/ext/zend_test/tests/ |
H A D | observer_sqlite_create_function.phpt | 21 foreach ($db->query('SELECT returnOne()') as $row) { 36 <!-- init PDO::query() --> 37 <PDO::query> 41 </PDO::query>
|