/PHP-7.1/ext/pdo_pgsql/tests/ |
H A D | is_in_transaction.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__) . '/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.1/ext/pdo_mysql/tests/ |
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___construct_options.phpt | 21 if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option)))) 72 printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db); 77 printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db); 85 $db = new PDO($dsn, $user, $pass); 88 $tmp = @$db->getAttribute($option); 96 if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 100 if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 115 if (!is_object($db)) 124 if (!is_object($db)) 162 (is_object($db)) ? $db->errorCode() : 'n/a', [all …]
|
H A D | pdo_mysql_multi_stmt_nextrowset.phpt | 8 $db = MySQLPDOTest::factory(); 25 $db = MySQLPDOTest::factory(); 28 MySQLPDOTest::createTestTable($db); 30 function test_proc($db) { 32 $db->exec('DROP PROCEDURE IF EXISTS p'); 34 $stmt = $db->query('CALL p()'); 56 test_proc($db); 63 test_proc($db); 72 $info = $db->errorInfo(); 75 @$db->exec('DROP PROCEDURE IF EXISTS p'); [all …]
|
H A D | bug_39858.phpt | 9 $db = MySQLPDOTest::factory(); 26 $db = MySQLPDOTest::factory(); 29 function bug_39858($db) { 31 $db->exec("DROP PROCEDURE IF EXISTS p"); 32 $db->exec(" 42 $stmt = $db->prepare("CALL p()"); 48 $stmt = $db->prepare("CALL p()"); 59 bug_39858($db); 63 bug_39858($db); 70 $db = MySQLPDOTest::factory(); [all …]
|
H A D | bug_42499.phpt | 11 $db = MySQLPDOTest::factory(); 25 $db = MySQLPDOTest::factory(); 27 function bug_42499($db) { 29 $db->exec('DROP TABLE IF EXISTS test'); 36 $db->exec('SELECT id FROM test'); 43 $db = MySQLPDOTest::factory(); 46 bug_42499($db); 49 $db = MySQLPDOTest::factory(); 52 bug_42499($db); 54 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_multiquery.phpt | 13 function mysql_stmt_multiquery_wrong_usage($db) { 22 function mysql_stmt_multiquery_proper_usage($db) { 34 $db = MySQLPDOTest::factory(); 35 MySQLPDOTest::createTestTable($db); 37 mysql_stmt_multiquery_wrong_usage($db); 38 mysql_stmt_multiquery_proper_usage($db); 41 $db = MySQLPDOTest::factory(); 42 MySQLPDOTest::createTestTable($db); 44 mysql_stmt_multiquery_wrong_usage($db); 45 mysql_stmt_multiquery_proper_usage($db); [all …]
|
H A D | pdo_mysql___construct.phpt | 22 (isset($db) && is_object($db)) ? $db->errorCode() : 'n/a', 23 (isset($db) && is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a'); 32 if (NULL !== ($db = @new PDO())) 62 $db = new PDO($dsn, $user, $pass); 139 $db = @new PDO($dsn, $user, $pass); 147 $db = PDO_MYSQL_TEST_DB; 185 $db = new PDO($dsn, $user, $pass); 206 $db = new PDO($dsn, $user, $pass); 247 $db = new PDO($dsn, $user, $pass); 289 (is_object($db)) ? $db->errorCode() : 'n/a', [all …]
|
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 20 $db->exec('DROP TABLE IF EXISTS test'); 31 $stmt = $db->prepare('SELECT id, label FROM test'); 37 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 41 $db->exec('DELETE FROM test'); 50 $stmt = $db->prepare('SELECT id, label FROM test'); 56 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 64 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_bit.phpt | 18 $db->exec('DROP TABLE IF EXISTS test'); 20 @$db->exec($sql); 21 if ($db->errorCode() != 0) { 33 $stmt = $db->query('SELECT id, label FROM test'); 41 $db = MySQLPDOTest::factory(); 42 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 43 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 44 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 46 test_type($db, 20, 'BIT(8)', 1); 53 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_errorcode.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $db->exec('DROP TABLE IF EXISTS 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 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 ihopeitdoesnotexist ORDER BY id ASC'); [all …]
|
H A D | pdo_mysql_fetch_both.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 function fetch($offset, &$db, $query, $expect = null) { 18 $stmt = $db->query('SELECT 1'); 21 $stmt = $db->query('SELECT 1'); 24 $stmt = $db->query('SELECT 1'); 44 $e->getMessage(), $db->errroCode(), implode(' ', $db->errorInfo())); 52 fetch(2, $db, 'SELECT 1', array(0 => '1', '1' => '1')); 56 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdo_mysql_prepare_match_against.phpt | 12 $db = MySQLPDOTest::factory(); 16 $db->exec('DROP TABLE IF EXISTS test'); 17 $db->exec('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM'); 18 $db->exec('CREATE FULLTEXT INDEX idx1 ON test(label)'); 20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)'); 35 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 44 $db = MySQLPDOTest::factory(); 45 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_prepare_native_dup_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); 40 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 62 $db->exec('DELETE FROM test'); 67 $stmt = $db->prepare($sql); 81 $stmt = $db->prepare($sql); 92 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 100 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_native_placeholder_everywhere.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 16 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 19 $db->exec('DROP TABLE IF EXISTS test'); 21 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')"); 33 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 34 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 57 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 65 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_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())); 62 $db = MySQLPDOTest::factory(); 66 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 96 $stmt = $db->query("SELECT 1 as 'one'"); 110 $db->errorCode(), [all …]
|
H A D | pdo_mysql_prepare_native_column.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1"); 24 $db->prepare('SELECT :placeholder FROM test WHERE :placeholder > :placeholder'); 34 $db = MySQLPDOTest::factory(); 35 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_attr_max_buffer_size.phpt | 24 $db = new PDO($dsn, $user, $pass, 32 $db->exec('DROP TABLE IF EXISTS test'); 33 $db->exec(sprintf('CREATE TABLE test(id INT, val LONGBLOB) ENGINE = %s', PDO_MYSQL_TEST_ENGINE)); 36 $db->exec('INSERT INTO test(id, val) VALUES (1, REPEAT("01234567890", 10240))'); 38 $stmt = $db->prepare('SELECT id, val FROM test'); 48 $db->exec('DROP TABLE IF EXISTS test'); 54 (is_object($db)) ? $db->errorCode() : 'n/a', 55 (is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a'); 69 $db = MySQLPDOTest::factory(); 70 $db->exec('DROP TABLE IF EXISTS test');
|
/PHP-7.1/ext/sqlite3/tests/ |
H A D | bug68760.phpt | 14 $db = new SQLite3(":memory:"); 15 $db->exec("CREATE TABLE test (col1 string)"); 16 $db->exec("INSERT INTO test VALUES ('a1')"); 17 $db->exec("INSERT INTO test VALUES ('a10')"); 18 $db->exec("INSERT INTO test VALUES ('a2')"); 21 $db->createCollation('NATURAL_CMP', 'oopsFunction'); 22 $naturalSort = $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP"); 26 $db->close();
|
/PHP-7.1/ext/pdo_dblib/tests/ |
H A D | pdo_dblib_quote.phpt | 11 var_dump($db->quote(true, PDO::PARAM_BOOL)); 12 var_dump($db->quote(false, PDO::PARAM_BOOL)); 13 var_dump($db->quote(42, PDO::PARAM_INT)); 14 var_dump($db->quote(null, PDO::PARAM_NULL)); 15 var_dump($db->quote('\'', PDO::PARAM_STR)); 16 var_dump($db->quote('foo', PDO::PARAM_STR)); 17 var_dump($db->quote('über', PDO::PARAM_STR));
|
/PHP-7.1/ext/pgsql/tests/ |
H A D | 25async_query_params.phpt | 13 $db = pg_connect($conn_str); 15 $version = pg_version($db); 17 if (!pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))) { 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))) 48 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 49 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 57 …if (!pg_send_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC… 65 pg_close($db);
|
H A D | 28large_object_import_oid.phpt | 15 $db = pg_connect($conn_str); 18 pg_exec($db, 'begin'); 19 $oid = pg_lo_import($db, __FILE__, 21003); 22 pg_lo_unlink ($db, $oid); 23 pg_exec($db, 'commit'); 26 pg_exec($db, 'begin'); 27 $oid = pg_lo_import($db, __FILE__, "21004"); 30 pg_lo_unlink ($db, $oid); 31 pg_exec($db, 'commit'); 35 $oid = pg_lo_import($db, __FILE__, 21005);
|
/PHP-7.1/ext/pdo/tests/ |
H A D | bug_71447.phpt | 16 $db = PDOTest::factory(); 19 $db->setAttribute (\PDO::ATTR_EMULATE_PREPARES, false); 20 $db->exec('CREATE TABLE test(id int)'); 21 $db->exec('INSERT INTO test VALUES(1)'); 24 $stmt = $db->prepare(" 34 $stmt = $db->prepare(" 44 $stmt = $db->prepare(" 54 $stmt = $db->prepare(" 64 $stmt = $db->prepare(" 74 $stmt = $db->prepare(" [all …]
|
/PHP-7.1/ext/pdo_odbc/tests/ |
H A D | max_columns.phpt | 10 $db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt'); 11 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 13 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data varchar(max))')) { 14 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data longtext)')) { 15 if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data CLOB)')) { 16 die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo())); 21 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 25 $db->beginTransaction(); 26 $insert = $db->prepare('INSERT INTO TEST VALUES (?, ?)'); 31 $db->commit(); [all …]
|
/PHP-7.1/ext/pdo_oci/tests/ |
H A D | bug54379.phpt | 15 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt'); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 18 $db->exec("DROP TABLE test"); 21 $db->exec("CREATE TABLE test (col1 NVARCHAR2(20))"); 22 $db->exec("INSERT INTO test VALUES('12345678901234567890')"); 23 $db->exec("INSERT INTO test VALUES('あいうえおかきくけこさしすせそたちつてと')"); 24 $stmt = $db->prepare("SELECT * FROM test"); 27 $db->exec("DROP TABLE test");
|