/PHP-7.0/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_createfunction.phpt | 8 $db = new pdo('sqlite::memory:'); 10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)'); 12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")'); 16 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }); 19 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) { 23 $db->query('DROP TABLE foobar');
|
/PHP-7.0/ext/sqlite3/tests/ |
H A D | bug73068.phpt | 8 $db = new \SQLite3(':memory:') ; 10 $db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)"); 11 $db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')"); 13 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'"); 16 $db->exec("DELETE FROM t1 WHERE a='1' AND b='2'"); 18 $r = $db->query("SELECT * FROM t1;"); 21 $db->close();
|
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_25_create_aggregate.phpt | 25 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)')); 28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)")); 29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)")); 30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)")); 31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)")); 32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)")); 34 $db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1); 36 print_r($db->querySingle("SELECT S(a), S(b) FROM test", true)); 39 var_dump($db->close());
|
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());
|
/PHP-7.0/ext/dba/tests/ |
H A D | dba009.phpt | 12 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) { 14 dba_insert("a", "Inserted", $db); 15 echo dba_fetch("a", $db)."\n"; 16 dba_close($db); 21 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) { 23 dba_insert("a", "Inserted", $db); 24 echo dba_fetch("a", $db)."\n";
|
/PHP-7.0/ext/pdo_mysql/tests/ |
H A D | bug53551.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 21 $db->exec('drop table if exists bug53551'); 22 $db->exec($createSql); 23 $db->exec("insert into bug53551 set `count` = 1 "); 24 $db->exec("SET sql_mode = 'Traditional'"); 26 $stmt = $db->prepare($sql); 46 $db = MySQLPDOTest::factory(); 47 $db->exec('DROP TABLE IF EXISTS bug53551');
|
H A D | bug_44707.phpt | 11 $db = MySQLPDOTest::factory(); 12 $stmt = $db->query('SELECT VERSION() as _version'); 29 function bug_44707($db) { 31 $db->exec('DROP TABLE IF EXISTS test'); 32 $db->exec('CREATE TABLE test(id INT, mybool TINYINT)'); 48 $stmt = $db->query('SELECT * FROM test'); 57 $stmt = $db->query('SELECT * FROM test'); 66 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 67 bug_44707($db); 71 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); [all …]
|
H A D | pdo_mysql_stmt_closecursor.phpt | 8 $db = MySQLPDOTest::factory(); 14 $db = MySQLPDOTest::factory(); 117 MySQLPDOTest::createTestTable($db); 118 pdo_mysql_stmt_closecursor($db); 122 MySQLPDOTest::createTestTable($db); 123 pdo_mysql_stmt_closecursor($db); 131 MySQLPDOTest::createTestTable($db); 133 pdo_mysql_stmt_closecursor($db); 138 pdo_mysql_stmt_closecursor($db); 142 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_prepare_native_named_placeholder.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 17 $db->exec('DROP TABLE IF EXISTS test'); 20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 21 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 38 $stmt = $db->prepare('SELECT id, label FROM test'); 43 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 44 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 64 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 72 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 17 $db->exec('DROP TABLE IF EXISTS test'); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 26 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')"); 44 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 45 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 66 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 74 $db = MySQLPDOTest::factory(); [all …]
|
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 | bug70862.phpt | 12 $db = MySQLPDOTest::factory(); 14 $db->exec('DROP TABLE IF EXISTS test'); 15 $db->exec(sprintf('CREATE TABLE test(id INT, label BLOB)')); 17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 18 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 30 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, :para)'); 41 $db = MySQLPDOTest::factory(); 42 $db->exec('DROP TABLE IF EXISTS test');
|
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 | bug70272.phpt | 19 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 22 $a->c = $db; 23 $a->b = $db->prepare("select 1"); 24 $a->d = $db->prepare("select 2"); 25 $a->e = $db->prepare("select 3"); 26 $a->f = $db->prepare("select 4");
|
/PHP-7.0/ext/pgsql/tests/ |
H A D | 24sync_query_prepared.phpt | 13 $db = pg_connect($conn_str); 15 $version = pg_version($db); 17 $result = pg_prepare($db, "php_test", "SELECT * FROM ".$table_name." WHERE num > \$1;"); 20 $result = pg_execute($db, "php_test", array(100)); 43 pg_num_rows(pg_execute($db, "php_test", array(100))); 44 pg_num_fields(pg_execute($db, "php_test", array(100))); 52 $result = pg_prepare($db, "php_test2", "INSERT INTO ".$table_name." VALUES (\$1, \$2);"); 55 $result = pg_execute($db, "php_test2", array(9999, "A'BC")); 60 pg_close($db);
|
H A D | 27large_object_oid.phpt | 15 $db = pg_connect($conn_str); 18 pg_exec ($db, "begin"); 19 $oid = pg_lo_create ($db, 21000); 22 pg_lo_unlink ($db, $oid); 23 pg_exec ($db, "commit"); 26 pg_exec ($db, "begin"); 27 $oid = pg_lo_create ($db, "21001"); 30 pg_lo_unlink ($db, $oid); 31 pg_exec ($db, "commit");
|
H A D | 9999dropdb.phpt | 2 PostgreSQL drop db 11 $db = pg_connect($conn_str); 12 pg_query($db, "DROP VIEW {$view_name}"); 13 pg_query($db, "DROP TABLE ".$table_name); 14 @pg_query($db, "DROP TABLE ".$table_name_92);
|
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-7.0/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");
|
/PHP-7.0/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 365 THIS_INCLUDE=$i/include/db.h 369 …PHP_DBA_DB_CHECK(4, db-5.3 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 d… 402 …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,… 415 THIS_INCLUDE=$i/db2/db.h 435 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)]) 457 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do 468 THIS_INCLUDE=$i/db1/db.h [all …]
|
/PHP-7.0/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();
|
H A D | bug72633.phpt | 15 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 19 $db->query('CREATE TABLE test_last_id (id SERIAL NOT NULL, field1 VARCHAR(10))'); 21 $stmt = $db->prepare("INSERT INTO test_last_id (field1) VALUES ('test')"); 28 var_dump($db->lastInsertId()); 32 var_dump($db->lastInsertId('test_last_id_id_seq')); 34 $db->query('DROP TABLE test_last_id');
|