/php-src/ext/pdo_mysql/tests/ |
H A D | gh11587.phpt | 14 $db = MySQLPDOTest::factory(); 25 $db->exec($createTestTable); 31 $db->exec($insertTestTable); 34 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 36 $results = $db->query('SELECT * FROM test_11587'); 44 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 46 $results = $db->query('SELECT * FROM test_11587'); 56 $results = $db->query('SELECT * FROM test_11587'); 66 $results = $db->query('SELECT * FROM test_11587'); 78 $db = MySQLPDOTest::factory(); [all …]
|
H A D | bug_42499.phpt | 13 $db = MySQLPDOTest::factory(); 15 function bug_42499($db) { 16 $db->exec("DROP TABLE IF EXISTS test_42499"); 23 $db->exec('SELECT id FROM test_42499'); 29 $db = MySQLPDOTest::factory(); 30 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 32 bug_42499($db); 35 $db = MySQLPDOTest::factory(); 38 bug_42499($db); 45 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_emulated_myisam_index.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 21 $stmt = @$db->prepare($query); 23 $stmt = $db->prepare($query); 26 $tmp = $db->errorInfo(); 80 $db->errorCode(), implode(' ', $db->errorInfo())); 132 $db->quote('%ro%')); 139 $db->quote('%ro%')); 140 $stmt = prepex(15, $db, $sql, array(1)); 155 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_prepare_native_anonymous_placeholder.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())); 216 $db->quote('%ro%')); 217 $stmt = prepex(30, $db, $sql, array(-1)); 222 $db->quote('%ro%')); 223 $stmt = prepex(31, $db, $sql, array(1)); 234 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 13 $db = MySQLPDOTest::factory(); 44 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 45 $stmt = $db->prepare("CALL {$procedure}(?)"); 58 $db = MySQLPDOTest::factory(); 76 $db->exec('SET @numcols = 1'); 77 $stmt = $db->prepare("CALL {$procedure}()"); 82 $db->exec('SET @numcols = 1'); 89 $db = MySQLPDOTest::factory(); 92 $db->exec('SET @numcols = 1'); 98 $db->exec('SET @numcols = 1'); [all …]
|
H A D | pdo_mysql_local_infile_directory_denied.phpt | 16 function exec_and_count($offset, &$db, $sql, $exp) { 18 $ret = $db->exec($sql); 22 $db->errorCode(), implode(' ', $db->errorInfo())); 27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 35 $db = MySQLPDOTest::factoryWithAttr([ 41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_dir_denied(id INT NOT NULL PRIMARY… 46 if (exec_and_count(3, $db, $sql, false)) { 47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_dir_denied ORDER BY id ASC'); 61 $db->errorCode(), implode(' ', $db->errorInfo())); 69 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_fetch_both.phpt | 13 $db = MySQLPDOTest::factory(); 15 function fetch($offset, &$db, $query, $expect = null) { 17 $stmt = $db->query('SELECT 1'); 20 $stmt = $db->query('SELECT 1'); 23 $stmt = $db->query('SELECT 1'); 41 $e->getMessage(), $db->errroCode(), implode(' ', $db->errorInfo())); 46 fetch(2, $db, 'SELECT 1', array(0 => '1', '1' => '1')); 49 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdo_mysql_prepare_emulated_myisam.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $stmt = @$db->prepare($query); 21 $stmt = $db->prepare($query); 24 $tmp = $db->errorInfo(); 77 $db->errorCode(), implode(' ', $db->errorInfo())); 85 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 125 $db->quote('%ro%')); 132 $db->quote('%ro%')); 143 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_bit.phpt | 19 @$db->exec($sql); 20 if ($db->errorCode() != 0) { 25 $stmt = $db->prepare('INSERT INTO test_mysql_bit(id, label) VALUES (?, ?)'); 32 $stmt = $db->query('SELECT id, label FROM test_mysql_bit'); 40 $db = MySQLPDOTest::factory(); 41 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 45 test_type($db, 20, 'BIT(8)', 1); 52 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_exec_select.phpt | 12 function exec_and_count($offset, &$db, $sql, $exp) { 14 $ret = $db->exec($sql); 18 $db->errorCode(), implode(' ', $db->errorInfo())); 24 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 32 $db = MySQLPDOTest::factory(); 38 exec_and_count(4, $db, "INSERT INTO test_mysql_exec_select(id, col1) VALUES (1, 'a')", 1); 41 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); 42 exec_and_count(5, $db, 'SELECT id FROM test_mysql_exec_select', 0); 48 $db->errorCode(), implode(' ', $db->errorInfo())); 56 $db = MySQLPDOTest::factory(); [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | 13pg_select_9.phpt | 17 $db = pg_connect($conn_str); 19 pg_query($db, "INSERT INTO {$table_name} VALUES(1234, 'AAA', 'BBB')"); 22 pg_query($db, "SET bytea_output = 'hex'"); 26 $res = pg_select($db, $table_name, $ids) or print "Error\n"; 28 echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n"; 33 $converted = pg_select($db, $table_name, [5 => 'AAA']); 38 $converted = pg_select($db, $table_name, ['AAA']); 43 $converted = pg_select($db, $table_name, ['num' => []]); 53 $converted = pg_select($db, $table_name, ['num' => $db]); 67 $db = pg_connect($conn_str); [all …]
|
H A D | 12pg_insert_9.phpt | 17 $db = pg_connect($conn_str); 20 pg_query($db, "SET standard_conforming_strings = 0"); 24 pg_insert($db, $table_name, $fields) or print "Error in test 1\n"; 25 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n"; 27 var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) ); 31 $converted = pg_insert($db, $table_name, [5 => 'AAA']); 36 $converted = pg_insert($db, $table_name, ['AAA']); 41 $converted = pg_insert($db, $table_name, ['num' => []]); 51 $converted = pg_insert($db, $table_name, ['num' => $db]); 64 $db = pg_connect($conn_str); [all …]
|
H A D | 15pg_delete.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 16 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 17 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 21 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n"; 22 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n"; 23 if (!pg_delete($db, $table_name, $ids)) { 35 $db = pg_connect($conn_str); 36 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 14pg_update_9.phpt | 17 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 19 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 20 pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); 22 pg_query($db, "SET standard_conforming_strings = 0"); 27 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n"; 28 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n"; 29 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n"; 38 $db = pg_connect($conn_str); 39 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 06copy.phpt | 13 $db = pg_connect($conn_str); 14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 16 $rows = pg_copy_to($db, $table_name); 18 pg_query($db, "DELETE FROM $table_name"); 20 pg_copy_from($db, $table_name, $rows); 30 $db = pg_connect($conn_str); 31 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 06_bug73498.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 16 pg_query($db, "CREATE VIEW {$view_name} as SELECT * FROM {$table_name}"); 17 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES"); 19 $rows = pg_copy_to($db, "(SELECT * FROM {$view_name})"); 31 $db = pg_connect($conn_str); 32 pg_query($db, "DROP VIEW IF EXISTS {$view_name}"); 33 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
/php-src/ext/pdo_odbc/tests/ |
H A D | max_columns.phpt | 13 $db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 16 if (false === $db->exec('CREATE TABLE test_max_columns (id INT NOT NULL PRIMARY KEY, data varchar(m… 19 … die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo())); 24 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 28 $db->beginTransaction(); 29 $insert = $db->prepare('INSERT INTO test_max_columns VALUES (?, ?)'); 34 $db->commit(); 36 foreach ($db->query('SELECT id, data from test_max_columns') as $row) { 51 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); [all …]
|
/php-src/ext/pdo_dblib/tests/ |
H A D | stringify_uniqueidentifier.phpt | 8 $db = getDbConnection(); 15 $db = getDbConnection(); 25 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); 26 var_dump(true === $db->getAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER)); 27 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, false); 34 $stmt = $db->query($sql); 43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 44 $stmt = $db->query($sql); 46 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 57 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); [all …]
|
H A D | datetime2.phpt | 8 $db = getDbConnection(); 9 if (in_array($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION), ['4.2', '4.6', '5.0', '6.0', '7.0', '7… 15 $db = getDbConnection(); 19 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 21 $stmt = $db->query($sql); 24 $db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1); 25 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 26 $stmt = $db->query($sql);
|
H A D | pdodblib_002.phpt | 15 $db = connectToDb(); 16 if (!$db instanceof Pdo\Dblib) { 17 echo "Wrong class type. Should be Pdo\Dblib but is " . get_class($db) . "\n"; 20 $db->query("CREATE TABLE #pdo_dblib_002(name VARCHAR(32))"); 21 $db->query("INSERT INTO #pdo_dblib_002 VALUES('PHP'), ('PHP6')"); 23 foreach ($db->query('SELECT name FROM #pdo_dblib_002') as $row) { 32 $db = getDbConnection(); 33 $db->query('DROP TABLE IF EXISTS #pdo_dblib_002');
|
/php-src/ext/pdo/tests/ |
H A D | bug_71447.phpt | 17 $db = PDOTest::factory(); 21 $db->exec('CREATE TABLE test71447(id int)'); 22 $db->exec('INSERT INTO test71447 VALUES(1)'); 25 $stmt = $db->prepare(" 35 $stmt = $db->prepare(" 45 $stmt = $db->prepare(" 55 $stmt = $db->prepare(" 65 $stmt = $db->prepare(" 75 $stmt = $db->prepare(" 86 $stmt = $db->prepare(" [all …]
|
H A D | pdo_032.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test032(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test032 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test032 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test032 VALUES(3, 'C')"); 24 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); 25 $stmt = $db->prepare('SELECT * from test032'); 31 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER); 32 $stmt = $db->prepare('SELECT * from test032'); 41 $db = PDOTest::factory(); [all …]
|
/php-src/ext/sqlite3/tests/ |
H A D | bug68760.phpt | 12 $db = new SQLite3(":memory:"); 13 $db->exec("CREATE TABLE test (col1 string)"); 14 $db->exec("INSERT INTO test VALUES ('a1')"); 15 $db->exec("INSERT INTO test VALUES ('a10')"); 16 $db->exec("INSERT INTO test VALUES ('a2')"); 19 $db->createCollation('NATURAL_CMP', 'oopsFunction'); 20 $naturalSort = $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP"); 24 $db->close();
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug71885_2.phpt | 12 $db = PDOTest::factory(); 13 if (version_compare($db->getAttribute(PDO::ATTR_SERVER_VERSION), '9.4.0') < 0) { 22 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 24 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM); 26 $jsonb = $db->quote(json_encode(['a' => 1])); 29 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate); 31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?"); 35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
|
H A D | bug_49985.phpt | 15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 18 $db->exec("CREATE TABLE b49985 (a int PRIMARY KEY)"); 22 $db->beginTransaction(); 23 $stmt = $db->prepare("INSERT INTO b49985 (a) VALUES (?)"); 25 $db->commit(); 28 $db->rollback(); 36 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 37 $db->query('DROP TABLE IF EXISTS b49985 CASCADE');
|