/php-src/ext/pdo_mysql/tests/ |
H A D | bug_pecl_7976.phpt | 13 $db = MySQLPDOTest::factory(); 15 function bug_pecl_7976($db) { 20 $stmt = $db->query("CALL {$procedure}()"); 24 $stmt = $db->query("CALL {$procedure}()"); 30 $db = MySQLPDOTest::factory(); 31 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 32 bug_pecl_7976($db); 35 $db = MySQLPDOTest::factory(); 36 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 37 bug_pecl_7976($db); [all …]
|
H A D | bug80908.phpt | 15 $db = MySQLPDOTest::factory(); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 18 return $db; 21 $db = createDB(); 24 function testLastInsertId(PDO $db) { 29 $id = $db->lastInsertId(); 36 testLastInsertId($db); 37 unset($db); 43 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_exec.phpt | 14 $ret = $db->exec($sql); 18 $db->errorCode(), implode(' ', $db->errorInfo())); 23 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 31 $db = MySQLPDOTest::factory(); 52 printf("[016] [%s] %s\n", $db->errorCode(), implode(' ', $db->errorInfo())); 62 $db->errorCode(), implode(' ', $db->errorInfo())); 104 $db->errorCode(), implode(' ', $db->errorInfo())); 142 $db->errorCode(), implode(' ', $db->errorInfo())); 156 $db->errorCode(), var_export($db->errorInfo(), true)); 164 $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_commit.phpt | 13 $db = MySQLPDOTest::factory(); 16 … MySQLPDOTest::createTestTable($table, $db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 25 …$db->exec(sprintf('CREATE TABLE %s (id INT) ENGINE=%s', $table2, MySQLPDOTest::detect_transactiona… 27 $db->commit(); 47 if (true !== ($tmp = $db->commit())) 49 $db->errorCode(), implode(' ', $db->errorInfo())); 61 $db = MySQLPDOTest::factory(); 68 if (true !== ($tmp = $db->commit())) 70 $db->errorCode(), implode(' ', $db->errorInfo())); 83 $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_attr_case.phpt | 13 $db = MySQLPDOTest::factory(); 34 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 40 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 48 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 52 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 56 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 62 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 70 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 76 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 84 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); [all …]
|
H A D | pdo_mysql_attr_autocommit.phpt | 13 $db = MySQLPDOTest::factory(); 25 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0)) 33 if (!$db->query('SET autocommit = 1')) 40 if (!$db->query('SET autocommit = 0')) 43 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1)) 57 … MySQLPDOTest::createTestTable($table, $db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 68 $db->query('ROLLBACK'); 73 if (!$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0)) 77 $db->query('ROLLBACK'); 83 $db->query('COMMIT'); [all …]
|
H A D | pdo_mysql_types_zerofill.phpt | 16 $db->exec('DROP TABLE IF EXISTS test_mysql_types_zerofill'); 18 $db->exec($sql); 19 if ($db->errorCode() != 0) { 38 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 78 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 90 $db = MySQLPDOTest::factory(); 92 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 93 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 95 $stmt = $db->prepare('SELECT @@sql_mode AS _mode'); 125 $db = MySQLPDOTest::factory(); [all …]
|
H A D | bug_44454.phpt | 13 $db = MySQLPDOTest::factory(); 15 function bug_44454($db) { 17 $db->exec('DROP TABLE IF EXISTS test_44454'); 33 $db->exec('DROP TABLE IF EXISTS test_44454'); 41 $stmt = $db->query('SELECT a, b FROM test_44454'); 57 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 58 bug_44454($db); 61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 62 bug_44454($db); 69 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_columncount.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table, $db); 23 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 24 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 31 $stmt = $db->query("SELECT * FROM {$table}"); 36 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 41 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 49 $stmt = $db->query("SELECT * FROM {$table}"); 54 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 62 $db = MySQLPDOTest::factory(); [all …]
|
/php-src/ext/dba/tests/ |
H A D | dba_array_keys_inifile.phpt | 13 $name = __DIR__ . '/array_keys_basic.db'; 15 $db = dba_open($name, 'c', 'inifile'); 18 var_dump(dba_insert(['group', ''], 'Empty name', $db)); 19 var_dump(dba_insert(['', 'name'], 'Empty group', $db)); 20 var_dump(dba_insert(['', ''], 'Empty keys', $db)); 21 var_dump(dba_fetch(['group', 'name'], $db)); 22 var_dump(dba_fetch(['group', ''], $db)); 23 var_dump(dba_fetch(['', 'name'], $db)); 24 var_dump(dba_fetch(['', ''], $db)); 25 dba_close($db); [all …]
|
H A D | dba_array_keys.phpt | 13 $name = 'array_keys_basic.db'; 15 $db = get_any_db($name); 18 var_dump(dba_insert(['group', ''], 'Empty name', $db)); 19 var_dump(dba_insert(['', 'name'], 'Empty group', $db)); 20 var_dump(dba_insert(['', ''], 'Empty keys', $db)); 21 var_dump(dba_fetch(['group', 'name'], $db)); 22 var_dump(dba_fetch(['group', ''], $db)); 23 var_dump(dba_fetch(['', 'name'], $db)); 24 var_dump(dba_fetch(['', ''], $db)); 25 dba_close($db); [all …]
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | gh9411.phpt | 15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 19 $db->beginTransaction(); 20 $oid = $db->pgsqlLOBCreate(); 21 var_dump($lob = $db->pgsqlLOBOpen($oid, 'wb')); 23 $db->rollback(); 26 $db->beginTransaction(); 27 $oid = $db->pgsqlLOBCreate(); 28 var_dump($lob = $db->pgsqlLOBOpen($oid, 'wb')); 30 $db->commit(); 33 $db->beginTransaction(); [all …]
|
H A D | bug68199.phpt | 12 $db = PDOTest::factory(); 25 $pid = $db->pgsqlGetPid(); 29 var_dump($db->pgsqlGetNotify()); 32 $db->exec("LISTEN channel_bug68199"); 33 var_dump($db->pgsqlGetNotify()); 37 $db->exec("NOTIFY channel_bug68199, 'payload'"); 38 $notify = $db->pgsqlGetNotify(); 46 $db->exec("NOTIFY channel_bug68199, 'payload'"); 47 $notify = $db->pgsqlGetNotify(); 55 $notify = $db->pgsqlGetNotify(PDO::FETCH_NUM); [all …]
|
H A D | getnotify.phpt | 19 $pid = $db->pgsqlGetPid(); 23 var_dump($db->pgsqlGetNotify()); 26 $db->exec("LISTEN channel_getnotify"); 27 var_dump($db->pgsqlGetNotify()); 31 $db->exec("NOTIFY channel_getnotify"); 32 $notify = $db->pgsqlGetNotify(); 39 $db->exec("NOTIFY channel_getnotify"); 40 $notify = $db->pgsqlGetNotify(); 46 $db->exec("NOTIFY channel_getnotify"); 53 $db->exec("NOTIFY channel_getnotify"); [all …]
|
H A D | is_in_transaction.phpt | 15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 21 $db->beginTransaction(); 24 var_dump($db->inTransaction()); 31 $db->commit(); 34 var_dump($db->inTransaction()); 36 $db->beginTransaction(); 46 var_dump($db->inTransaction()); 47 $db->rollBack(); 51 var_dump($db->inTransaction()); [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | gh13354.phpt | 11 $db = pg_connect($conn_str); 18 pg_prepare($db, 'test', $query); 44 pg_consume_input($db); 45 $res = pg_get_result($db); 50 pg_consume_input($db); 51 $res = pg_get_result($db); 58 pg_consume_input($db); 59 $res = pg_get_result($db); 64 pg_consume_input($db); 65 $res = pg_get_result($db); [all …]
|
H A D | 9999dropdb.phpt | 2 PostgreSQL drop db 16 $db = pg_connect($conn_str); 17 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 19 pg_query($db, "CREATE VIEW {$view_name} as SELECT * FROM {$table_name}"); 21 pg_query($db, "DROP VIEW {$view_name}"); 22 pg_query($db, "DROP TABLE {$table_name}"); 23 pg_query($db, "DROP TABLE {$table_name_92}"); 35 $db = pg_connect($conn_str); 36 pg_query($db, "DROP VIEW IF EXISTS {$view_name}"); 37 pg_query($db, "DROP TABLE IF EXISTS {$table_name}"); [all …]
|
H A D | 32nb_async_query.phpt | 16 $db = pg_connect($conn_str); 20 $db_socket = pg_socket($db); 27 nb_flush($db, $db_socket); 30 nb_consume($db, $db_socket); 32 if (!($result = pg_get_result($db))) { 65 nb_flush($db, $db_socket); 68 nb_consume($db, $db_socket); 70 if (!($result = pg_get_result($db))) { 76 pg_close($db); 85 $db = pg_connect($conn_str); [all …]
|
H A D | 06copy_2.phpt | 13 $db = pg_connect($conn_str); 15 pg_query($db, "CREATE TABLE {$table_name} (x int)"); 17 pg_query($db, "COPY {$table_name} FROM STDIN"); 19 pg_put_line($db, "1\n"); 20 pg_put_line($db, "\\N\n"); 21 pg_put_line($db, "\\.\n"); 22 pg_end_copy($db); 24 var_dump(pg_fetch_all_columns(pg_query($db, "SELECT * FROM {$table_name} ORDER BY 1"))); 31 $db = pg_connect($conn_str); 32 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 05large_object.phpt | 12 $db = pg_connect($conn_str); 15 pg_exec ($db, "BEGIN"); 16 $oid = pg_lo_create ($db); 22 pg_exec ($db, "COMMIT"); 25 pg_exec ($db, "BEGIN"); 37 pg_exec ($db, "COMMIT"); 40 pg_exec ($db, "BEGIN"); 51 pg_exec ($db, "BEGIN"); 57 pg_exec ($db, "BEGIN"); 63 pg_exec ($db, "BEGIN"); [all …]
|
H A D | 01createdb.phpt | 2 PostgreSQL create db 16 $db = pg_connect($conn_str); 17 if (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q)) 19 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); // Create table here 25 $v = pg_version($db); 28 pg_query($db, "CREATE TABLE {$table_name_92} (textary text[], jsn json)"); // Create table here 35 pg_query($db, "CREATE VIEW {$view_name} AS SELECT * FROM {$table_name}"); 37 pg_close($db); 47 $db = pg_connect($conn_str); 48 pg_query($db, "DROP TABLE IF EXISTS {$table_name} cascade"); [all …]
|
/php-src/ext/pdo/tests/ |
H A D | bug_64172.phpt | 17 $db = PDOTest::factory(); 19 $db->exec("CREATE TABLE test64172 (x int)"); 20 $db->exec("INSERT INTO test64172 VALUES (1)"); 23 $db->query('SELECT * FROM bad_table'); 27 var_dump(is_int($db->errorInfo()[1])) . "\n"; 30 $stmt = $db->query('SELECT * FROM test64172'); 33 var_dump($db->errorInfo()); 36 $db->exec("INSERT INTO bad_table VALUES(1)"); 40 var_dump(is_int($db->errorInfo()[1])) . "\n"; 44 var_dump($db->errorInfo()); [all …]
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_transaction.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 11 $db->beginTransaction(); 13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)'); 14 $db->commit(); 16 $db->beginTransaction(); 17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")'); 18 $db->rollback(); 20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction'); 23 $db->query('DROP TABLE test_pdo_sqlite_transaction');
|
H A D | bug81227.phpt | 7 $db = new PDO("sqlite::memory:"); 8 var_dump($db->inTransaction()); 10 $db->exec("BEGIN EXCLUSIVE TRANSACTION"); 11 var_dump($db->inTransaction()); 14 $db->beginTransaction(); 19 $db->commit(); 20 var_dump($db->inTransaction()); 22 $db->beginTransaction(); 23 var_dump($db->inTransaction());
|
/php-src/ext/mysqli/tests/ |
H A D | bug66043.phpt | 12 if (!$db = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 16 if (!$db->query("DROP TABLE IF EXISTS test")) { 17 printf("[002] [%d] %s\n", mysqli_errno($db), mysqli_error($db)); 21 if (!$db->query("CREATE TABLE test(str TEXT)")) { 22 printf("[003] [%d] %s\n", mysqli_errno($db), mysqli_error($db)); 26 if (!$db->query("INSERT INTO test(str) VALUES ('Test')")) { 31 $stmt = $db->stmt_init(); 33 printf("[004] [%d] %s\n", mysqli_errno($db), mysqli_error($db));
|