/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_32_changes.phpt | 10 $db = new SQLite3(':memory:'); 11 //$db = new SQLite3('mysqlitedb.db'); 12 $db->exec('CREATE TABLE pageView(id INTEGER PRIMARY KEY, page CHAR(256), access INTEGER(10))'); 13 $db->exec('INSERT INTO pageView (page, access) VALUES (\'test\', \'000000\')'); 14 echo $db->changes("dummy");
|
H A D | sqlite3_29_createfunction.phpt | 11 var_dump($db->createfunction($func, $func)); 12 var_dump($db->querySingle('SELECT strtoupper("test")')); 15 var_dump($db->createfunction($func2, $func2)); 16 var_dump($db->querySingle('SELECT strtolower("TEST")')); 18 var_dump($db->createfunction($func, $func2)); 19 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
|
H A D | sqlite3_enable_exceptions.phpt | 11 $db = new SQLite3(':memory:'); 12 var_dump($db->enableExceptions(true)); 14 $db->query("SELECT * FROM non_existent_table"); 18 var_dump($db->enableExceptions(false)); 19 $db->query("SELECT * FROM non_existent_table"); 20 var_dump($db->enableExceptions("wrong_type","wrong_type")); 22 var_dump($db->close());
|
H A D | sqlite3_31_open.phpt | 12 $db = new SQLite3(__DIR__ . '/db1.db'); 13 $db->open(__DIR__ . '/db1.db'); 20 <?php @unlink(__DIR__ . '/db1.db'); ?>
|
/PHP-5.5/ext/pdo/tests/ |
H A D | bug_34630.phpt | 15 $db = PDOTest::factory(); 17 $driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME); 21 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val BLOB)'); 23 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val VARCHAR(256))'); 25 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 35 $db->beginTransaction(); 36 …$insert = $db->prepare("insert into test (id, val) values (1, EMPTY_BLOB()) RETURNING val INTO :bl… 38 $insert = $db->prepare("insert into test (id, val) values (1, :blob)"); 44 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 45 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_033.phpt | 15 $db = PDOTest::factory(); 19 $quoted = $db->quote($unquoted); 23 @$db->exec("DROP TABLE test"); 25 $db->query("CREATE TABLE test (t char($len))"); 26 $db->query("INSERT INTO test (t) VALUES($quoted)"); 28 $stmt = $db->prepare('SELECT * from test'); 33 $db->exec("DROP TABLE test");
|
H A D | pdo_032.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')"); 23 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); 24 $stmt = $db->prepare('SELECT * from test'); 30 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER); 31 $stmt = $db->prepare('SELECT * from test');
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pecl_bug_5780.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt'); 15 $db->exec("CREATE TABLE test (login varchar(32) NOT NULL, data varchar(64) NOT NULL)"); 16 $db->exec("CREATE TABLE test2 (login varchar(32) NOT NULL, password varchar(64) NOT NULL)"); 17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')"); 18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')"); 20 $logstmt = $db->prepare('INSERT INTO test (login, data) VALUES (:var1, :var2)'); 21 $authstmt = $db->prepare('SELECT * FROM test2 WHERE login = :varlog AND password = :varpass'); 32 $db = MySQLPDOTest::factory(); 33 $db->exec('DROP TABLE IF EXISTS test'); 34 $db->exec('DROP TABLE IF EXISTS test2');
|
H A D | mysql_pdo_test.inc | 24 $db = new $classname($dsn, $user, $pass, $attr); 25 if (!$db) { 32 return $db; 39 $db->exec('DROP TABLE IF EXISTS test'); 82 static function getClientVersion($db) { 86 static function getServerVersion($db) { 151 foreach ($db->query("SHOW ENGINES") as $row) { 169 static function dropTestTable($db = NULL) { 170 if (is_null($db)) 171 $db = self::factory(); [all …]
|
H A D | pdo_mysql_stmt_bindparam.phpt | 12 $db = MySQLPDOTest::factory(); 15 MySQLPDOTest::createTestTable($db); 17 function pdo_mysql_stmt_bindparam($db, $offset) { 90 pdo_mysql_stmt_bindparam($db, 3); 93 MySQLPDOTest::createTestTable($db); 95 pdo_mysql_stmt_bindparam($db, 4); 103 MySQLPDOTest::createTestTable($db); 105 pdo_mysql_stmt_bindparam($db, 5); 108 MySQLPDOTest::createTestTable($db); 110 pdo_mysql_stmt_bindparam($db, 6); [all …]
|
H A D | pdo_mysql_stmt_blobs.phpt | 12 $db = MySQLPDOTest::factory(); 25 function test_blob($db, $offset, $sql_type, $test_len) { 27 $db->exec('DROP TABLE IF EXISTS test'); 40 $stmt = $db->query('SELECT id, label FROM test'); 63 $stmt = $db->query('SELECT id, label FROM test'); 83 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 84 test_blob($db, ++$offset, $sql_type, $test_len); 85 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 86 test_blob($db, ++$offset, $sql_type, $test_len); 94 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 13 $db = MySQLPDOTest::factory(); 17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 18 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 21 $db->exec('DROP TABLE IF EXISTS test'); 27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 42 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 60 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_attr_init_command.phpt | 8 $db = MySQLPDOTest::factory(); 21 $db = new PDO($dsn, $user, $pass); 22 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table)); 26 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create)); 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)); 35 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 16 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)) 20 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)); 26 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 30 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0); 34 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 35 $stmt = $db->query('SELECT VERSION() as _version'); 42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 48 $stmt = $db->prepare('CALL p()'); [all …]
|
H A D | bug44327.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $stmt = $db->prepare("SELECT 1 AS \"one\""); 25 @$db->exec("DROP TABLE test"); 26 $db->exec("CREATE TABLE test (id INT)"); 27 $db->exec("INSERT INTO test(id) VALUES (1)"); 28 $stmt = $db->prepare("SELECT id FROM test"); 33 @$db->exec("DROP TABLE test"); 37 $stmt = $db->prepare('foo');
|
H A D | pdo_mysql_stmt_blobfromsteam.phpt | 55 $db->exec('DROP TABLE IF EXISTS test'); 57 $db->exec($sql); 77 var_export($db->errorInfo(), true)); 97 $db->exec('DELETE FROM test'); 116 $db = MySQLPDOTest::factory(); 124 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 125 blob_from_stream(10, $db, $file, $blob); 129 blob_from_stream(30, $db, $file, $blob); 133 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 141 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_attr_server_info.phpt | 8 $db = MySQLPDOTest::factory(); 13 $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 D | pdo_mysql_stmt_fetch_non_select.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (!is_object($stmt = $db->query('SHOW ENGINES'))) 75 $db->exec('DEALLOCATE PREPARE mystmt'); 81 var_export($db->errorInfo(), true)); 109 $db->exec('DEALLOCATE PREPARE mystmt'); 115 var_export($db->errorInfo(), true)); 142 $db->exec('DEALLOCATE PREPARE mystmt'); 148 var_export($db->errorInfo(), true)); [all …]
|
H A D | table.inc | 2 if (!$db) { 4 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 6 // $db->exec('DROP TABLE IF EXISTS test'); 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
/PHP-5.5/ext/pgsql/tests/ |
H A D | 04async_query.phpt | 10 $db = pg_connect($conn_str); 12 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) { 15 while(pg_connection_busy($db)); // busy wait: intended 16 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 19 if (!($result = pg_get_result($db))) 44 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 45 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); 53 if (!pg_send_query($db, "INSERT INTO ".$table_name." VALUES (8888, 'GGG');"))
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | bug_49985.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->exec("CREATE TABLE test (a int PRIMARY KEY)"); 20 $db->beginTransaction(); 21 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)"); 23 $db->commit(); 26 $db->rollback();
|
/PHP-5.5/ext/dba/ |
H A D | config.m4 | 315 if test -f "$i/db5/db.h"; then 317 THIS_INCLUDE=$i/db5/db.h 321 THIS_INCLUDE=$i/db4/db.h 361 THIS_INCLUDE=$i/include/db.h 365 …PHP_DBA_DB_CHECK(4, db-5.1 db-5.0 db-4.8 db-4.7 db-4.6 db-4.5 db-4.4 db-4.3 db-4.2 db-4.1 db-4.0 d… 398 …PHP_DBA_DB_CHECK(3, db-3.3 db-3.2 db-3.1 db-3.0 db-3 db3 db, [(void)db_create((DB**)0, (DB_ENV*)0,… 411 THIS_INCLUDE=$i/db2/db.h 431 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)]) 453 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do 464 THIS_INCLUDE=$i/db1/db.h [all …]
|
/PHP-5.5/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $db->exec("DROP TABLE test_one_blob"); 23 $db->beginTransaction(); 25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)'); 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 49 $res = $db->query("SELECT blob1 from test_one_blob"); 56 $db->exec("DROP TABLE test_one_blob");
|
/PHP-5.5/ext/pdo_sqlite/tests/ |
H A D | pdo_fetch_func_001.phpt | 10 $db = new PDO('sqlite::memory:'); 15 $st = $db->query('SELECT * FROM testing'); 18 $st = $db->query('SELECT name FROM testing'); 21 $st = $db->query('SELECT * FROM testing'); 24 $st = $db->query('SELECT * FROM testing'); 27 $st = $db->query('SELECT * FROM testing'); 30 $st = $db->query('SELECT * FROM testing'); 33 $st = $db->query('SELECT * FROM testing'); 42 public function __construct($db) { 60 new bar($db); [all …]
|
/PHP-5.5/ext/spl/examples/ |
H A D | dba_dump.php | 32 $db = new DbaReader($argv[1], $argv[2]); variable 35 $db = new KeyFilter($db, $argv[3]); variable 38 foreach($db as $key => $val) {
|