/PHP-5.6/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_driver_name.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $name = $db->getAttribute(PDO::ATTR_DRIVER_NAME); 20 if (false !== $db->setAttribute(PDO::ATTR_DRIVER_NAME, 'mydriver')) 23 $new_name = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
|
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 | 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 …]
|
/PHP-5.6/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-5.6/ext/sqlite3/tests/ |
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_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());
|
/PHP-5.6/ext/sybase_ct/tests/ |
H A D | bug43578.phpt | 14 $db= sybase_connect_ex(); 22 ', $db)); 23 var_dump(sybase_query('insert into #Resource values (123, NULL)', $db)); 24 var_dump(sybase_query('insert into #Resource values (124, "")', $db)); 27 var_dump(sybase_select_ex($db, 'select DC_Rights from #Resource where Resource_ID = 122')); 30 var_dump(sybase_select_ex($db, 'select DC_Rights from #Resource where Resource_ID = 123')); 33 var_dump(sybase_select_ex($db, 'select DC_Rights from #Resource where Resource_ID = 124')); 36 var_dump(sybase_query('drop table #Resource', $db)); 37 sybase_close($db);
|
H A D | test_fetch_object.phpt | 20 // {{{ resource fetch_object(resource db, [mixed arg= NULL]) 22 function fetch_object($db, $arg= NULL) { 28 ', $db), $arg); 32 $db= sybase_connect_ex(); 35 var_export(fetch_object($db)); echo "\n"; 38 var_export(fetch_object($db, 'article')); echo "\n"; 41 var_export(fetch_object($db, new article())); echo "\n"; 44 var_export(fetch_object($db, '***')); echo "\n"; 46 sybase_close($db);
|
/PHP-5.6/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-5.6/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-5.6/ext/pdo_pgsql/tests/ |
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');
|
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();
|