Home
last modified time | relevance | path

Searched refs:db (Results 76 – 100 of 739) sorted by relevance

12345678910>>...30

/PHP-7.0/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createfunction.phpt8 $db = new pdo('sqlite::memory:');
10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
16 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); });
19 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
23 $db->query('DROP TABLE foobar');
/PHP-7.0/ext/sqlite3/tests/
H A Dbug73068.phpt8 $db = new \SQLite3(':memory:') ;
10 $db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)");
11 $db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')");
13 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'");
16 $db->exec("DELETE FROM t1 WHERE a='1' AND b='2'");
18 $r = $db->query("SELECT * FROM t1;");
21 $db->close();
H A Dsqlite3_32_changes.phpt10 $db = new SQLite3(':memory:');
11 //$db = new SQLite3('mysqlitedb.db');
12 $db->exec('CREATE TABLE pageView(id INTEGER PRIMARY KEY, page CHAR(256), access INTEGER(10))');
13 $db->exec('INSERT INTO pageView (page, access) VALUES (\'test\', \'000000\')');
14 echo $db->changes("dummy");
H A Dsqlite3_25_create_aggregate.phpt25 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)'));
28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
34 $db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1);
36 print_r($db->querySingle("SELECT S(a), S(b) FROM test", true));
39 var_dump($db->close());
H A Dsqlite3_29_createfunction.phpt11 var_dump($db->createfunction($func, $func));
12 var_dump($db->querySingle('SELECT strtoupper("test")'));
15 var_dump($db->createfunction($func2, $func2));
16 var_dump($db->querySingle('SELECT strtolower("TEST")'));
18 var_dump($db->createfunction($func, $func2));
19 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
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());
/PHP-7.0/ext/dba/tests/
H A Ddba009.phpt12 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) {
14 dba_insert("a", "Inserted", $db);
15 echo dba_fetch("a", $db)."\n";
16 dba_close($db);
21 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) {
23 dba_insert("a", "Inserted", $db);
24 echo dba_fetch("a", $db)."\n";
/PHP-7.0/ext/pdo_mysql/tests/
H A Dbug53551.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
21 $db->exec('drop table if exists bug53551');
22 $db->exec($createSql);
23 $db->exec("insert into bug53551 set `count` = 1 ");
24 $db->exec("SET sql_mode = 'Traditional'");
26 $stmt = $db->prepare($sql);
46 $db = MySQLPDOTest::factory();
47 $db->exec('DROP TABLE IF EXISTS bug53551');
H A Dbug_44707.phpt11 $db = MySQLPDOTest::factory();
12 $stmt = $db->query('SELECT VERSION() as _version');
29 function bug_44707($db) {
31 $db->exec('DROP TABLE IF EXISTS test');
32 $db->exec('CREATE TABLE test(id INT, mybool TINYINT)');
48 $stmt = $db->query('SELECT * FROM test');
57 $stmt = $db->query('SELECT * FROM test');
66 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
67 bug_44707($db);
71 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
[all …]
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_prepare_native_named_placeholder.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
17 $db->exec('DROP TABLE IF EXISTS test');
20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
21 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
38 $stmt = $db->prepare('SELECT id, label FROM test');
43 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
44 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
64 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
72 $db = MySQLPDOTest::factory();
[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 Dpecl_bug_5780.phpt13 $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt');
15 $db->exec("CREATE TABLE test (login varchar(32) NOT NULL, data varchar(64) NOT NULL)");
16 $db->exec("CREATE TABLE test2 (login varchar(32) NOT NULL, password varchar(64) NOT NULL)");
17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')");
18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')");
20 $logstmt = $db->prepare('INSERT INTO test (login, data) VALUES (:var1, :var2)');
21 $authstmt = $db->prepare('SELECT * FROM test2 WHERE login = :varlog AND password = :varpass');
32 $db = MySQLPDOTest::factory();
33 $db->exec('DROP TABLE IF EXISTS test');
34 $db->exec('DROP TABLE IF EXISTS test2');
H A Dbug70862.phpt12 $db = MySQLPDOTest::factory();
14 $db->exec('DROP TABLE IF EXISTS test');
15 $db->exec(sprintf('CREATE TABLE test(id INT, label BLOB)'));
17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
18 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
30 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, :para)');
41 $db = MySQLPDOTest::factory();
42 $db->exec('DROP TABLE IF EXISTS test');
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 Dbug70272.phpt19 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
22 $a->c = $db;
23 $a->b = $db->prepare("select 1");
24 $a->d = $db->prepare("select 2");
25 $a->e = $db->prepare("select 3");
26 $a->f = $db->prepare("select 4");
/PHP-7.0/ext/pgsql/tests/
H A D24sync_query_prepared.phpt13 $db = pg_connect($conn_str);
15 $version = pg_version($db);
17 $result = pg_prepare($db, "php_test", "SELECT * FROM ".$table_name." WHERE num > \$1;");
20 $result = pg_execute($db, "php_test", array(100));
43 pg_num_rows(pg_execute($db, "php_test", array(100)));
44 pg_num_fields(pg_execute($db, "php_test", array(100)));
52 $result = pg_prepare($db, "php_test2", "INSERT INTO ".$table_name." VALUES (\$1, \$2);");
55 $result = pg_execute($db, "php_test2", array(9999, "A'BC"));
60 pg_close($db);
H A D27large_object_oid.phpt15 $db = pg_connect($conn_str);
18 pg_exec ($db, "begin");
19 $oid = pg_lo_create ($db, 21000);
22 pg_lo_unlink ($db, $oid);
23 pg_exec ($db, "commit");
26 pg_exec ($db, "begin");
27 $oid = pg_lo_create ($db, "21001");
30 pg_lo_unlink ($db, $oid);
31 pg_exec ($db, "commit");
H A D9999dropdb.phpt2 PostgreSQL drop db
11 $db = pg_connect($conn_str);
12 pg_query($db, "DROP VIEW {$view_name}");
13 pg_query($db, "DROP TABLE ".$table_name);
14 @pg_query($db, "DROP TABLE ".$table_name_92);
H A D04async_query.phpt10 $db = pg_connect($conn_str);
12 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) {
15 while(pg_connection_busy($db)); // busy wait: intended
16 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
19 if (!($result = pg_get_result($db)))
44 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
45 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
53 if (!pg_send_query($db, "INSERT INTO ".$table_name." VALUES (8888, 'GGG');"))
/PHP-7.0/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_033.phpt15 $db = PDOTest::factory();
19 $quoted = $db->quote($unquoted);
23 @$db->exec("DROP TABLE test");
25 $db->query("CREATE TABLE test (t char($len))");
26 $db->query("INSERT INTO test (t) VALUES($quoted)");
28 $stmt = $db->prepare('SELECT * from test');
33 $db->exec("DROP TABLE test");
/PHP-7.0/ext/dba/
H A Dconfig.m4315 if test -f "$i/db5/db.h"; then
317 THIS_INCLUDE=$i/db5/db.h
321 THIS_INCLUDE=$i/db4/db.h
365 THIS_INCLUDE=$i/include/db.h
369 …PHP_DBA_DB_CHECK(4, db-5.3 db-5.1 db-5.0 db-4.8 db-4.7 db-4.6 db-4.5 db-4.4 db-4.3 db-4.2 db-4.1 d…
402 …PHP_DBA_DB_CHECK(3, db-3.3 db-3.2 db-3.1 db-3.0 db-3 db3 db, [(void)db_create((DB**)0, (DB_ENV*)0,…
415 THIS_INCLUDE=$i/db2/db.h
435 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)])
457 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do
468 THIS_INCLUDE=$i/db1/db.h
[all …]
/PHP-7.0/ext/pdo_pgsql/tests/
H A Dbug_49985.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/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();
H A Dbug72633.phpt15 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->query('CREATE TABLE test_last_id (id SERIAL NOT NULL, field1 VARCHAR(10))');
21 $stmt = $db->prepare("INSERT INTO test_last_id (field1) VALUES ('test')");
28 var_dump($db->lastInsertId());
32 var_dump($db->lastInsertId('test_last_id_id_seq'));
34 $db->query('DROP TABLE test_last_id');

Completed in 54 milliseconds

12345678910>>...30