/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdosqlite_002.phpt | 8 $db = Pdo::connect('sqlite::memory:'); 9 if (!$db instanceof PdoSqlite) { 10 echo "Wrong class type. Should be PdoSqlite 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, PdoSqlite::DETERMINISTIC… 19 foreach ($db->query('SELECT testing(name) FROM pdosqlite_002') as $row) {
|
/php-src/ext/pdo_dblib/tests/ |
H A D | pdodblib_002.phpt | 15 $db = connectToDb(); 16 if (!$db instanceof PdoDblib) { 17 echo "Wrong class type. Should be PdoDblib 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_mysql/tests/ |
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_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_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_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 | 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 | 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_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 …]
|
H A D | pdo_mysql_stmt_errorcode.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->exec('DROP TABLE IF EXISTS pdo_mysql_stmt_errorcode_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 pdo_mysql_stmt_errorcode_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 pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'… 45 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdomysql_002.phpt | 15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 16 if (!$db instanceof PdoMysql) { 17 echo "Wrong class type. Should be PdoMysql but is " . get_class($db) . "\n"; 20 $db->exec('CREATE TABLE pdomysql_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))'); 21 $db->exec("INSERT INTO pdomysql_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')"); 23 foreach ($db->query('SELECT name FROM pdomysql_002') as $row) { 32 $db = MySQLPDOTest::factory(); 33 $db->query('DROP TABLE pdomysql_002');
|
/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 …]
|
H A D | pdo_002.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test002(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19 $db->exec("INSERT INTO test002 VALUES(1, 'A')"); 20 $db->exec("INSERT INTO test002 VALUES(2, 'B')"); 21 $db->exec("INSERT INTO test002 VALUES(3, 'C')"); 23 $stmt = $db->prepare('SELECT * from test002'); 31 $db = PDOTest::factory(); 32 PDOTest::dropTableIfExists($db, "test002");
|
/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 | 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}");
|
H A D | 04async_query.phpt | 13 $db = pg_connect($conn_str); 14 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 15 pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES"); 17 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) { 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))) 49 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 50 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); 74 $db = pg_connect($conn_str); [all …]
|
/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 …]
|
/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';
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug72633.phpt | 17 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 19 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 21 $db->query('CREATE TABLE test72633 (id SERIAL NOT NULL, field1 VARCHAR(10))'); 23 $stmt = $db->prepare("INSERT INTO test72633 (field1) VALUES ('test')"); 30 var_dump($db->lastInsertId()); 34 var_dump($db->lastInsertId('test72633_id_seq')); 40 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 41 $db->query('DROP TABLE IF EXISTS test72633');
|