Home
last modified time | relevance | path

Searched refs:query (Results 151 – 175 of 401) sorted by relevance

12345678910>>...17

/PHP-5.5/ext/pdo/tests/
H A Dbug_44861.phpt37 $query = "SELECT 'row1' AS r $from UNION SELECT 'row2' $from UNION SELECT 'row3' $from UNION SELECT…
40 $res = $db->prepare($query, $aParams);
56 // Test binding params via emulated prepared query
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_fetch_assoc_oo.phpt30 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
42 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
43 printf("[007] Cannot run query, [%d] %s\n", $mysqli->errno, $mysqli->error);
H A Dbug48909.phpt16 if (!$link->query("DROP TABLE IF EXISTS test") ||
17 !$link->query(sprintf("CREATE TABLE test(id INT, label varchar(255)) ENGINE = %s", $engine)))
H A Dmysqli_change_user_oo.phpt51 if (!$mysqli->query('SET @mysqli_change_user_test_var=1'))
54 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
64 if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user'))
74 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
H A Dmysqli_fetch_array_oo.phpt21 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 5")) {
42 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
43 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error);
49 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) {
50 printf("[012] Cannot run query, [%d] %s\n",
73 if (!$mysqli->query("DROP TABLE IF EXISTS test")) {
78 …if (!$mysqli->query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) …
84 if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) {
90 if (!$mysqli->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) {
95 … if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) {
[all …]
H A Dbug32405.phpt18 …$link->query("CREATE TABLE test_users(user_id int(10) unsigned NOT NULL auto_increment, login varc…
19 …$link->query('INSERT INTO test_users VALUES (NULL, "user1"), (NULL, "user2"), (NULL, "user3"), (NU…
H A Dmysqli_error_oo.phpt28 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
32 $mysqli->query('SELECT * FROM test');
H A Dmysqli_num_fields.phpt24 function func_test_mysqli_num_fields($link, $query, $expected, $offset, $test_free = false) {
26 if (!($res = mysqli_query($link, $query))) {
H A Dmysqli_stmt_multires.phpt18 if (!$link->query('DROP PROCEDURE IF EXISTS p123')) {
22 …if (!$link->query("CREATE PROCEDURE p123() BEGIN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM te…
98 if (!$link->query('DROP PROCEDURE IF EXISTS p123')) {
H A Dmysqli_get_warnings.phpt90 if (!$mysqli->query("DROP TABLE IF EXISTS t1"))
93 if (!$mysqli->query("CREATE TABLE t1 (a smallint)"))
102 if (!$mysqli->query("DROP TABLE t1"))
119 if (!$mysqli->query("DROP TABLE IF EXISTS t1"))
122 if (!$mysqli->query("CREATE TABLE t1 (a smallint)"))
126 if (!$mysqli->query("INSERT IGNORE INTO t1(a) VALUES (65536), (65536), (65536)"))
H A Dmysqli_send_query.phpt34 $query = array();
35 if (NULL !== ($tmp = @mysqli_send_query($link, $query)))
H A Dbug36949.phpt18 $result = $this->mysqli->query("SELECT NOW() AS my_time FROM DUAL");
36 $result = $this->mysqli->query("SELECT NOW() AS my_time FROM DUAL");
/PHP-5.5/ext/sqlite3/tests/
H A Dsqlite3stmt_paramCount_error.phpt18 $query = "SELECT * FROM foobar WHERE id = ? ORDER BY id ASC";
22 $stmt = $db->prepare($query);
H A Dsqlite3_12_unfinalized_stmt_cleanup.phpt2 SQLite3::query Unfinalized statement tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
/PHP-5.5/ext/pdo_mysql/tests/
H A Dbug_44707.phpt12 $stmt = $db->query('SELECT VERSION() as _version');
48 $stmt = $db->query('SELECT * FROM test');
57 $stmt = $db->query('SELECT * FROM test');
H A Dpdo_mysql_stmt_fetch_non_select.phpt22 if (!is_object($stmt = $db->query('DESCRIBE test id')))
39 if (!is_object($stmt = $db->query('SHOW ENGINES')))
57 if (!is_object($stmt = $db->query("EXPLAIN SELECT id FROM test")))
78 if (!is_object($stmt = $db->query('DESCRIBE test id')))
112 if (!is_object($stmt = $db->query('SHOW ENGINES')))
145 if (!is_object($stmt = $db->query("EXPLAIN SELECT id FROM test")))
H A Dbug54929.phpt18 function testQuery($query) {
20 $stmt = $pdodb->prepare($query);
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dcopy_from.phpt45 $stmt = $db->query("select * from test");
54 $stmt = $db->query("select * from test");
63 $stmt = $db->query("select * from test");
79 $stmt = $db->query("select * from test");
88 $stmt = $db->query("select * from test");
97 $stmt = $db->query("select * from test");
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug46274.phpt25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)');
49 $res = $db->query("SELECT blob1 from test_one_blob");
/PHP-5.5/sapi/tests/
H A Dtest001.phpt4 This would be similar to what IIS produces for a simple query.
/PHP-5.5/ext/pdo/
H A DTODO8 - Add PDO::queryParams(), similar to PDO::query(), but accepts
63 mysqli_info(); info about rows affected by last query
64 mysqli_master_query(); force query to run on master
/PHP-5.5/ext/mysql/tests/
H A Dmysql_num_fields.phpt23 function func_test_mysql_num_fields($link, $query, $expected, $offset, $test_free = false) {
25 if (!($res = mysql_query($query, $link))) {
/PHP-5.5/ext/oci8/tests/
H A Dbug38173.phpt40 $query ="
48 $sth = oci_parse($c, $query);
H A Dbug51291_2.phpt13 echo "\nTest 1 - Execute - after successful 2nd query with same statement\n";
37 Test 1 - Execute - after successful 2nd query with same statement
H A Dpecl_bug8816.phpt45 $query ="
55 $sth = oci_parse($c, $query);

Completed in 33 milliseconds

12345678910>>...17