/PHP-7.4/ext/pdo/tests/ |
H A D | bug_64172.phpt | 16 $db = PDOTest::factory(); 18 @$db->exec("DROP TABLE test"); 19 $db->exec("CREATE TABLE test (x int)"); 20 $db->exec("INSERT INTO test VALUES (1)"); 23 $db->query('SELECT * FROM bad_table'); 27 var_dump(is_int($db->errorInfo()[1])) . "\n"; 30 $stmt = $db->query('SELECT * FROM test'); 33 var_dump($db->errorInfo()); 43 $db->exec("INSERT INTO test VALUES (2)"); 44 var_dump($db->errorInfo()); [all …]
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_exec.phpt | 15 $ret = $db->exec($sql); 19 $db->errorCode(), implode(' ', $db->errorInfo())); 25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 33 $db = MySQLPDOTest::factory(); 34 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 54 printf("[016] [%s] %s\n", $db->errorCode(), implode(' ', $db->errorInfo())); 65 $db->errorCode(), implode(' ', $db->errorInfo())); 107 $db->errorCode(), implode(' ', $db->errorInfo())); 144 $db->errorCode(), implode(' ', $db->errorInfo())); 159 $db->errorCode(), var_export($db->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_attr_autocommit.phpt | 8 $db = MySQLPDOTest::factory(); 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)) 56 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 67 $db->query('ROLLBACK'); 75 $db->query('DELETE FROM test WHERE id = 100'); 76 $db->query('ROLLBACK'); [all …]
|
H A D | pdo_mysql_attr_case.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 31 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 37 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 45 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 49 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 53 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 59 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 67 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 73 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); [all …]
|
H A D | pdo_mysql_get_attribute.phpt | 8 $db = MySQLPDOTest::factory(); 15 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 18 function set_and_get($offset, $db, $attribute, $value) { 23 if (!$db->setAttribute($attribute, $value)) { 35 $tmp = $db->getAttribute($attribute); 45 $db->errorCode(), implode(' ', $db->errorInfo())); 52 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, 1); 54 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0); 55 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1); [all …]
|
H A D | pdo_mysql_types_zerofill.phpt | 15 $db->exec('DROP TABLE IF EXISTS test'); 17 @$db->exec($sql); 18 if ($db->errorCode() != 0) { 37 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 38 $stmt = $db->query('SELECT id, label FROM test'); 78 $stmt = $db->query('SELECT id, label FROM test'); 89 $db = MySQLPDOTest::factory(); 91 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 94 $stmt = $db->prepare('SELECT @@sql_mode AS _mode'); 124 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_emulated.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 22 $stmt = $db->prepare($query); 25 $tmp = $db->errorInfo(); 79 $db->errorCode(), implode(' ', $db->errorInfo())); 92 prepex(3, $db, '', 183 $db->quote('%ro%')); 190 $db->quote('%ro%')); 292 $db->quote('%ro%')); 299 $db->quote('%ro%')); [all …]
|
H A D | bug_pecl_7976.phpt | 9 $db = MySQLPDOTest::factory(); 24 $db = MySQLPDOTest::factory(); 26 function bug_pecl_7976($db) { 28 $db->exec('DROP PROCEDURE IF EXISTS p'); 31 $stmt = $db->query('CALL p()'); 35 $stmt = $db->query('CALL p()'); 42 $db = MySQLPDOTest::factory(); 44 bug_pecl_7976($db); 47 $db = MySQLPDOTest::factory(); 49 bug_pecl_7976($db); [all …]
|
H A D | pdo_mysql_quote.phpt | 12 $db = MySQLPDOTest::factory(); 14 var_dump($db->quote('foo', PDO::PARAM_STR)); 15 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); 16 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL)); 18 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_CHAR); 19 $db->setAttribute(PDO::ATTR_DEFAULT_STR_PARAM, PDO::PARAM_STR_NATL); 20 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_NATL); 22 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); 23 var_dump($db->quote('über', PDO::PARAM_STR)); 24 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
|
H A D | pdo_mysql_exec_load_data.phpt | 10 $db = MySQLPDOTest::factory(); 11 $stmt = $db->query('SELECT USER() as _user'); 37 $ret = $db->exec($sql); 41 $db->errorCode(), implode(' ', $db->errorInfo())); 47 if (42000 == $db->errorCode()) { 54 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 63 $db = MySQLPDOTest::factory(); 64 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 108 $db->errorCode(), implode(' ', $db->errorInfo())); 116 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_columncount.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 29 $stmt = $db->query('SELECT * FROM test'); 34 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 39 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 40 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 47 $stmt = $db->query('SELECT * FROM test'); [all …]
|
H A D | bug_44454.phpt | 16 function bug_44454($db) { 20 $db->exec('DROP TABLE IF EXISTS test'); 22 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 24 $stmt = $db->query('SELECT a, b FROM test'); 36 $db->exec('DROP TABLE IF EXISTS test'); 44 $stmt = $db->query('SELECT a, b FROM test'); 61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 62 bug_44454($db); 66 bug_44454($db); 73 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 27 MySQLPDOTest::createTestTable($db); 29 $db->exec('DROP TABLE test'); 32 var_dump($db->errorInfo()); 36 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); 48 MySQLPDOTest::createTestTable($db); 51 $db->exec('DROP TABLE test'); 54 var_dump($db->errorInfo()); [all …]
|
H A D | pdo_mysql_prepare_native.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 22 $stmt = $db->prepare($query); 25 $tmp = $db->errorInfo(); 90 $db->errorCode(), implode(' ', $db->errorInfo())); 103 prepex(3, $db, '', 190 $db->quote('%ro%')); 196 $db->quote('%go%')); 315 $db->quote('%ro%')); 321 $db->quote('%ro%')); [all …]
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | getnotify.phpt | 17 $pid = $db->pgsqlGetPid(); 21 var_dump($db->pgsqlGetNotify()); 24 $db->exec("LISTEN notifies_phpt"); 25 var_dump($db->pgsqlGetNotify()); 29 $db->exec("NOTIFY notifies_phpt"); 30 $notify = $db->pgsqlGetNotify(); 37 $db->exec("NOTIFY notifies_phpt"); 38 $notify = $db->pgsqlGetNotify(); 44 $db->exec("NOTIFY notifies_phpt"); 51 $db->exec("NOTIFY notifies_phpt"); [all …]
|
H A D | bug68199.phpt | 10 $db = PDOTest::factory(); 23 $pid = $db->pgsqlGetPid(); 27 var_dump($db->pgsqlGetNotify()); 30 $db->exec("LISTEN notifies_phpt"); 31 var_dump($db->pgsqlGetNotify()); 35 $db->exec("NOTIFY notifies_phpt, 'payload'"); 36 $notify = $db->pgsqlGetNotify(); 44 $db->exec("NOTIFY notifies_phpt, 'payload'"); 45 $notify = $db->pgsqlGetNotify(); 52 $db->exec("NOTIFY notifies_phpt, 'payload'"); [all …]
|
H A D | is_in_transaction.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 19 $db->beginTransaction(); 22 var_dump($db->inTransaction()); 29 $db->commit(); 32 var_dump($db->inTransaction()); 34 $db->beginTransaction(); 44 var_dump($db->inTransaction()); 45 $db->rollBack(); [all …]
|
/PHP-7.4/ext/pgsql/tests/ |
H A D | 32nb_async_query.phpt | 14 $db = pg_connect($conn_str); 16 $version = pg_version($db); 22 $db_socket = pg_socket($db); 29 nb_flush($db, $db_socket); 32 nb_consume($db, $db_socket); 34 if (!($result = pg_get_result($db))) { 54 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 67 nb_flush($db, $db_socket); 70 nb_consume($db, $db_socket); 72 if (!($result = pg_get_result($db))) { [all …]
|
H A D | 01createdb.phpt | 2 PostgreSQL create db 11 $db = pg_connect($conn_str); 12 if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name))) 14 pg_query($db,$table_def); // Create table here 16 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');"); 24 if (version_compare($v['server'], '9.2', '>=') && !@pg_num_rows(@pg_query($db, "SELECT * FROM ".$ta… 26 pg_query($db,$table_def_92); // Create table here 33 pg_query($db,$view_def); 35 pg_close($db);
|
H A D | 09notice.phpt | 19 $db = pg_connect($conn_str); 27 var_dump(pg_last_notice($db)); 28 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL)); 30 pg_query($db, "BEGIN;"); 31 pg_query($db, "BEGIN;"); 32 pg_query($db, "BEGIN;"); 33 pg_query($db, "BEGIN;"); 36 var_dump(pg_last_notice($db)); 37 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL)); 42 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL)); [all …]
|
H A D | bug77047.phpt | 13 $db = pg_connect($conn_str); 15 pg_query($db, "DROP TABLE IF EXISTS bug77047"); 16 pg_query($db, "CREATE TABLE bug77047 ( 20 pg_insert($db, "bug77047", array("t" => "13:31")); 21 pg_insert($db, "bug77047", array("t" => "13:31:13")); 22 pg_insert($db, "bug77047", array("t" => "1:2:3")); 23 pg_insert($db, "bug77047", array("t" => "xyz")); 24 pg_insert($db, "bug77047", array("t" => NULL)); 25 pg_insert($db, "bug77047", array("t" => "")); 27 $res = pg_query($db, "SELECT t FROM bug77047");
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | pdo_oci_stream_2a.phpt | 15 $db = PDOTest::factory(); 18 $stmt = $db->prepare($query); 22 $stmt = $db->prepare($query); 25 function do_insert($db, $id, $data1, $data2) 27 $db->beginTransaction(); 40 $db->commit(); 57 do_insert($db, $i * 10 + 2, $a2, $a9); 58 do_insert($db, $i * 10 + 3, $a3, $a8); 59 do_insert($db, $i * 10 + 4, $a4, $a7); 60 do_insert($db, $i * 10 + 5, $a5, $a6); [all …]
|
H A D | pdo_oci_stmt_getcolumnmeta.phpt | 16 $db = PDOTest::factory(); 17 $db->exec(<<<SQL 28 $db->exec("CREATE TABLE test(id INT)"); 30 $db->beginTransaction(); 125 $db->exec(<<<SQL 138 $stmt = $db->prepare($sql); 143 $db->errorCode(), var_export($db->errorInfo(), true)); 207 $db->exec(<<<SQL 234 $stmt = $db->prepare($sql); 274 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); [all …]
|
/PHP-7.4/ext/dba/tests/ |
H A D | bug36436.phpt | 14 $db = dba_popen($db_filename, 'c', 'db4'); 16 dba_insert('X', 'XYZ', $db); 17 dba_insert('Y', '123', $db); 19 var_dump($db, dba_fetch('X', $db)); 21 var_dump(dba_firstkey($db)); 22 var_dump(dba_nextkey($db)); 24 dba_close($db);
|
/PHP-7.4/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 IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)'); 13 $db->query('INSERT INTO foobar VALUES (NULL, "1")'); 14 $db->query('INSERT INTO foobar VALUES (NULL, "2")'); 15 $db->query('INSERT INTO foobar VALUES (NULL, "10")'); 17 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); 19 $result = $db->query('SELECT name FROM foobar ORDER BY name COLLATE MYCOLLATE'); 24 $result = $db->query('SELECT name FROM foobar ORDER BY name'); 29 $db->query('DROP TABLE foobar');
|