Home
last modified time | relevance | path

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

12345678910>>...17

/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_fetch_table_names.phpt16 $stmt = $db->query('SELECT label FROM test LIMIT 1');
21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
H A Dpdo_mysql_subclass.phpt33 public function query() {
35 return call_user_func_array(array($this, 'parent::query'), func_get_args());
63 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
88 query('SELECT * FROM test ORDER BY id ASC')
H A Dbug41125.phpt33 foreach ($queries as $k => $query) {
34 $stmt = $db->prepare($query);
36 printf("[%d] Query: [[%s]]\n", $k + 1, $query);
74 foreach ($queries as $k => $query) {
75 $stmt = $db->prepare($query);
79 printf("[%d] Query: [[%s]]\n", $k + 1, $query);
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 Dbug53782.phpt18 $res = $conn->query('SELECT 0');
21 $conn->query('ERROR');
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);
/PHP-5.5/ext/mysqli/tests/
H A Dbug51647.phpt16 if ($res = $link->query('SHOW VARIABLES LIKE "have_ssl"')) {
19 if ($link->errno == 1064 && ($res = $link->query("SHOW VARIABLES"))) {
52 if (!$res = $link->query('SHOW STATUS like "Ssl_cipher"')) {
55 if ($res = $link->query("SHOW STATUS")) {
H A Dbug52891.phpt19 if (!$link->query("DROP TABLE IF EXISTS tuint") ||
20 !$link->query("DROP TABLE IF EXISTS tsint")) {
24 if (!$link->query("CREATE TABLE tuint(a BIGINT UNSIGNED) ENGINE=" . $engine) ||
25 !$link->query("CREATE TABLE tsint(a BIGINT) ENGINE=" . $engine)) {
84 $result = $link->query("SELECT * FROM tsint ORDER BY a ASC");
85 $result2 = $link->query("SELECT * FROM tuint ORDER BY a ASC");
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_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 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 Dbug54221.phpt24 $query = "$create;$create;$create;";
25 if ($link->multi_query($query)) {
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");
/PHP-5.5/ext/interbase/
H A Dibase_query.c50 struct _ib_query *query; member
69 char *query; member
177 if (ib_query->query) { in _php_ibase_free_query()
178 efree(ib_query->query); in _php_ibase_free_query()
322 if (*query == '\0') { in _php_ibase_alloc_query()
335 ib_query->query = estrdup(query); in _php_ibase_alloc_query()
426 if (ib_query->query) { in _php_ibase_alloc_query()
427 efree(ib_query->query); in _php_ibase_alloc_query()
950 res->query = ib_query; in _php_ibase_exec()
1062 char *query; in PHP_FUNCTION() local
[all …]
/PHP-5.5/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 Dbug68760.phpt22 $naturalSort = $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP");
34 Warning: SQLite3::query(): An error occurred while invoking the compare callback in %a%ebug68760.ph…
/PHP-5.5/ext/pdo_sqlite/tests/
H A Dbug44327_2.phpt12 $x = $db->query('select 1 as queryString');
20 $x = $db->query('select 1 as queryString');
/PHP-5.5/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.5/ext/pdo_pgsql/tests/
H A Dbug67462.phpt20 $pdo->query("CREATE TABLE b67462 (a int NOT NULL PRIMARY KEY DEFERRABLE INITIALLY DEFERRED)");
21 $pdo->query("INSERT INTO b67462 VALUES (1), (1)");
H A Dbug69362.phpt51 $pdo->query($sql);
53 $result = $testConn->query($testQuery)->fetch();
58 $pdo->query($dropUser);

Completed in 30 milliseconds

12345678910>>...17