Home
last modified time | relevance | path

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

12345678910>>...29

/PHP-5.5/ext/sybase_ct/tests/
H A Dbug22403.phpt14 $db= sybase_connect_ex();
20 var_dump(sybase_select_db(TEMPDB, $db));
21 if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) {
38 var_dump(sybase_select_ex($db, 'exec '.$sp_name));
39 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' "foo"'));
40 var_dump(sybase_select_ex($db, 'exec does_not_exist'));
43 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' NULL'));
44 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' 1'));
49 sybase_close($db);
H A Dtest_connectionbased_msghandler.phpt14 $db= sybase_connect_ex();
15 var_dump($db);
16 var_dump(sybase_set_message_handler('sybase_msg_handler', $db));
17 var_dump(sybase_select_ex($db, 'select getdate(NULL)'));
18 sybase_close($db);
H A Dbug27843.phpt14 $db= sybase_connect_ex();
18 var_dump(sybase_select_db(TEMPDB, $db));
19 if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) {
34 var_dump(sybase_select_ex($db, 'exec '.$sp_name));
37 var_dump(sybase_query('drop proc '.$sp_name, $db));
39 sybase_close($db);
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_change_user.phpt31 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
33 $host, $user, $db, $port, $socket);
45 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
47 $host, $user, $db, $port, $socket);
59 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db)))
69 if ($tmp['dbname'] != $db)
81 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
83 $host, $user, $db, $port, $socket);
93 $host, $user, $db, $port, $socket);
97 (empty db = no db send with COM_CHANGE_USER) */
[all …]
H A Dbug29311.phpt15 global $host, $user, $passwd, $db, $port, $socket;
16 parent::__construct($host, $user, $passwd, $db, $port, $socket);
24 global $host, $user, $passwd, $db, $port, $socket;
25 $this->connect($host, $user, $passwd, $db, $port, $socket);
36 $foo[2] = new mysql3($host, $user, $passwd, $db, $port, $socket);
42 if ($row[0] != $db)
/PHP-5.5/ext/pgsql/tests/
H A D21pg_get_notify.phpt11 $db = pg_connect($conn_str);
12 pg_query($db, 'LISTEN test_msg');
13 pg_query($db, 'NOTIFY test_msg');
15 $msg = pg_get_notify($db);
/PHP-5.5/ext/sqlite3/tests/
H A Dbug53463.phpt8 $db = new SQLite3(':memory:');
10 $db->exec('CREATE TABLE test (whatever INTEGER)');
11 $db->exec('INSERT INTO test (whatever) VALUES (1)');
13 $result = $db->query('SELECT * FROM test');
22 $db->close();
H A Dsqlite3_18_changes.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 var_dump($db->exec("UPDATE test SET id = 'c'"));
22 var_dump($db->changes());
25 var_dump($db->close());
H A Dsqlite3_36_create_collation.phpt10 $db->createCollation('NAT', 'strnatcmp');
12 $db->exec('CREATE TABLE t (s varchar(4))');
14 $stmt = $db->prepare('INSERT INTO t VALUES (?)');
20 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort
21 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
33 $db->close();
H A Dsqlite3_12_unfinalized_stmt_cleanup.phpt12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
28 var_dump($db->close());
29 echo "Check db was closed\n";
48 Check db was closed
H A Dsqlite3_35_stmt_readonly.phpt17 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
28 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
32 $stmt = $db->prepare("DELETE FROM test");
36 var_dump($db->close());
H A Dbug45798.phpt10 $db->exec('CREATE TABLE test (time INTEGER, id STRING)');
12 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')");
13 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
15 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
26 $db->close();
H A Dsqlite3result_fetcharray_with_two_params_fails.phpt10 $db = new SQLite3(':memory:');
11 $db->exec('CREATE TABLE foo (bar STRING)');
12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
15 $result = $db->query('SELECT bar FROM foo');
/PHP-5.5/ext/pdo/tests/
H A Dbug_43139.phpt15 $db = PDOTest::factory();
17 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
21 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
23 } else if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'firebird') {
27 var_dump($db->query("select 0 as abc, 1 as xyz, 2 as def $from")->fetchAll(PDO::FETCH_GROUP));
H A Dpdo_001.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')");
22 $stmt = $db->prepare('SELECT * from test');
H A Dpdo_002.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')");
22 $stmt = $db->prepare('SELECT * from test');
H A Dpdo_008.phpt15 $db = PDOTest::factory();
17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
18 $db->exec("INSERT INTO test VALUES('A', 'A')");
19 $db->exec("INSERT INTO test VALUES('B', 'A')");
20 $db->exec("INSERT INTO test VALUES('C', 'C')");
22 $stmt = $db->prepare('SELECT val, id from test');
H A Dbug_44173.phpt15 $db = PDOTest::factory();
17 $db->exec("CREATE TABLE test (x int)");
18 $db->exec("INSERT INTO test VALUES (1)");
22 $stmt = $db->query();
27 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, 0);
32 $stmt = $db->query("SELECT * FROM test", 'abc');
37 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
42 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
47 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
52 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
H A Dpdo_004.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')");
22 $stmt = $db->prepare('SELECT * from test');
H A Dpdo_003.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')");
22 $stmt = $db->prepare('SELECT * from test');
/PHP-5.5/ext/pdo_dblib/tests/
H A Dbug_47588.phpt12 $db->query('CREATE TABLE "Test Table" ("My Field" int, "Another Field" varchar(32) not null default…
13 $db->query('INSERT INTO "Test Table" ("My Field") values(1)');
14 $db->query('INSERT INTO "Test Table" ("My Field") values(2)');
15 $db->query('INSERT INTO "Test Table" ("My Field") values(3)');
16 $rs = $db->query('SELECT * FROM "Test Table"');
18 $db->query('DROP TABLE "Test Table"');
/PHP-5.5/ext/mysql/tests/
H A D001.phpt19 $db = mysql_connect($host, $user, $passwd);
20 $test .= ($db) ? '1' : '0';
21 mysql_close($db);
24 $db = mysql_connect($host, $user, $passwd, true);
25 $test .= ($db) ? '1' : '0';
26 mysql_close($db);
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug57702.phpt13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
19 $stmt = $db->prepare($query);
23 $stmt = $db->prepare($query);
26 function do_insert($db, $id, $data1, $data2)
28 $db->beginTransaction();
41 $db->commit();
44 do_insert($db, 1, "row 1 col 1", "row 1 col 2");
45 do_insert($db, 2, "row 2 col 1", "row 2 col 2");
52 $stmt = $db->prepare('select data1, data2 from bug57702 order by id');
107 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); // Let's use streams
[all …]
/PHP-5.5/ext/pdo_mysql/tests/
H A Dbug_45120.phpt14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
16 function bug_45120($db) {
18 $stmt = $db->prepare("SELECT 1 AS 'one'");
36 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
37 bug_45120($db);
40 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
41 bug_45120($db);
H A Dbug63176.phpt2 Bug #63176 (Segmentation fault when instantiate 2 persistent PDO to the same db server)
25 …$this->db = new PDO2(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, array(PDO::ATTR…
27 …$this->db = new PDO3(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, array(PDO::ATTR…
29 $this->db->query('SELECT 1')->fetchAll();
42 ["db"]=>
49 ["db"]=>

Completed in 31 milliseconds

12345678910>>...29