/PHP-7.1/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_errmode.phpt | 8 $db = MySQLPDOTest::factory(); 15 $db = MySQLPDOTest::factory(); 45 $code = $db->errorCode(); 46 $info = $db->errorInfo(); 61 $code = $db->errorCode(); 62 $info = $db->errorInfo(); 80 $code = $db->errorCode(); 81 $info = $db->errorInfo(); 116 global $db, $line; 118 $code = $db->errorCode(); [all …]
|
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 22 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); 23 MySQLPDOTest::createTestTable($db); 25 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2'); 58 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 61 $db->exec('DROP TABLE IF EXISTS test');
|
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"]=>
|
/PHP-7.1/ext/pdo/tests/ |
H A D | bug_39656.phpt | 16 $db = PDOTest::factory(); 18 @$db->exec("DROP TABLE test"); 19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 21 $db->exec("CREATE TABLE test (id INTEGER NOT NULL PRIMARY KEY, usr VARCHAR( 256 ) NOT NULL)"); 22 $db->exec("INSERT INTO test (id, usr) VALUES (1, 'user')"); 24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?"); 35 @$db->exec("DROP TABLE test");
|
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 | 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_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_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');
|
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');
|
/PHP-7.1/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);
|
H A D | nonblocking.inc | 11 function nb_flush($db, $db_socket) { 16 $flush = pg_flush($db); 25 function nb_consume($db, $db_socket) { 29 } elseif (!pg_consume_input($db)) { 32 } elseif (!pg_connection_busy($db)) {
|
/PHP-7.1/ext/mysqli/tests/ |
H A D | mysqli_change_user_old.phpt | 9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 11 $host, $user, $db, $port, $socket)); 38 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 40 $host, $user, $db, $port, $socket); 57 $host, $user, $db, $port, $socket); 69 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 79 if ($tmp['dbname'] != $db) 93 $host, $user, $db, $port, $socket); 103 $host, $user, $db, $port, $socket); 107 (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-7.1/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_01_open-mb.phpt | 8 $db_file = dirname(__FILE__) . DIRECTORY_SEPARATOR . '私はガラスを食べられます.db'; 9 $db = new SQLite3($db_file); 12 var_dump($db); 13 var_dump($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();
|
/PHP-7.1/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-7.1/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'); 106 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); // Let's use streams [all …]
|