Home
last modified time | relevance | path

Searched refs:query (Results 101 – 125 of 389) sorted by relevance

12345678910>>...16

/PHP-5.4/ext/pdo/tests/
H A Dbug_34687.phpt2 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 Dpdo_012.phpt23 $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 Dpdo_033.phpt25 $db->query("CREATE TABLE test (t char($len))");
26 $db->query("INSERT INTO test (t) VALUES($quoted)");
H A Dpdo_026.phpt45 function query($sql)
68 $stmt = $db->query('SELECT * FROM test');
81 PDODatabase::query()
/PHP-5.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_rowcount.phpt17 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 Dbug46292.phpt39 $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 Dpdo_mysql_stmt_fetchobject.phpt11 $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 Dbug53782.phpt18 $res = $conn->query('SELECT 0');
21 $conn->query('ERROR');
H A Dbug_42499.phpt12 $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 Dbug63921-32bit.phpt12 $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 Dbug63921-64bit.phpt12 $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 Dsqlite3_13_skip_all_cleanup.phpt2 SQLite3::query Skip all cleanup
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
H A Dsqlite3_18_changes.phpt18 echo "UPDATE query\n";
34 UPDATE query
H A Dsqlite3_36_create_collation.phpt20 $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 Dmysqli_connect_oo_defaults.phpt34 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 Dbug42548.phpt26 $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 Dmysqli_set_local_infile_handler_new_query.phpt2 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 Dmysqli_fetch_all_oo.phpt26 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 Dmysqli_insert_id_variation.phpt16 $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 Dbug54221.phpt24 $query = "$create;$create;$create;";
25 if ($link->multi_query($query)) {
H A Dbug_mysql_49406.phpt16 …$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 Dmysqli_auth_pam.phpt21 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 Dmysqli_stmt_bind_param_many_columns.phpt32 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 Dbug36756.phpt12 $node = $xpath->query('/root')->item(0);
20 $node = $xpath->query('//child')->item(0);
/PHP-5.4/ext/oci8/tests/
H A Dbug40415.phpt45 $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);

Completed in 42 milliseconds

12345678910>>...16