Home
last modified time | relevance | path

Searched refs:db (Results 126 – 150 of 868) sorted by relevance

12345678910>>...35

/php-src/ext/pdo/tests/
H A Dpdo_002.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test002(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test002 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test002 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test002 VALUES(3, 'C')");
23 $stmt = $db->prepare('SELECT * from test002');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test002");
H A Dbug_71885.phpt19 $db = PDOTest::factory();
20 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
22 $db->exec("CREATE TABLE test71885 (a int)");
27 $db->exec($sql);
33 $stmt = $db->prepare($sql);
39 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
40 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
44 $stmt = $db->prepare($sql);
54 $db = PDOTest::factory();
55 PDOTest::dropTableIfExists($db, "test71885");
H A Dbug_73234.phpt13 $db = PDOTest::factory();
14 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
23 $db = PDOTest::factory();
24 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
26 switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
34 $db->exec($sql);
36 $stmt = $db->prepare('INSERT INTO test73234 VALUES(:value)');
44 $stmt = $db->query('SELECT * FROM test73234');
50 $db = PDOTest::factory();
51 PDOTest::dropTableIfExists($db, "test73234");
H A Dpdo_019.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test019(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
19 $db->exec("INSERT INTO test019 VALUES(0, 'String0')");
20 $db->exec("INSERT INTO test019 VALUES(1, 'String1')");
21 $db->exec("INSERT INTO test019 VALUES(2, 'String2')");
22 $db->exec("INSERT INTO test019 VALUES(3, 'String3')");
25 var_dump($db->query('SELECT COUNT(*) FROM test019')->fetchColumn());
27 $stmt = $db->prepare('SELECT idx, txt FROM test019 ORDER by idx');
47 $db = PDOTest::factory();
48 PDOTest::dropTableIfExists($db, "test019");
H A Dpdo_test.inc35 $db = new $classname($dsn, $user, $pass, $attr);
37 if (!$db) {
41 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
43 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
44 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
45 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
46 return $db;
51 $db = PDOTest::factory();
78 match ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
79 "oci" => $db->exec(<<<SQL
[all …]
H A Dpdo_009.phpt16 $db = PDOTest::factory();
19 $db->exec("INSERT INTO classtypes009 VALUES(0, 'stdClass')");
20 $db->exec("INSERT INTO classtypes009 VALUES(1, 'Test1')");
21 $db->exec("INSERT INTO classtypes009 VALUES(2, 'Test2')");
23 $db->exec("INSERT INTO test009 VALUES(1, 0, 'A')");
24 $db->exec("INSERT INTO test009 VALUES(2, 1, 'B')");
25 $db->exec("INSERT INTO test009 VALUES(3, 2, 'C')");
26 $db->exec("INSERT INTO test009 VALUES(4, 3, 'D')");
73 $db = PDOTest::factory();
74 PDOTest::dropTableIfExists($db, "test009");
[all …]
H A Dpdo_010.phpt16 $db = PDOTest::factory();
19 $db->exec("INSERT INTO classtypes010 VALUES(0, 'stdClass')");
20 $db->exec("INSERT INTO classtypes010 VALUES(1, 'Test1')");
21 $db->exec("INSERT INTO classtypes010 VALUES(2, 'Test2')");
23 $db->exec("INSERT INTO test010 VALUES(1, 0, 'A', 'Group1')");
24 $db->exec("INSERT INTO test010 VALUES(2, 1, 'B', 'Group1')");
25 $db->exec("INSERT INTO test010 VALUES(3, 2, 'C', 'Group2')");
26 $db->exec("INSERT INTO test010 VALUES(4, 3, 'D', 'Group2')");
74 $db = PDOTest::factory();
75 PDOTest::dropTableIfExists($db, "test010");
[all …]
H A Dpdo_001.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test001(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test001 VALUES(1, 'A')");
20 $db->exec("INSERT INTO test001 VALUES(2, 'B')");
21 $db->exec("INSERT INTO test001 VALUES(3, 'C')");
23 $stmt = $db->prepare('SELECT * from test001');
31 $db = PDOTest::factory();
32 PDOTest::dropTableIfExists($db, "test001");
H A Dpdo_008.phpt16 $db = PDOTest::factory();
18 $db->exec('CREATE TABLE test008(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
19 $db->exec("INSERT INTO test008 VALUES('A', 'A')");
20 $db->exec("INSERT INTO test008 VALUES('B', 'A')");
21 $db->exec("INSERT INTO test008 VALUES('C', 'C')");
23 $stmt = $db->prepare('SELECT val, id from test008');
32 $db = PDOTest::factory();
33 PDOTest::dropTableIfExists($db, "test008");
/php-src/ext/pdo_pgsql/tests/
H A Dbug72633.phpt17 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
19 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
21 $db->query('CREATE TABLE test72633 (id SERIAL NOT NULL, field1 VARCHAR(10))');
23 $stmt = $db->prepare("INSERT INTO test72633 (field1) VALUES ('test')");
30 var_dump($db->lastInsertId());
34 var_dump($db->lastInsertId('test72633_id_seq'));
40 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
41 $db->query('DROP TABLE IF EXISTS test72633');
/php-src/ext/pdo_mysql/tests/
H A Dpdomysql_002.phpt15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
16 if (!$db instanceof Pdo\Mysql) {
17 echo "Wrong class type. Should be Pdo\Mysql but is " . get_class($db) . "\n";
20 $db->exec('CREATE TABLE pdomysql_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))');
21 $db->exec("INSERT INTO pdomysql_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')");
23 foreach ($db->query('SELECT name FROM pdomysql_002') as $row) {
32 $db = MySQLPDOTest::factory();
33 $db->query('DROP TABLE pdomysql_002');
H A Dpdo_mysql_stmt_errorcode.phpt13 $db = MySQLPDOTest::factory();
15 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_errorcode_ihopeitdoesnotexist');
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
20 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
23 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
30 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
35 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
36 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
39 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
45 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql___construct.phpt23 (isset($db) && is_object($db)) ? $db->errorCode() : 'n/a',
24 (isset($db) && is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a');
32 if (NULL !== ($db = @new PDO()))
37 print tryandcatch(2, '$db = new PDO(chr(0));');
62 $db = new PDO($dsn, $user, $pass);
145 $db = PDO_MYSQL_TEST_DB;
182 $db = new PDO($dsn, $user, $pass);
203 $db = new PDO($dsn, $user, $pass);
242 $db = new PDO($dsn, $user, $pass);
282 (is_object($db)) ? $db->errorCode() : 'n/a',
[all …]
H A Dbug70272.phpt18 $db = MySQLPDOTest::factory();
21 $a->c = $db;
22 $a->b = $db->prepare("select 1");
23 $a->d = $db->prepare("select 2");
24 $a->e = $db->prepare("select 3");
25 $a->f = $db->prepare("select 4");
H A Dpdo_mysql_stmt_bindparam.phpt13 $db = MySQLPDOTest::factory();
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
17 MySQLPDOTest::createTestTable($table, $db);
19 function pdo_mysql_stmt_bindparam($db, $offset) {
93 pdo_mysql_stmt_bindparam($db, 3);
96 MySQLPDOTest::createTestTable($table, $db);
98 pdo_mysql_stmt_bindparam($db, 4);
108 pdo_mysql_stmt_bindparam($db, 5);
113 pdo_mysql_stmt_bindparam($db, 6);
117 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_prepare_native.phpt13 $db = MySQLPDOTest::factory();
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
23 $tmp = $db->errorInfo();
86 $db->errorCode(), implode(' ', $db->errorInfo()));
94 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
105 $stmt = prepex(4, $db, 'SELECT 1 as "one"');
123 prepex(9, $db, 'DELETE FROM test_prepare_native');
156 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
164 $db = MySQLPDOTest::factory();
[all …]
H A Dpdo_mysql_prepare_native_myisam.phpt13 $db = MySQLPDOTest::factory();
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
23 $tmp = $db->errorInfo();
86 $db->errorCode(), implode(' ', $db->errorInfo()));
94 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
130 $db->exec('DELETE FROM test_prepare_native_myisam');
134 $db->quote('%ro%'));
140 $db->quote('%go%'));
146 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
[all …]
H A Dpdo_mysql_attr_init_command.phpt21 $db = new PDO($dsn, $user, $pass);
25 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create));
26 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
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));
40 $db = MySQLPDOTest::factory();
41 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_init_command');
H A Dpdo_mysql_prepare_emulated_anonymous.phpt13 $db = MySQLPDOTest::factory();
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
17 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
30 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous');
36 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
37 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
40 $db->exec('DELETE FROM test_prepare_emulated_anonymous');
49 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous');
55 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
63 $db = MySQLPDOTest::factory();
[all …]
/php-src/ext/pgsql/tests/
H A D04async_query.phpt13 $db = pg_connect($conn_str);
14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
15 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES");
17 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) {
20 while(pg_connection_busy($db)); // busy wait: intended
21 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) {
24 if (!($result = pg_get_result($db)))
49 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
50 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
74 $db = pg_connect($conn_str);
[all …]
/php-src/ext/dba/tests/
H A Ddba009.phpt16 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) {
18 dba_insert("a", "Inserted", $db);
19 echo dba_fetch("a", $db)."\n";
20 dba_close($db);
25 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) {
27 dba_insert("a", "Inserted", $db);
28 echo dba_fetch("a", $db)."\n";
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createcollation.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10…
15 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); });
17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL…
22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
H A Dpdo_sqlite_extendederror_attr.phpt9 $db = new PDO('sqlite::memory:');
10 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
15 $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
16 $errorInfo = $db->errorInfo();
20 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
21 $errorInfo = $db->errorInfo();
27 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
32 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
33 $errorInfo = $db->errorInfo();
37 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
[all …]
H A Dbug38334.phpt8 $db = new PDO('sqlite::memory:');
9 $db->exec('CREATE TABLE test_38334 (i INTEGER , f DOUBLE, s VARCHAR(255))');
10 $db->exec('INSERT INTO test_38334 VALUES (42, 46.7, "test")');
11 var_dump($db->query('SELECT * FROM test_38334')->fetch(PDO::FETCH_ASSOC));
14 $db->exec('INSERT INTO test_38334 VALUES (10000000000, 0.0, "")');
15 $i = $db->query('SELECT i FROM test_38334 WHERE f = 0.0')->fetchColumn(0);
23 $db->exec('INSERT INTO test_38334 VALUES ("test", "test", "x")');
24 var_dump($db->query('SELECT * FROM test_38334 WHERE s = "x"')->fetch(PDO::FETCH_ASSOC));
/php-src/ext/sqlite3/tests/
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');
20 //var_dump($db);
21 //var_dump($db->close());

Completed in 30 milliseconds

12345678910>>...35