Home
last modified time | relevance | path

Searched refs:db (Results 101 – 125 of 777) sorted by relevance

12345678910>>...32

/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3_31_open.phpt12 $db = new SQLite3(__DIR__ . '/db1.db');
13 $db->open(__DIR__ . '/db1.db');
20 <?php @unlink(__DIR__ . '/db1.db'); ?>
H A Dsqlite3_enable_exceptions.phpt11 $db = new SQLite3(':memory:');
12 var_dump($db->enableExceptions(true));
14 $db->query("SELECT * FROM non_existent_table");
18 var_dump($db->enableExceptions(false));
19 $db->query("SELECT * FROM non_existent_table");
20 var_dump($db->enableExceptions("wrong_type","wrong_type"));
22 var_dump($db->close());
H A Dsqlite3_busyTimeout.phpt10 var_dump($db->busyTimeout(0));
11 var_dump($db->busyTimeout(null));
12 var_dump($db->busyTimeout(-1000));
13 var_dump($db->busyTimeout(1000));
14 $db->close();
H A Dsqlite3_37_createfunction_flags.phpt14 var_dump($db->createfunction($func, $func, 1, SQLITE3_DETERMINISTIC));
15 var_dump($db->querySingle('SELECT strtoupper("test")'));
18 var_dump($db->createfunction($func2, $func2, 1, SQLITE3_DETERMINISTIC));
19 var_dump($db->querySingle('SELECT strtolower("TEST")'));
21 var_dump($db->createfunction($func, $func2, 1, SQLITE3_DETERMINISTIC));
22 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
H A Dsqlite3_defensive.phpt16 $db = new SQLite3(':memory:');
17 var_dump($db->exec('CREATE TABLE test (a, b);'));
20 var_dump($db->exec('PRAGMA writable_schema = ON;'));
21 var_dump($db->querySingle('PRAGMA writable_schema;'));
24 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
27 var_dump($db->querySingle('DELETE FROM sqlite_master;'));
30 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
H A Dsqlite3_33_reset.phpt11 $db = new SQLite3(':memory:');
13 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
14 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");
16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
21 //var_dump($db);
22 //var_dump($db->close());
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_closecursor.phpt8 $db = MySQLPDOTest::factory();
14 $db = MySQLPDOTest::factory();
117 MySQLPDOTest::createTestTable($db);
118 pdo_mysql_stmt_closecursor($db);
122 MySQLPDOTest::createTestTable($db);
123 pdo_mysql_stmt_closecursor($db);
131 MySQLPDOTest::createTestTable($db);
133 pdo_mysql_stmt_closecursor($db);
138 pdo_mysql_stmt_closecursor($db);
142 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_attr_oracle_nulls.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
16 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp))
20 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp));
26 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1);
30 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0);
34 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1);
35 $stmt = $db->query('SELECT VERSION() as _version');
42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
48 $stmt = $db->prepare('CALL p()');
[all …]
H A Dpdo_mysql_prepare_native_clear_error.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
17 $db->exec('DROP TABLE IF EXISTS test');
21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
26 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
44 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
45 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
66 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
74 $db = MySQLPDOTest::factory();
[all …]
H A Dtable.inc2 if (!$db) {
4 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
6 // $db->exec('DROP TABLE IF EXISTS test');
7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine);
8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
H A Dpdo_mysql_attr_fetch_table_names.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
15 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 1);
16 $stmt = $db->query('SELECT label FROM test LIMIT 1');
20 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 0);
21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
H A Dmysql_pdo_test.inc24 $db = new $classname($dsn, $user, $pass, $attr);
25 if (!$db) {
32 return $db;
39 $db->exec('DROP TABLE IF EXISTS test');
82 static function getClientVersion($db) {
86 static function getServerVersion($db) {
151 foreach ($db->query("SHOW ENGINES") as $row) {
169 static function dropTestTable($db = NULL) {
170 if (is_null($db))
171 $db = self::factory();
[all …]
H A Dpdo_mysql_stmt_blobs.phpt12 $db = MySQLPDOTest::factory();
25 function test_blob($db, $offset, $sql_type, $test_len) {
27 $db->exec('DROP TABLE IF EXISTS test');
40 $stmt = $db->query('SELECT id, label FROM test');
63 $stmt = $db->query('SELECT id, label FROM test');
83 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
84 test_blob($db, ++$offset, $sql_type, $test_len);
85 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
86 test_blob($db, ++$offset, $sql_type, $test_len);
94 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt13 $db = MySQLPDOTest::factory();
17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
18 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
21 $db->exec('DROP TABLE IF EXISTS test');
27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?');
38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
42 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?');
52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
60 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_attr_server_info.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode()));
17 $info = $db->getAttribute(PDO::ATTR_SERVER_INFO);
22 if (false !== $db->setAttribute(PDO::ATTR_SERVER_INFO, 'new uptime: 0s'))
25 $new_info = $db->getAttribute(PDO::ATTR_SERVER_INFO);
30 if (!$stmt = $db->query("SHOW STATUS LIKE '%uptime%'"))
31 printf("[004] Cannot run SHOW STATUS, [%s]\n", $db->errorCode());
34 printf("[005] Unable to fetch uptime, [%s]\n", $db->errorCode());
/PHP-7.4/ext/pdo/tests/
H A Dbug_34630.phpt15 $db = PDOTest::factory();
17 $driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
21 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val BLOB)');
23 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val VARCHAR(256))');
25 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
35 $db->beginTransaction();
36 …$insert = $db->prepare("insert into test (id, val) values (1, EMPTY_BLOB()) RETURNING val INTO :bl…
38 $insert = $db->prepare("insert into test (id, val) values (1, :blob)");
44 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
45 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_032.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
18 $db->exec("INSERT INTO test VALUES(1, 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'B')");
20 $db->exec("INSERT INTO test VALUES(3, 'C')");
23 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
24 $stmt = $db->prepare('SELECT * from test');
30 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);
31 $stmt = $db->prepare('SELECT * from test');
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug_49985.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->exec("CREATE TABLE test (a int PRIMARY KEY)");
20 $db->beginTransaction();
21 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)");
23 $db->commit();
26 $db->rollback();
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createfunction_with_flags.phpt11 $db = new PDO('sqlite::memory:');
13 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
15 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
19 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }, 1, PDO::SQLITE_DETERM…
22 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
26 $db->query('DROP TABLE foobar');
H A Dpdo_fetch_func_001.phpt10 $db = new PDO('sqlite::memory:');
15 $st = $db->query('SELECT * FROM testing');
18 $st = $db->query('SELECT name FROM testing');
21 $st = $db->query('SELECT * FROM testing');
24 $st = $db->query('SELECT * FROM testing');
27 $st = $db->query('SELECT * FROM testing');
30 $st = $db->query('SELECT * FROM testing');
33 $st = $db->query('SELECT * FROM testing');
42 public function __construct($db) {
60 new bar($db);
[all …]
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug46274.phpt13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
19 $db->exec("DROP TABLE test_one_blob");
23 $db->beginTransaction();
25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)');
27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
49 $res = $db->query("SELECT blob1 from test_one_blob");
56 $db->exec("DROP TABLE test_one_blob");
/PHP-7.4/ext/pgsql/tests/
H A D29nb_async_connect.phpt13 if (!$db = pg_connect($conn_str, PGSQL_CONNECT_ASYNC)) {
15 } elseif (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
17 } elseif ($db_socket = pg_socket($db)) {
24 switch ($status = pg_connect_poll($db)) {
39 assert(pg_connection_status($db) === PGSQL_CONNECTION_OK);
42 pg_close($db);
/PHP-7.4/ext/dba/tests/
H A Dbug72885.phpt13 $db = dba_open($db_filename, 'c', 'flatfile');
14 dba_insert('foo', 'bar', $db);
15 var_dump(dba_replace('foo', 'baz', $db));
16 var_dump(dba_fetch('foo', $db));
17 dba_close($db);
/PHP-7.4/ext/pdo_dblib/tests/
H A Dtimeout.phpt16 $stmt = $db->prepare($sql);
22 $db = new PDO($dsn, $user, $pass);
23 $db->setAttribute(PDO::ATTR_TIMEOUT, 1);
24 $stmt = $db->prepare($sql);
35 $db = new PDO($dsn, $user, $pass);
36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1);
37 $stmt = $db->prepare($sql);
48 $db = new PDO($dsn, $user, $pass, [PDO::ATTR_TIMEOUT => 1]);
49 $stmt = $db->prepare($sql);
60 $db = new PDO($dsn, $user, $pass, [PDO::DBLIB_ATTR_QUERY_TIMEOUT => 1]);
[all …]
H A Ddatetime2.phpt7 if (in_array($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION), ['4.2', '4.6', '5.0', '6.0', '7.0', '7…
15 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT));
17 $stmt = $db->query($sql);
20 $db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1);
21 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT));
22 $stmt = $db->query($sql);

Completed in 26 milliseconds

12345678910>>...32