/PHP-5.4/ext/pdo/tests/ |
H A D | bug_34687.phpt | 2 PDO Common: Bug #34687 (query doesn't return error information) 18 $x = $db->query("UPDATE non_existent_pdo_test_table set foo = 'bar'");
|
H A D | pdo_012.phpt | 23 $stmt = $db->query($SELECT, PDO::FETCH_NUM); 36 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test'); 41 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
|
H A D | pdo_033.phpt | 25 $db->query("CREATE TABLE test (t char($len))"); 26 $db->query("INSERT INTO test (t) VALUES($quoted)");
|
H A D | pdo_026.phpt | 45 function query($sql) 68 $stmt = $db->query('SELECT * FROM test'); 81 PDODatabase::query()
|
/PHP-5.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_rowcount.phpt | 17 if (0 !== ($tmp = $db->query('SELECT id FROM test WHERE 1 = 0')->rowCount())) 20 if (1 !== ($tmp = $db->query('SELECT id FROM test WHERE id = 1')->rowCount()))
|
H A D | bug46292.phpt | 39 $pdoDb->query('DROP TABLE IF EXISTS testz'); 41 $pdoDb->query('CREATE TABLE testz (name VARCHAR(20) NOT NULL, value INT)'); 43 …$pdoDb->query("INSERT INTO testz VALUES ('myclass', 1), ('myclass2', 2), ('myclass', NULL), ('mycl…
|
H A D | pdo_mysql_stmt_fetchobject.phpt | 11 $query = "SELECT '', NULL, \"\" FROM DUAL"; 12 $stmt = $db->prepare($query); 28 $query = "SELECT id, '', NULL, \"\" FROM test ORDER BY id ASC LIMIT 3"; 29 $stmt = $db->prepare($query);
|
H A D | bug53782.phpt | 18 $res = $conn->query('SELECT 0'); 21 $conn->query('ERROR');
|
H A D | bug_42499.phpt | 12 $stmt = $db->query('SELECT VERSION() as _version'); 32 $stmt = $db->query('SELECT id AS _id FROM test'); 69 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti… 79 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
|
/PHP-5.4/ext/sqlite3/tests/ |
H A D | bug63921-32bit.phpt | 12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))'); 19 $stmt = $conn->query('SELECT num FROM users');
|
H A D | bug63921-64bit.phpt | 12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))'); 19 $stmt = $conn->query('SELECT num FROM users');
|
H A D | sqlite3_13_skip_all_cleanup.phpt | 2 SQLite3::query Skip all cleanup 19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
|
H A D | sqlite3_18_changes.phpt | 18 echo "UPDATE query\n"; 34 UPDATE query
|
H A D | sqlite3_36_create_collation.phpt | 20 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort 21 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
|
/PHP-5.4/ext/mysqli/tests/ |
H A D | mysqli_connect_oo_defaults.phpt | 34 if (!$res = $mysqli->query("SELECT 'mysqli.default_socket' AS testing")) 57 if (!$res = $mysqli->query("SELECT 'mysqli.default_port' AS testing")) 75 if (!$res = $mysqli->query("SELECT 'mysqli.default_pw' AS testing")) 93 if (!$res = $mysqli->query("SELECT 'mysqli.default_user' AS testing")) 111 if (!$res = $mysqli->query("SELECT 1")) 115 if (!$res = $mysqli->query("SELECT SUBSTRING_INDEX(USER(),'@',1) AS username"))
|
H A D | bug42548.phpt | 26 $mysqli->query("DROP PROCEDURE IF EXISTS p1") or die($mysqli->error); 27 $mysqli->query("CREATE PROCEDURE p1() BEGIN SELECT 23; SELECT 42; END") or die($mysqli->error); 49 $mysqli->query("DROP PROCEDURE p1") or die($mysqli->error);
|
H A D | mysqli_set_local_infile_handler_new_query.phpt | 2 mysqli_set_local_infile_handler() - run new query on db link 41 printf("[Callback 001 - %03d] Cannot run query, [%d] %s\n", 69 [Callback 001 - 001] Cannot run query, [2014] Commands out of sync; you can't run this command now
|
H A D | mysqli_fetch_all_oo.phpt | 26 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) { 34 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) { 42 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) { 50 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) { 61 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) { 72 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error); 78 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) { 79 printf("[018] Cannot run query, [%d] %s\n", 97 if (!$link->query("DROP TABLE IF EXISTS test")) { 108 if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { [all …]
|
H A D | mysqli_insert_id_variation.phpt | 16 $link->query("DROP TABLE IF EXISTS test_insert_id_var"); 17 $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))"); 18 $link->query("INSERT INTO test_insert_id_var VALUES (null)"); 87 $link->query("DROP TABLE IF EXISTS test_insert_id_var");
|
H A D | bug54221.phpt | 24 $query = "$create;$create;$create;"; 25 if ($link->multi_query($query)) {
|
H A D | bug_mysql_49406.phpt | 16 …$query = "SELECT CASE WHEN 0 THEN CAST('2009-12-03' AS DATE) ELSE CAST('2009-12-03' AS DATE) END… 18 if (!$res = $link->query($query)) 30 if (!$stmt = $link->prepare($query))
|
H A D | mysqli_auth_pam.phpt | 21 if (!$res = $link->query("SHOW PLUGINS")) 47 if (!$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)")) 71 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
|
H A D | mysqli_stmt_bind_param_many_columns.phpt | 32 list($old_max_allowed_packet) = $link->query("SELECT @@max_allowed_packet")->fetch_row(); 33 if (!$link->query("SET GLOBAL max_allowed_packet=(2<<29)")) { 60 $link->query("CREATE TABLE test(" . implode(" , ", $str) . ") ENGINE=MyISAM"); 86 if (!$link->query("SET GLOBAL max_allowed_packet=$old_max_allowed_packet")) {
|
/PHP-5.4/ext/dom/tests/ |
H A D | bug36756.phpt | 12 $node = $xpath->query('/root')->item(0); 20 $node = $xpath->query('//child')->item(0);
|
/PHP-5.4/ext/oci8/tests/ |
H A D | bug40415.phpt | 45 $query = "SELECT t1.*, CURSOR( SELECT * FROM t2 ) AS CURSOR FROM t1"; 47 $stmt = oci_parse($c, $query); 61 $query = "SELECT t1.*, CURSOR( SELECT * FROM t2 ) AS CURSOR FROM t1"; 63 $stmt = oci_parse($c, $query);
|