/PHP-7.1/ext/mysqli/tests/ |
H A D | mysqli_pam_sha256_public_key_option.phpt | 23 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)")) 106 if (!$res = $link->query("SELECT id FROM test WHERE id = 1")) 126 $link->query('DROP USER shatest'); [all …]
|
H A D | mysqli_autocommit_oo.phpt | 31 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 D | bug75018.phpt | 16 $mysqli->query($sql); 19 $mysqli->query($sql); 22 $mysqli->query($sql); 24 $mysqli->query($sql); 27 $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_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 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 D | bug53503.phpt | 2 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 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 | bug35103.phpt | 18 $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 D | bug34785.phpt | 14 public function __construct($link, $query) { 15 parent::__construct($link, $query); 21 public function __construct($link, $query) { 22 parent::__construct($link, $query);
|
H A D | mysqli_expire_password.phpt | 42 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 …]
|
/PHP-7.1/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_lastinsertid.phpt | 9 $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 D | pdo_sqlite_createaggregate.phpt | 10 $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 D | pdo_sqlite_createfunction.phpt | 10 $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 D | pdo_sqlite_createfunction_with_flags.phpt | 13 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)'); 15 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")'); 22 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) { 26 $db->query('DROP TABLE foobar');
|
H A D | pdo_fetch_func_001.phpt | 15 $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.1/ext/pdo_dblib/tests/ |
H A D | timeout.phpt | 2 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 D | bug_68957.phpt | 2 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.1/ext/sqlite3/tests/ |
H A D | sqlite3stmt_reset_params.phpt | 18 $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 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:
|
/PHP-7.1/ext/standard/tests/url/ |
H A D | bug69976.phpt | 14 ["query"]=> 20 ["query"]=> 26 ["query"]=> 32 ["query"]=>
|
/PHP-7.1/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_multi_statements.phpt | 26 $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.1/ext/mbstring/tests/ |
H A D | mb_parse_str.phpt | 16 function test($query) { 19 mb_parse_str($query, $array); 23 mb_parse_str($query); 27 foreach ($queries as $query) { 28 test($query);
|
H A D | mb_parse_str02.phpt | 16 function test($query) { 20 mb_parse_str($query, $array); 25 mb_parse_str($query); 30 foreach ($queries as $query) { 31 test($query);
|
/PHP-7.1/ext/oci8/tests/ |
H A D | bug38161.phpt | 10 $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.1/ext/pdo_pgsql/tests/ |
H A D | bug43925.phpt | 15 @$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');
|