Home
last modified time | relevance | path

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

12345678910>>...35

/php-src/ext/pdo_mysql/tests/
H A Dbug_41997.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
18 $db->exec("CREATE PROCEDURE {$procedure}() BEGIN SELECT 1 AS 'one'; END");
20 $stmt = $db->query("CALL {$procedure}()");
26 $stmt = $db->query('SELECT 2 AS "two"');
34 $db = MySQLPDOTest::factory();
35 $db->exec("DROP PROCEDURE IF EXISTS bug_41997_pdo_mysql_p");
H A Dbug70862.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec(sprintf('CREATE TABLE test_70862(id INT, label BLOB)'));
17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
18 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
31 $stmt = $db->prepare('INSERT INTO test_70862(id, label) VALUES (1, :para)');
42 $db = MySQLPDOTest::factory();
43 $db->exec('DROP TABLE IF EXISTS test_70862');
H A Dbug53551.phpt13 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
21 $db->exec($createSql);
22 $db->exec("INSERT INTO bug53551 SET `count` = 1 ");
23 $db->exec("SET sql_mode = 'Traditional'");
25 $stmt = $db->prepare($sql);
44 $db = MySQLPDOTest::factory();
45 $db->exec('DROP TABLE IF EXISTS bug53551');
H A Dpdo_mysql_attr_server_info.phpt13 $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_subclass.phpt54 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
55 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
56 $db->exec('CREATE TABLE test_subclass(id INT)');
57 $db->exec('INSERT INTO test_subclass(id) VALUES (1), (2)');
58 $stmt = $db->query('SELECT * FROM test_subclass ORDER BY id ASC');
61 $db->intercept_call();
66 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
69 $db->exec('DROP TABLE IF EXISTS test_subclass');
75 $db = MySQLPDOTest::factory();
76 $db->exec('DROP TABLE IF EXISTS test_subclass');
H A Dpdo_mysql_stmt_blobs.phpt13 $db = MySQLPDOTest::factory();
26 function test_blob($db, $offset, $sql_type, $test_len) {
28 $db->exec('DROP TABLE IF EXISTS test_stmt_blobs');
41 $stmt = $db->query('SELECT id, label FROM test_stmt_blobs');
70 $stmt = $db->query('SELECT id, label FROM test_stmt_blobs');
90 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
91 test_blob($db, ++$offset, $sql_type, $test_len);
92 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
93 test_blob($db, ++$offset, $sql_type, $test_len);
101 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_native_named_placeholder.phpt13 $db = MySQLPDOTest::factory();
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
20 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
24 …$stmt = $db->prepare("INSERT INTO test_prepare_native_named_placeholder(id, label) VALUES (100, ':…
37 $stmt = $db->prepare('SELECT id, label FROM test_prepare_native_named_placeholder');
42 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
43 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
57 … $stmt = $db->prepare('SELECT id, label FROM test_prepare_native_named_placeholder ORDER BY id');
63 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
71 $db = MySQLPDOTest::factory();
[all …]
/php-src/ext/dba/tests/
H A Ddba_array_keys_errors.phpt13 $name = 'array_keys_errors.db';
15 $db = get_any_db($name);
18 dba_insert([], "Content String 1", $db);
23 dba_insert(["a", "b", "c"], "Content String 2", $db);
31 var_dump(dba_insert([$o, 'obj'], 'Test', $db));
36 var_dump(dba_insert(['group', $o], 'Test', $db));
41 dba_close($db);
47 $db_name = 'array_keys_errors.db';
H A Dbug71514.phpt13 $db = dba_open($filename, 'c', 'inifile');
15 dba_insert('foo', 'value1', $db);
16 dba_replace('foo', 'value2', $db);
17 var_dump(dba_fetch('foo', $db));
19 dba_close($db);
/php-src/ext/pdo/tests/
H A Dbug_52098.phpt16 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test52098 (x int)");
19 $db->exec("INSERT INTO test52098 VALUES (1)");
31 $derived = $db->prepare('SELECT * FROM test52098', array(PDO::ATTR_STATEMENT_CLASS=>array('MyStatem…
40 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('MyStatement'));
41 $r = $db->query('SELECT * FROM test52098');
55 $db = PDOTest::factory();
56 PDOTest::dropTableIfExists($db, "test52098");
H A Dpdo_020.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test020(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))');
19 $db->exec("INSERT INTO test020 VALUES(1, 'A', 'A')");
20 $db->exec("INSERT INTO test020 VALUES(2, 'B', 'B')");
21 $db->exec("INSERT INTO test020 VALUES(3, 'C', 'C')");
25 $stmt = $db->query($sql);
35 $db = PDOTest::factory();
36 PDOTest::dropTableIfExists($db, "test020");
H A Dgh8626.phpt12 $db = PDOTest::factory();
13 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
22 $db = PDOTest::factory();
23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
25 $db->exec('CREATE TABLE test8626 (x int NOT NULL)');
27 $stmt = $db->prepare('INSERT INTO test8626 VALUES(?)');
45 $db = PDOTest::factory();
46 PDOTest::dropTableIfExists($db, "test8626");
H A Dbug_39398.phpt17 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test39398 (test INT)");
21 $stmt = $db->prepare('INSERT INTO test39398 VALUES (:boolean)');
25 var_dump($db->query("SELECT * FROM test39398")->fetchAll(PDO::FETCH_ASSOC));
30 $db = PDOTest::factory();
31 PDOTest::dropTableIfExists($db, "test39398");
H A Dbug_40285.phpt17 $db = PDOTest::factory();
19 $db->exec('CREATE TABLE test40285 (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32), fiel…
21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
22 $s = $db->prepare("INSERT INTO test40285 VALUES( ':id', 'name', 'section', 22)" );
30 $db = PDOTest::factory();
31 PDOTest::dropTableIfExists($db, "test40285");
H A Dbug_50458.phpt17 $db = PDOTest::factory();
18 $db->exec("CREATE TABLE test50458 (a VARCHAR(10))");
19 $db->exec("INSERT INTO test50458 (a) VALUES ('xyz')");
20 $res = $db->query("SELECT a FROM test50458");
27 $db = PDOTest::factory();
28 PDOTest::dropTableIfExists($db, "test50458");
/php-src/ext/pdo_sqlite/tests/
H A Dgh13998.phpt13 $db = new PDO('sqlite::memory:');
14 $db->query('CREATE TABLE test (a int, b int)');
15 $stmt = $db->query('INSERT INTO test VALUES (1, 1), (2, 2), (3, 3)');
16 $db->sqliteCreateAggregate('S', $step, $finalize, 1);
19 $db->query('SELECT S(a) FROM test');
H A Dpdo_sqlite_createaggregate.phpt8 $db = new PDO('sqlite::memory:');
10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO test_pdo_sqlite_createaggregate VALUES (NULL, "PHP"), (NULL, "PHP6")');
14 $db->sqliteCreateAggregate('testing', function(&$a, $b) { $a .= $b; return $a; }, function(&$v) { r…
17 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createaggregate') as $row) {
H A Dpdo_sqlite_open_flags.phpt8 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
11 $db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
13 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags (id INT);'));
15 $db = new PDO('sqlite:' . $filename, null, null, [PDO::SQLITE_ATTR_OPEN_FLAGS => PDO::SQLITE_OPEN_R…
17 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags_2 (id INT);'));
21 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
H A Dbug33841.phpt8 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
10 $db->exec('CREATE TABLE test_33841 (text)');
12 $stmt = $db->prepare("INSERT INTO test_33841 VALUES ( :text )");
17 $stmt = $db->prepare("UPDATE test_33841 SET text = :text ");
25 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
26 $db->exec('DROP TABLE IF EXISTS test_33841');
/php-src/ext/sqlite3/tests/
H A Dsqlite3_39_toggleExtended.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
14 echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL;
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
18 echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL;
21 $db->enableExtendedResultCodes(true);
22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)");
23 echo "Third (Extended) Error Code: " . $db->lastErrorCode() . PHP_EOL;
26 var_dump($db->close());
H A Dsqlite3_rename_column.phpt14 $db = new SQLite3(':memory:');
16 $db->exec('CREATE TABLE tbl (orig text)');
17 $db->exec('insert into tbl values ("one"), ("two")');
19 $res1 = $db->prepare('select * from tbl')->execute();
20 $res2 = $db->prepare('select * from tbl')->execute();
25 $db->exec('alter table tbl rename column orig to changed');
/php-src/ext/pdo_pgsql/tests/
H A Dlarge_objects.phpt15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
21 $db->beginTransaction();
22 $oid = $db->pgsqlLOBCreate();
24 $stm = $db->pgsqlLOBOpen($oid, 'w+b');
38 $stmt = $db->prepare("SELECT * from test_large_objects");
49 $stmt = $db->prepare("SELECT * from test_large_objects");
79 $db->pgsqlLOBUnlink($oid);
84 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
[all …]
H A Dbug71885.phpt16 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM);
21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
24 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
30 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
/php-src/ext/pdo_odbc/tests/
H A Dbug80783.phpt13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
14 $db->exec("CREATE TABLE bug80783 (name IMAGE)");
17 $db->exec("INSERT INTO bug80783 VALUES('$string')");
19 $stmt = $db->prepare("SELECT name FROM bug80783");
29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
30 $db->exec("DROP TABLE IF EXISTS bug80783");
/php-src/ext/pgsql/tests/
H A D10pg_convert_json_array.phpt17 $db = pg_connect($conn_str);
18 pg_query($db, "CREATE TABLE {$table_name_92} (textary text[], jsn json)");
24 $converted = pg_convert($db, $table_name_92, $fields);
27 if (!pg_insert($db, $table_name_92, $fields)) {
39 $db = pg_connect($conn_str);
40 pg_query($db, "DROP TABLE IF EXISTS {$table_name_92}");

Completed in 29 milliseconds

12345678910>>...35