/php-src/ext/pdo/tests/ |
H A D | pdo_002.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test002(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test002 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test002 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test002 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT * from test002'); 31 $db = PDOTest::factory(); 32 PDOTest::dropTableIfExists($db, "test002");
|
H A D | bug_71885.phpt | 19 $db = PDOTest::factory(); 20 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 22 $db->exec("CREATE TABLE test71885 (a int)"); 27 $db->exec($sql); 33 $stmt = $db->prepare($sql); 39 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') { 40 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 44 $stmt = $db->prepare($sql); 54 $db = PDOTest::factory(); 55 PDOTest::dropTableIfExists($db, "test71885");
|
H A D | bug_73234.phpt | 13 $db = PDOTest::factory(); 14 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') { 23 $db = PDOTest::factory(); 24 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 26 switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) { 34 $db->exec($sql); 36 $stmt = $db->prepare('INSERT INTO test73234 VALUES(:value)'); 44 $stmt = $db->query('SELECT * FROM test73234'); 50 $db = PDOTest::factory(); 51 PDOTest::dropTableIfExists($db, "test73234");
|
H A D | pdo_019.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test019(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); 19 $db->exec("INSERT INTO test019 VALUES(0, 'String0')"); 20 $db->exec("INSERT INTO test019 VALUES(1, 'String1')"); 21 $db->exec("INSERT INTO test019 VALUES(2, 'String2')"); 22 $db->exec("INSERT INTO test019 VALUES(3, 'String3')"); 25 var_dump($db->query('SELECT COUNT(*) FROM test019')->fetchColumn()); 27 $stmt = $db->prepare('SELECT idx, txt FROM test019 ORDER by idx'); 47 $db = PDOTest::factory(); 48 PDOTest::dropTableIfExists($db, "test019");
|
H A D | pdo_test.inc | 35 $db = new $classname($dsn, $user, $pass, $attr); 37 if (!$db) { 41 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 43 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 44 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); 45 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 46 return $db; 51 $db = PDOTest::factory(); 78 match ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) { 79 "oci" => $db->exec(<<<SQL [all …]
|
H A D | pdo_009.phpt | 16 $db = PDOTest::factory(); 19 $db->exec("INSERT INTO classtypes009 VALUES(0, 'stdClass')"); 20 $db->exec("INSERT INTO classtypes009 VALUES(1, 'Test1')"); 21 $db->exec("INSERT INTO classtypes009 VALUES(2, 'Test2')"); 23 $db->exec("INSERT INTO test009 VALUES(1, 0, 'A')"); 24 $db->exec("INSERT INTO test009 VALUES(2, 1, 'B')"); 25 $db->exec("INSERT INTO test009 VALUES(3, 2, 'C')"); 26 $db->exec("INSERT INTO test009 VALUES(4, 3, 'D')"); 73 $db = PDOTest::factory(); 74 PDOTest::dropTableIfExists($db, "test009"); [all …]
|
H A D | pdo_010.phpt | 16 $db = PDOTest::factory(); 19 $db->exec("INSERT INTO classtypes010 VALUES(0, 'stdClass')"); 20 $db->exec("INSERT INTO classtypes010 VALUES(1, 'Test1')"); 21 $db->exec("INSERT INTO classtypes010 VALUES(2, 'Test2')"); 23 $db->exec("INSERT INTO test010 VALUES(1, 0, 'A', 'Group1')"); 24 $db->exec("INSERT INTO test010 VALUES(2, 1, 'B', 'Group1')"); 25 $db->exec("INSERT INTO test010 VALUES(3, 2, 'C', 'Group2')"); 26 $db->exec("INSERT INTO test010 VALUES(4, 3, 'D', 'Group2')"); 74 $db = PDOTest::factory(); 75 PDOTest::dropTableIfExists($db, "test010"); [all …]
|
H A D | pdo_001.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test001(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test001 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test001 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test001 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT * from test001'); 31 $db = PDOTest::factory(); 32 PDOTest::dropTableIfExists($db, "test001");
|
H A D | pdo_008.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test008(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test008 VALUES('A', 'A')"); 20 $db->exec("INSERT INTO test008 VALUES('B', 'A')"); 21 $db->exec("INSERT INTO test008 VALUES('C', 'C')"); 23 $stmt = $db->prepare('SELECT val, id from test008'); 32 $db = PDOTest::factory(); 33 PDOTest::dropTableIfExists($db, "test008");
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug72633.phpt | 17 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 19 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 21 $db->query('CREATE TABLE test72633 (id SERIAL NOT NULL, field1 VARCHAR(10))'); 23 $stmt = $db->prepare("INSERT INTO test72633 (field1) VALUES ('test')"); 30 var_dump($db->lastInsertId()); 34 var_dump($db->lastInsertId('test72633_id_seq')); 40 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 41 $db->query('DROP TABLE IF EXISTS test72633');
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdomysql_002.phpt | 15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 16 if (!$db instanceof Pdo\Mysql) { 17 echo "Wrong class type. Should be Pdo\Mysql but is " . get_class($db) . "\n"; 20 $db->exec('CREATE TABLE pdomysql_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))'); 21 $db->exec("INSERT INTO pdomysql_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')"); 23 foreach ($db->query('SELECT name FROM pdomysql_002') as $row) { 32 $db = MySQLPDOTest::factory(); 33 $db->query('DROP TABLE pdomysql_002');
|
H A D | pdo_mysql_stmt_errorcode.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_errorcode_ihopeitdoesnotexist'); 19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 20 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 23 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'… 30 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 35 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 36 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 39 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'… 45 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdo_mysql___construct.phpt | 23 (isset($db) && is_object($db)) ? $db->errorCode() : 'n/a', 24 (isset($db) && is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a'); 32 if (NULL !== ($db = @new PDO())) 37 print tryandcatch(2, '$db = new PDO(chr(0));'); 62 $db = new PDO($dsn, $user, $pass); 145 $db = PDO_MYSQL_TEST_DB; 182 $db = new PDO($dsn, $user, $pass); 203 $db = new PDO($dsn, $user, $pass); 242 $db = new PDO($dsn, $user, $pass); 282 (is_object($db)) ? $db->errorCode() : 'n/a', [all …]
|
H A D | bug70272.phpt | 18 $db = MySQLPDOTest::factory(); 21 $a->c = $db; 22 $a->b = $db->prepare("select 1"); 23 $a->d = $db->prepare("select 2"); 24 $a->e = $db->prepare("select 3"); 25 $a->f = $db->prepare("select 4");
|
H A D | pdo_mysql_stmt_bindparam.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 17 MySQLPDOTest::createTestTable($table, $db); 19 function pdo_mysql_stmt_bindparam($db, $offset) { 93 pdo_mysql_stmt_bindparam($db, 3); 96 MySQLPDOTest::createTestTable($table, $db); 98 pdo_mysql_stmt_bindparam($db, 4); 108 pdo_mysql_stmt_bindparam($db, 5); 113 pdo_mysql_stmt_bindparam($db, 6); 117 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_prepare_native.phpt | 13 $db = MySQLPDOTest::factory(); 18 $stmt = @$db->prepare($query); 20 $stmt = $db->prepare($query); 23 $tmp = $db->errorInfo(); 86 $db->errorCode(), implode(' ', $db->errorInfo())); 94 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 105 $stmt = prepex(4, $db, 'SELECT 1 as "one"'); 123 prepex(9, $db, 'DELETE FROM test_prepare_native'); 156 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 164 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_native_myisam.phpt | 13 $db = MySQLPDOTest::factory(); 18 $stmt = @$db->prepare($query); 20 $stmt = $db->prepare($query); 23 $tmp = $db->errorInfo(); 86 $db->errorCode(), implode(' ', $db->errorInfo())); 94 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 130 $db->exec('DELETE FROM test_prepare_native_myisam'); 134 $db->quote('%ro%')); 140 $db->quote('%go%')); 146 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_attr_init_command.phpt | 21 $db = new PDO($dsn, $user, $pass); 25 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create)); 26 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 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)); 40 $db = MySQLPDOTest::factory(); 41 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_init_command');
|
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 13 $db = MySQLPDOTest::factory(); 16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 17 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 30 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous'); 36 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 37 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 40 $db->exec('DELETE FROM test_prepare_emulated_anonymous'); 49 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous'); 55 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 63 $db = MySQLPDOTest::factory(); [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | 04async_query.phpt | 13 $db = pg_connect($conn_str); 14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 15 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES"); 17 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) { 20 while(pg_connection_busy($db)); // busy wait: intended 21 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 24 if (!($result = pg_get_result($db))) 49 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 50 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); 74 $db = pg_connect($conn_str); [all …]
|
/php-src/ext/dba/tests/ |
H A D | dba009.phpt | 16 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) { 18 dba_insert("a", "Inserted", $db); 19 echo dba_fetch("a", $db)."\n"; 20 dba_close($db); 25 if (($db=dba_popen($db_file, "n", $handler))!==FALSE) { 27 dba_insert("a", "Inserted", $db); 28 echo dba_fetch("a", $db)."\n";
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_createcollation.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)'); 13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10… 15 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); 17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL… 22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
|
H A D | pdo_sqlite_extendederror_attr.phpt | 9 $db = new PDO('sqlite::memory:'); 10 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 15 $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 16 $errorInfo = $db->errorInfo(); 20 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 21 $errorInfo = $db->errorInfo(); 27 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 32 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 33 $errorInfo = $db->errorInfo(); 37 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); [all …]
|
H A D | bug38334.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->exec('CREATE TABLE test_38334 (i INTEGER , f DOUBLE, s VARCHAR(255))'); 10 $db->exec('INSERT INTO test_38334 VALUES (42, 46.7, "test")'); 11 var_dump($db->query('SELECT * FROM test_38334')->fetch(PDO::FETCH_ASSOC)); 14 $db->exec('INSERT INTO test_38334 VALUES (10000000000, 0.0, "")'); 15 $i = $db->query('SELECT i FROM test_38334 WHERE f = 0.0')->fetchColumn(0); 23 $db->exec('INSERT INTO test_38334 VALUES ("test", "test", "x")'); 24 var_dump($db->query('SELECT * FROM test_38334 WHERE s = "x"')->fetch(PDO::FETCH_ASSOC));
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_33_reset.phpt | 11 $db = new SQLite3(':memory:'); 13 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); 14 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 20 //var_dump($db); 21 //var_dump($db->close());
|