Home
last modified time | relevance | path

Searched refs:db (Results 201 – 225 of 777) sorted by relevance

12345678910>>...32

/PHP-7.4/ext/pdo_pgsql/tests/
H A Ddisable_prepares.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_COLUMN);
17 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
20 $stmt2 = $db->prepare("SELECT (?)::int2");
29 $stmt3 = $db->prepare("SELECT (?)::int4", array(
H A Dbug70861.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
18 @$db->query("SET bytea_output = 'escape'");
22 $db->query('DROP TABLE IF EXISTS test_blob_crash CASCADE');
23 $db->query('CREATE TABLE test_blob_crash (id SERIAL NOT NULL, blob1 BYTEA)');
35 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => P…
/PHP-7.4/ext/pdo_oci/tests/
H A Dcheckliveness.phpt13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
21 $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
30 $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
37 $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
40 $stmt = $db->prepare('SELECT * FROM dual');
48 $db = null;
/PHP-7.4/ext/pdo_mysql/tests/
H A Dbug_41997.phpt11 $db = MySQLPDOTest::factory();
12 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
25 $db = MySQLPDOTest::factory();
27 $db->exec('DROP PROCEDURE IF EXISTS p');
28 $db->exec('CREATE PROCEDURE p() BEGIN SELECT 1 AS "one"; END');
30 $stmt = $db->query("CALL p()");
36 $stmt = $db->query('SELECT 2 AS "two"');
H A Dpdo_mysql_stmt_bindcolumn.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
14 MySQLPDOTest::createTestTable($db);
17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
18 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
21 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
57 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
58 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
99 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
107 $db = MySQLPDOTest::factory();
[all …]
H A Dbug_41125.phpt9 $db = MySQLPDOTest::factory();
10 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
24 $db = MySQLPDOTest::factory();
25 $db->exec("DROP TABLE IF EXISTS test");
28 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
34 $stmt = $db->query($sql);
44 $db = MySQLPDOTest::factory();
45 $db->exec("DROP TABLE IF EXISTS test");
H A Dbug_41698.phpt14 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
18 $db->exec('CREATE TABLE test(floatval DECIMAL(8,6))');
19 $db->exec('INSERT INTO test VALUES(2.34)');
21 $stmt = $db->prepare('INSERT INTO test VALUES(?)');
23 var_dump($db->query('SELECT * from test')->fetchAll(PDO::FETCH_ASSOC));
H A Dlast_insert_id.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
15 print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)"));
17 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
19 print_r($db->query("INSERT INTO test (num) VALUES (451)"));
21 print_r($db->lastInsertId());
/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3_04_update.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
27 var_dump($db->exec("UPDATE test SET id = 'c' WHERE id = 'a'"));
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
38 var_dump($db->close());
H A Dsqlite3_05_delete.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
27 var_dump($db->exec("DELETE FROM test WHERE id = 'a'"));
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
38 var_dump($db->close());
H A Dbug72668.phpt12 $db = new SQLite3(':memory:');
13 $db->createFunction('my_udf_md5', 'my_udf_md5');
16 $result = $db->query('SELECT my_udf_md5("test")');
23 $result = $db->querySingle('SELECT my_udf_md5("test")');
29 $statement = $db->prepare('SELECT my_udf_md5("test")');
H A Dsqlite3_33_createAggregate_notcallable.phpt14 $db = new SQLite3(':memory:');
16 $db->createAggregate ('TESTAGGREGATE', 'aggregate_test_step', 'aggregate_final');
17 $db->createAggregate ('TESTAGGREGATE2', 'aggregate_step', 'aggregate_test_final');
18 var_dump($db->createAggregate ('TESTAGGREGATE3', 'aggregate_step', 'aggregate_final'));
20 $db->close();
H A Dsqlite3_08_udf.phpt17 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
24 var_dump($db->createFunction('my_udf_md5', 'my_udf_md5'));
27 $results = $db->query("SELECT my_udf_md5(id) FROM test ORDER BY id ASC");
35 var_dump($db->close());
H A Dsqlite3_bind_bug68849.phpt8 $db = new SQLite3(':memory:');
10 $db->exec("CREATE TABLE test (a INTEGER, b TEXT, c REAL);" .
16 $s = $db->prepare('SELECT * FROM test WHERE (a+2) = ?;');
21 $s = $db->prepare('SELECT * FROM test WHERE a = ?;');
26 $s = $db->prepare('SELECT * FROM test WHERE a = ?;');
31 $s = $db->prepare('SELECT * FROM test WHERE c = ?;');
/PHP-7.4/ext/pdo/tests/
H A Dpdo_027.phpt15 $db = PDOTest::factory();
17 $db->exec('create table test (id int, name varchar(10))');
18 $db->exec("INSERT INTO test (id,name) VALUES(1,'test1')");
19 $db->exec("INSERT INTO test (id,name) VALUES(2,'test2')");
21 foreach ($db->query("SELECT * FROM test", PDO::FETCH_LAZY) as $v) {
H A Dpdo_035.phpt9 $db = new PDO('sqlite::memory:');
10 $db->exec('CREATE TABLE test (id int)');
11 $db->exec('INSERT INTO test VALUES (23)');
13 $stmt = $db->prepare('SELECT id FROM test');
H A Dpdo_007.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
18 $db->exec("INSERT INTO test VALUES('A', 'A')");
19 $db->exec("INSERT INTO test VALUES('B', 'A')");
20 $db->exec("INSERT INTO test VALUES('C', 'C')");
22 $stmt = $db->prepare('SELECT id, val from test');
H A Dpdo_030.phpt59 $db = PDOTest::factory('PDODatabase');
60 var_dump(get_class($db));
62 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
74 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
75 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('PDOStatementx', array($db)));
76 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
77 $stmt = $db->query('SELECT * FROM test');
H A Dpdo_023.phpt59 $db = PDOTest::factory('PDODatabaseX');
60 $db->test();
61 var_dump($db);
63 $db->query('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
64 $db->query('INSERT INTO test VALUES(0, \'A\')');
65 $db->query('INSERT INTO test VALUES(1, \'B\')');
68 $stmt = $db->query('SELECT val, id FROM test');
73 $db = NULL;
H A Dpdo_test.inc35 $db = new $classname($dsn, $user, $pass, $attr);
37 if (!$db) {
50 $db->exec("DROP TABLE $table");
54 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
55 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
56 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
57 return $db;
62 $db = PDOTest::factory();
H A Dbug_35671.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32))');
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
20 $insert = $db->prepare("insert into test (field1, field2, field3) values (:value1, :value2, :value3…
31 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
H A Dbug_73234.phpt16 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
18 $db->exec('CREATE TABLE test(id INT NULL)');
20 $stmt = $db->prepare('INSERT INTO test VALUES(:value)');
28 $stmt = $db->query('SELECT * FROM test');
H A Dpdo_020.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')");
20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')");
24 $stmt = $db->query($sql);
/PHP-7.4/ext/pgsql/tests/
H A D15pg_delete.phpt11 $db = pg_connect($conn_str);
15 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
16 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
17 if (!pg_delete($db, $table_name, $ids)) {
/PHP-7.4/ext/mysqli/tests/
H A D049.phpt14 $mysql = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
16 $mysql->select_db($db);
22 if ($row[0] != $db)
23 printf("[001] Expecting '%s' got '%s'\n", $db, $row[0]);

Completed in 44 milliseconds

12345678910>>...32