Home
last modified time | relevance | path

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

12345678910>>...24

/php-src/ext/mysqli/tests/
H A D074.phpt17 $result = $mysqli->query("SELECT @@autocommit");
21 $result = $mysqli->query("SELECT @@autocommit");
H A Dbug70949.phpt14 $mysql->query("DROP TABLE IF EXISTS bug70949");
15 $mysql->query("CREATE TABLE bug70949(name varchar(255))");
16 $mysql->query("INSERT INTO bug70949 VALUES ('dummy'),(NULL),('foo'),('bar')");
H A Dmysqli_commit_oo.phpt35 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
39 if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
43 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) {
52 if (!$mysqli->query('ROLLBACK'))
55 if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test')) {
65 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
H A Dmysqli_errno_oo.phpt26 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
30 $mysqli->query('SELECT * FROM test');
33 @$mysqli->query('No SQL');
H A Dmysqli_reap_async_query.phpt43 … printf("[%03d + 4] Cannot fetch and no error set - non resultset query (no SELECT)!\n", $offset);
57 // Connections on which no query has been sent - 1
59 $link->query("SELECT 1 AS _one", MYSQLI_ASYNC | MYSQLI_STORE_RESULT);
67 $link->query("SELECT 2 AS _two", MYSQLI_ASYNC | MYSQLI_USE_RESULT);
H A Dmysqli_local_infile_directory_access_denied.phpt31 if (!$link->query("DROP TABLE IF EXISTS test")) {
35 if (!$link->query("CREATE TABLE test (id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)) {
40 if (!$link->query("LOAD DATA LOCAL INFILE '".$filepath."' INTO TABLE test")) {
58 if (!$link->query('DROP TABLE IF EXISTS test')) {
H A Dbug74021.phpt15 $link->query('SET @@global.max_allowed_packet = 67108864');
19 $res = $link->query("SELECT RPAD('1',9000000,'1') as a,RPAD('1',9000000,'1') as b");
H A Dbug73800.phpt16 $link->query('SET @@global.max_allowed_packet = 67108864');
22 $res = $link->query("SELECT RPAD('1',9000000,'1') as a,RPAD('1',9000000,'1') as b, 9223372036854775…
H A Dbug35517.phpt15 $mysql->query("CREATE TABLE temp (id INT UNSIGNED NOT NULL)");
16 … $mysql->query("INSERT INTO temp (id) VALUES (3000000897),(3800001532),(3900002281),(3100059612)");
34 $mysql->query("DROP TABLE temp");
H A Dbug35759.phpt16 $mysql->query("DROP TABLE IF EXISTS test");
24 if (!$mysql->query($create)) {
33 if (!$mysql->query("INSERT INTO test (a0) VALUES ('')"))
H A Dmysqli_fetch_assoc_oo.phpt15 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
27 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
28 printf("[007] Cannot run query, [%d] %s\n", $mysqli->errno, $mysqli->error);
/php-src/ext/pdo_mysql/tests/
H A Dbug71145.phpt2 Bug #71145: Multiple statements in init command triggers unbuffered query error
21 var_dump($pdo->query('SELECT 42')->fetchColumn(0));
H A Dbug_38546.phpt20 $query = "CREATE TABLE test_38546(
26 $db->exec($query);
49 foreach ($db->query('SELECT * FROM test_38546') as $row) {
75 foreach ($db->query('SELECT * FROM test_38546') as $row) {
101 foreach ($db->query('SELECT * FROM test_38546') as $row) {
128 foreach ($db->query('SELECT * FROM test_38546') as $row) {
155 foreach ($db->query('SELECT * FROM test_38546') as $row) {
182 foreach ($db->query('SELECT * FROM test_38546') as $row) {
H A Dbug66528.phpt21 $stmt = $dbh->query('SELECT * FROM test_66528');
49 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
50 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
51 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
H A Dbug53782.phpt17 $res = $conn->query('SELECT 0');
20 $conn->query('ERROR');
H A Dbug70066.phpt18 $db = $pdo->query('SELECT DATABASE()')->fetchColumn(0);
21 $pdo->query('USE ' . $db);
H A Dbug63185.phpt26 $st = $pdo->query("CALL {$procedure}()");
36 $st = $pdo->query("CALL {$procedure}()");
49 $pdo->query('DROP PROCEDURE IF EXISTS test_procedure_error_at_second_63185');
/php-src/ext/pdo_dblib/tests/
H A Dbug_54648.phpt14 $db->query('set dateformat ymd');
15 $rs = $db->query("select cast('1950-01-18 23:00:00' as smalldatetime) as sdt, cast('2030-01-01 23:5…
/php-src/ext/pdo_firebird/tests/
H A Derror_handle.phpt18 $dbh->query("CREATE TABLE {$table} (val int)");
21 $dbh->query("INSERT INTO {$table} VALUES ('str')");
40 Warning: PDO::query(): SQLSTATE[22018]: Invalid character value for cast specification: -413 conver…
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdo_sqlite_createaggregate_trampoline.phpt10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate_trampoline (a INTEGER, b INTEGER)');
12 $stmt = $db->query('INSERT INTO test_pdo_sqlite_createaggregate_trampoline VALUES (1, -1), (2, -2),…
32 foreach ($db->query('SELECT S(a), S(b) FROM test_pdo_sqlite_createaggregate_trampoline') as $row) {
/php-src/ext/pdo_pgsql/tests/
H A Dbug70861.phpt20 @$db->query("SET bytea_output = 'escape'");
24 $db->query('CREATE TABLE test70861 (id SERIAL NOT NULL, blob1 BYTEA)');
49 $db->query('DROP TABLE IF EXISTS test70861 CASCADE');
H A Dbug46274_2.phpt20 @$db->query("SET bytea_output = 'escape'");
24 $db->query('CREATE TABLE test_one_blob_46274_2 (id SERIAL NOT NULL, blob1 BYTEA)');
52 $res = $db->query("SELECT blob1 from test_one_blob_46274_2");
72 $db->query('DROP TABLE IF EXISTS test_one_blob_46274_2');
/php-src/ext/mysqlnd/
H A Dmysqlnd_connection.c1022 char * query; local
1770 char * query; local
1781 if (!query) {
1786 enum_func_status ret = conn->m->query(conn, query, query_len);
1820 char * query; local
1827 if (!query) {
1832 enum_func_status ret = conn->m->query(conn, query, query_len);
1855 char *query; local
1857 if (!query) {
1880 char *query; local
[all …]
/php-src/ext/dom/tests/
H A Dgh11347.phpt2 GH-11347 (Memory leak when calling a static method inside an xpath query)
20 $xpath->query("//a[php:function('MyClass::dump', string(@href))]");
/php-src/ext/pdo_sqlite/tests/
H A Dbug35336.phpt14 $a->query ("CREATE TABLE test_35336 (a integer primary key, b text)");
17 $rez = $a->query ("SELECT * FROM test_35336")->fetchAll(PDO::FETCH_CLASS, 'EEE');

Completed in 145 milliseconds

12345678910>>...24