/PHP-5.5/ext/sybase_ct/tests/ |
H A D | bug22403.phpt | 14 $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 D | test_connectionbased_msghandler.phpt | 14 $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 D | bug27843.phpt | 14 $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 D | mysqli_change_user.phpt | 31 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 D | bug29311.phpt | 15 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 D | 21pg_get_notify.phpt | 11 $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 D | bug53463.phpt | 8 $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 D | sqlite3_18_changes.phpt | 12 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 D | sqlite3_36_create_collation.phpt | 10 $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 D | sqlite3_12_unfinalized_stmt_cleanup.phpt | 12 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 D | sqlite3_35_stmt_readonly.phpt | 17 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 D | bug45798.phpt | 10 $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 D | sqlite3result_fetcharray_with_two_params_fails.phpt | 10 $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 D | bug_43139.phpt | 15 $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 D | pdo_001.phpt | 15 $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 D | pdo_002.phpt | 15 $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 D | pdo_008.phpt | 15 $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 D | bug_44173.phpt | 15 $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 D | pdo_004.phpt | 15 $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 D | pdo_003.phpt | 15 $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 D | bug_47588.phpt | 12 $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 D | 001.phpt | 19 $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 D | bug57702.phpt | 13 $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 D | bug_45120.phpt | 14 $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 D | bug63176.phpt | 2 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"]=>
|