/php-src/ext/pdo_dblib/tests/ |
H A D | config.inc | 7 function driver_supports_batch_statements_without_select($db) { 8 $version = $db->getAttribute(PDO::DBLIB_ATTR_VERSION); 38 function setAttributes(PDO $db) { 39 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 40 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 47 $db = new $class($dsn, $user, $pass, $attributes); 49 setAttributes($db); 55 return $db; 62 $db = PDO::connect($dsn, $user, $pass); 63 setAttributes($db); [all …]
|
H A D | timeout.phpt | 15 $db = getDbConnection(); 20 $db = getDbConnection(); 21 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 22 $db->setAttribute(PDO::ATTR_TIMEOUT, 1); 23 $stmt = $db->prepare($sql); 34 $db = getDbConnection(); 35 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1); 37 $stmt = $db->prepare($sql); 49 $stmt = $db->prepare($sql); [all …]
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_local_infile_directory_allowed.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_allowed(id INT NOT NULL PRIMAR… 46 if (exec_and_count(3, $db, $sql, 3)) { 47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_dir_allowed ORDER BY id ASC'); 71 $db->errorCode(), implode(' ', $db->errorInfo())); 79 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_local_infile_overrides_local_infile_directory.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_overrides(id INT NOT NULL PRIMARY … 46 if (exec_and_count(3, $db, $sql, 3)) { 47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_overrides ORDER BY id ASC'); 71 $db->errorCode(), implode(' ', $db->errorInfo())); 79 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_exec_load_data.phpt | 11 $db = MySQLPDOTest::factory(); 12 $stmt = $db->query('SELECT USER() as _user'); 20 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'"); 33 function exec_and_count($offset, &$db, $sql, $exp) { 35 $ret = $db->exec($sql); 39 $db->errorCode(), implode(' ', $db->errorInfo())); 43 if (42000 == $db->errorCode()) { 50 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 64 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'"); 78 if (exec_and_count(4, $db, $sql, 2)) { [all …]
|
H A D | pdo_mysql_prepare_native_placeholder_everywhere.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 18 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 22 …$db->exec("INSERT INTO test_prepare_native_named_placeholder_everywhere(id, label) VALUES (1, 'row… 24 …$stmt = $db->prepare('SELECT ?, id, label FROM test_prepare_native_named_placeholder_everywhere WH… 34 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 35 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 49 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 57 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_match_against.phpt | 13 $db = MySQLPDOTest::factory(); 16 $db->exec('CREATE TABLE test_prepare_match_against(id INT, label CHAR(255)) ENGINE=MyISAM'); 17 $db->exec('CREATE FULLTEXT INDEX idx1 ON test_prepare_match_against(label)'); 19 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (… 23 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (… 27 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (… 32 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 40 $db = MySQLPDOTest::factory(); 41 $db->exec('DROP TABLE IF EXISTS test_prepare_match_against');
|
H A D | pecl_bug_5780.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->exec("CREATE TABLE test_pecl_bug_5780 (login varchar(32) NOT NULL, data varchar(64) NOT NULL)"… 16 $db->exec("CREATE TABLE test_pecl_bug_5780_2 (login varchar(32) NOT NULL, password varchar(64) NOT … 17 $db->exec("INSERT INTO test_pecl_bug_5780_2 (login, password) VALUES ('testing', 'testing')"); 18 $db->exec("INSERT INTO test_pecl_bug_5780_2 (login, password) VALUES ('test2', 'testpw2')"); 20 $logstmt = $db->prepare('INSERT INTO test_pecl_bug_5780 (login, data) VALUES (:var1, :var2)'); 21 $authstmt = $db->prepare('SELECT * FROM test_pecl_bug_5780_2 WHERE login = :varlog AND password = :… 32 $db = MySQLPDOTest::factory(); 33 $db->exec('DROP TABLE IF EXISTS test_pecl_bug_5780'); 34 $db->exec('DROP TABLE IF EXISTS test_pecl_bug_5780_2');
|
H A D | pdo_mysql_prepare_native_myisam_index.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())); 148 $db->quote('%ro%')); 149 $stmt = prepex(13, $db, $sql, array(-1)); 154 $db->quote('%ro%')); 155 $stmt = prepex(14, $db, $sql, array(1)); 166 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_param_str_natl.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 17 $db->exec('CREATE TABLE test_param_str_natl (bar NCHAR(4) NOT NULL)'); 19 $stmt = $db->prepare('INSERT INTO test_param_str_natl VALUES(?)'); 23 var_dump($db->query('SELECT * from test_param_str_natl')); 24 foreach ($db->query('SELECT * from test_param_str_natl') AS $row) { 31 $db = MySQLPDOTest::factory(); 32 $db->exec('DROP TABLE IF EXISTS test_param_str_natl');
|
H A D | pdo_mysql_stmt_rowcount.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table, $db); 20 if (0 !== ($tmp = $db->query("SELECT id FROM {$table} WHERE 1 = 0")->rowCount())) 23 if (1 !== ($tmp = $db->query("SELECT id FROM {$table} WHERE id = 1")->rowCount())) 28 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 36 $db = MySQLPDOTest::factory(); 37 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_rowcount');
|
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 20 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 39 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 61 $db->exec('DELETE FROM test_prepare_native_dup_named'); 66 $stmt = $db->prepare($sql); 75 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 80 $stmt = $db->prepare($sql); 89 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | change_column_count.phpt | 14 $db = MySQLPDOTest::factory(); 15 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 18 $db->exec('CREATE TABLE test_change_column_count (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255… 20 $stmt = $db->prepare('INSERT INTO test_change_column_count (id, name) VALUES(:id, :name)'); 26 $stmt = $db->prepare('SELECT * FROM test_change_column_count WHERE id = :id'); 30 $db->exec('ALTER TABLE test_change_column_count ADD new_col VARCHAR(255)'); 37 $db = MySQLPDOTest::factory(); 38 $db->exec('DROP TABLE IF EXISTS test_change_column_count');
|
H A D | pdo_mysql_attr_statement_class.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 18 MySQLPDOTest::createTestTable($table, $db); 20 $default = $db->getAttribute(PDO::ATTR_STATEMENT_CLASS); 24 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, 'foo'); 29 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['classname']); 35 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['classname', []]); 48 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['myclass', []]); 98 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS)); 131 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 13 $db = MySQLPDOTest::factory(); 18 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, []); 23 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, new stdClass()); 28 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 'pdo'); 33 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 37 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0); 41 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 42 $stmt = $db->query('SELECT VERSION() as _version'); 49 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 55 $stmt = $db->prepare("CALL {$procedure}()"); [all …]
|
/php-src/ext/pdo/tests/ |
H A D | bug_34630.phpt | 16 $db = PDOTest::factory(); 18 $driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME); 22 $db->exec('CREATE TABLE test34630 (id int NOT NULL PRIMARY KEY, val BLOB)'); 24 $db->exec('CREATE TABLE test34630 (id int NOT NULL PRIMARY KEY, val VARCHAR(256))'); 26 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 36 $db->beginTransaction(); 39 $insert = $db->prepare("insert into test34630 (id, val) values (1, :blob)"); 45 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 46 var_dump($db->query("SELECT * from test34630")->fetchAll(PDO::FETCH_ASSOC)); 52 $db = PDOTest::factory(); [all …]
|
/php-src/ext/pgsql/tests/ |
H A D | 10pg_convert_9.phpt | 17 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 20 pg_query($db, "SET standard_conforming_strings = 0"); 23 $converted = pg_convert($db, $table_name, $fields); 29 $converted = pg_convert($db, $table_name, [5 => 'AAA']); 34 $converted = pg_convert($db, $table_name, ['AAA']); 39 $converted = pg_convert($db, $table_name, ['num' => []]); 44 $converted = pg_convert($db, $table_name, ['num' => new stdClass()]); 49 $converted = pg_convert($db, $table_name, ['num' => $db]); 60 $db = pg_connect($conn_str); [all …]
|
H A D | 23sync_query_params.phpt | 15 $db = pg_connect($conn_str); 16 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 17 pg_query($db, "INSERT INTO {$table_name} (num) VALUES(1000)"); 19 $result = pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)); 42 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 43 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 51 $result = pg_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC"… 55 pg_close($db); 64 $db = pg_connect($conn_str); 65 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 18pg_escape_bytea_hex.phpt | 17 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 20 @pg_query($db, "SET bytea_output = 'hex'"); 23 $esc_image = pg_escape_bytea($db, $image); 25 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 26 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876'); 42 $db = pg_connect($conn_str); 43 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 18pg_escape_bytea_esc.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 17 @pg_query($db, "SET bytea_output = 'escape'"); 20 $esc_image = pg_escape_bytea($db, $image); 22 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 23 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876'); 39 $db = pg_connect($conn_str); 40 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdosqlite_002.phpt | 8 $db = Pdo::connect('sqlite::memory:'); 9 if (!$db instanceof Pdo\Sqlite) { 10 echo "Wrong class type. Should be Pdo\Sqlite but is " . get_class($db) . "\n"; 13 $db->query('CREATE TABLE pdosqlite_002 (id INT AUTO INCREMENT, name TEXT)'); 14 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP")'); 15 $db->query('INSERT INTO pdosqlite_002 VALUES (NULL, "PHP6")'); 17 $db->createFunction('testing', function($v) { return strtolower($v); }, 1, Pdo\Sqlite::DETERMINISTI… 19 foreach ($db->query('SELECT testing(name) FROM pdosqlite_002') as $row) {
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_40_setauthorizer.phpt | 8 $db = new SQLite3(':memory:'); 9 $db->enableExceptions(true); 11 $db->setAuthorizer(function (int $action) { 20 var_dump($db->querySingle('SELECT 1;')); 30 $db->setAuthorizer(null); 37 $db->setAuthorizer(function (int $action) { 46 var_dump($db->exec('DROP TABLE test;')); 49 $db->setAuthorizer(function () { 54 var_dump($db->querySingle('SELECT 1;')); 60 $db->setAuthorizer(function () { [all …]
|
H A D | sqlite3_29_createfunction.phpt | 11 var_dump($db->createfunction($func, $func)); 12 var_dump($db->querySingle('SELECT strtoupper("test")')); 15 var_dump($db->createfunction($func2, $func2)); 16 var_dump($db->querySingle('SELECT strtolower("TEST")')); 18 var_dump($db->createfunction($func, $func2)); 19 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_lastinsertid.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->query('CREATE TABLE test_pdo_sqlite_lastinsertid (id INT AUTO INCREMENT, name TEXT)'); 10 $db->query('INSERT INTO test_pdo_sqlite_lastinsertid VALUES (NULL, "PHP"), (NULL, "PHP6")'); 11 var_dump($db->query('SELECT * FROM test_pdo_sqlite_lastinsertid')); 12 var_dump($db->errorInfo()); 13 var_dump($db->lastInsertId());
|
/php-src/ext/dba/tests/ |
H A D | dba_fetch_legacy_signature.phpt | 13 $name = 'legacy_fetch_signature.db'; 15 $db = get_any_db($name); 17 dba_insert("key1", "This is a test insert", $db); 18 echo dba_fetch("key1", 0, $db), \PHP_EOL, dba_fetch("key1", $db, 0), \PHP_EOL; 25 dba_fetch("key1", 0, $db); 29 dba_close($db); 35 $db_name = 'legacy_fetch_signature.db';
|