Home
last modified time | relevance | path

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

12345678910>>...29

/PHP-5.5/ext/sqlite3/tests/
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_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());
H A Dsqlite3_31_open.phpt12 $db = new SQLite3(__DIR__ . '/db1.db');
13 $db->open(__DIR__ . '/db1.db');
20 <?php @unlink(__DIR__ . '/db1.db'); ?>
/PHP-5.5/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");
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-5.5/ext/pdo_mysql/tests/
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 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_bindparam.phpt12 $db = MySQLPDOTest::factory();
15 MySQLPDOTest::createTestTable($db);
17 function pdo_mysql_stmt_bindparam($db, $offset) {
90 pdo_mysql_stmt_bindparam($db, 3);
93 MySQLPDOTest::createTestTable($db);
95 pdo_mysql_stmt_bindparam($db, 4);
103 MySQLPDOTest::createTestTable($db);
105 pdo_mysql_stmt_bindparam($db, 5);
108 MySQLPDOTest::createTestTable($db);
110 pdo_mysql_stmt_bindparam($db, 6);
[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_init_command.phpt8 $db = MySQLPDOTest::factory();
21 $db = new PDO($dsn, $user, $pass);
22 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
26 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create));
28 $info = $db->errorInfo();
31 $db->exec(sprintf('INSERT INTO %s(id) VALUES (1)', $table));
32 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
35 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
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 Dbug44327.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 $stmt = $db->prepare("SELECT 1 AS \"one\"");
25 @$db->exec("DROP TABLE test");
26 $db->exec("CREATE TABLE test (id INT)");
27 $db->exec("INSERT INTO test(id) VALUES (1)");
28 $stmt = $db->prepare("SELECT id FROM test");
33 @$db->exec("DROP TABLE test");
37 $stmt = $db->prepare('foo');
H A Dpdo_mysql_stmt_blobfromsteam.phpt55 $db->exec('DROP TABLE IF EXISTS test');
57 $db->exec($sql);
77 var_export($db->errorInfo(), true));
97 $db->exec('DELETE FROM test');
116 $db = MySQLPDOTest::factory();
124 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
125 blob_from_stream(10, $db, $file, $blob);
129 blob_from_stream(30, $db, $file, $blob);
133 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
141 $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());
H A Dpdo_mysql_stmt_fetch_non_select.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
39 if (!is_object($stmt = $db->query('SHOW ENGINES')))
75 $db->exec('DEALLOCATE PREPARE mystmt');
81 var_export($db->errorInfo(), true));
109 $db->exec('DEALLOCATE PREPARE mystmt');
115 var_export($db->errorInfo(), true));
142 $db->exec('DEALLOCATE PREPARE mystmt');
148 var_export($db->errorInfo(), true));
[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,…
/PHP-5.5/ext/pgsql/tests/
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-5.5/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();
/PHP-5.5/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
361 THIS_INCLUDE=$i/include/db.h
365 …PHP_DBA_DB_CHECK(4, 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 db-4.0 d…
398 …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,…
411 THIS_INCLUDE=$i/db2/db.h
431 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)])
453 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do
464 THIS_INCLUDE=$i/db1/db.h
[all …]
/PHP-5.5/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-5.5/ext/pdo_sqlite/tests/
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-5.5/ext/spl/examples/
H A Ddba_dump.php32 $db = new DbaReader($argv[1], $argv[2]); variable
35 $db = new KeyFilter($db, $argv[3]); variable
38 foreach($db as $key => $val) {

Completed in 52 milliseconds

12345678910>>...29