Home
last modified time | relevance | path

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

12345678910>>...24

/php-src/ext/mysqli/tests/
H A D066.phpt19 $mysql->query("DROP TABLE IF EXISTS test_warnings");
21 $mysql->query("CREATE TABLE test_warnings (a int not null) ENGINE=myisam");
23 $mysql->query("INSERT INTO test_warnings VALUES (1),(2),(NULL)");
H A Dmysqli_local_infile_directory_access_allowed.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")) {
45 if (!$link->query("LOAD DATA LOCAL INFILE '".$filepath."' INTO TABLE test")) {
74 if (!$link->query('DROP TABLE IF EXISTS test')) {
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.phpt23 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
27 $mysqli->query('SELECT * FROM test');
30 @$mysqli->query('No SQL');
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 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 Dmysqli_reap_async_query.phpt39 … printf("[%03d + 4] Cannot fetch and no error set - non resultset query (no SELECT)!\n", $offset);
53 // Connections on which no query has been sent - 1
55 $link->query("SELECT 1 AS _one", MYSQLI_ASYNC | MYSQLI_STORE_RESULT);
63 $link->query("SELECT 2 AS _two", MYSQLI_ASYNC | MYSQLI_USE_RESULT);
/php-src/ext/standard/tests/url/
H A Dbug68917.phpt14 [query] => a=b
21 [query] => a=b
/php-src/ext/dom/tests/modern/xml/
H A Dxpath_query_context_in_scope_ns.phpt2 Test Dom\XPath::query() with registering a context node's in-scope namespaces
8 function dump($xpath, $query, $context) {
9 echo "--- $query ---\n";
10 $nodes = $xpath->query($query, $context);
/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 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 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…
/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_pgsql/tests/
H A Dpdo_pgsql_parser.phpt18 $query = <<<'EOF'
30 $stmt = $db->prepare($query);
38 $query = <<<'EOF'
42 $stmt = $db->prepare($query);
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/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/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 27 milliseconds

12345678910>>...24