Home
last modified time | relevance | path

Searched refs:db (Results 76 – 100 of 857) sorted by last modified time

12345678910>>...35

/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdosqlite_006.phpt10 $db = MyPdoSqlite::connect('sqlite::memory:');
11 if (!$db instanceof MyPdoSqlite) {
12 echo "Wrong class type. Should be MyPdoSqlite but is " . get_class($db) . "\n";
H A Dpdosqlite_load_extension_failure.phpt14 $db = PdoSqlite::connect('sqlite::memory:');
15 if (!$db instanceof PdoSqlite) {
16 echo "Wrong class type. Should be PdoSqlite but is " . get_class($db) . "\n";
21 $result = $db->loadExtension("/this/does/not_exist");
30 $result = $db->loadExtension(__FILE__);
H A Dpdo_sqlite_createaggregate_trampoline.phpt8 $db = new PdoSqlite('sqlite::memory:');
10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate_trampoline (a INTEGER, b INTEGER)');
12 $stmt = $db->query('INSERT INTO test_pdo_sqlite_createaggregate_trampoline VALUES (1, -1), (2, -2),…
30 var_dump($db->createAggregate('S', [new TrampolineTest(), 'step'], [new TrampolineTest(), 'finalize…
32 foreach ($db->query('SELECT S(a), S(b) FROM test_pdo_sqlite_createaggregate_trampoline') as $row) {
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createaggregate.phpt8 $db = new PDO('sqlite::memory:');
10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO test_pdo_sqlite_createaggregate VALUES (NULL, "PHP"), (NULL, "PHP6")');
14 $db->sqliteCreateAggregate('testing', function(&$a, $b) { $a .= $b; return $a; }, function(&$v) { r…
17 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createaggregate') as $row) {
H A Dpdo_sqlite_createcollation.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10…
15 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); });
17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL…
22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
H A Dpdo_sqlite_createfunction_with_flags.phpt12 $db = new PDO('sqlite::memory:');
14 $db->query('CREATE TABLE test_pdo_sqlite_createfunction_with_flags (id INT AUTO INCREMENT, name TEX…
16 $db->query('INSERT INTO test_pdo_sqlite_createfunction_with_flags VALUES (NULL, "PHP"), (NULL, "PHP…
19 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }, 1, PDO::SQLITE_DETERM…
22 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createfunction_with_flags') as $row)…
H A Dpdo_sqlite_transaction.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
11 $db->beginTransaction();
13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)');
14 $db->commit();
16 $db->beginTransaction();
17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")');
18 $db->rollback();
20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction');
23 $db->query('DROP TABLE test_pdo_sqlite_transaction');
/php-src/ext/pdo_odbc/tests/
H A Dpdoodbc_001.phpt15 $db = new PdoOdbc($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV']['PD…
17 $db->query("CREATE TABLE pdoodbc_001 (id INT, name TEXT)");
18 $db->query("INSERT INTO pdoodbc_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')");
20 foreach ($db->query('SELECT name FROM pdoodbc_001') as $row) {
29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
30 $db->exec("DROP TABLE IF EXISTS pdoodbc_001");
H A Dpdoodbc_002.phpt15 $db = PdoOdbc::connect($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV'…
16 if (!$db instanceof PdoOdbc) {
17 echo "Wrong class type. Should be PdoOdbc but is " . get_class($db) . "\n";
20 $db->exec('CREATE TABLE pdoodbc_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))');
21 $db->exec("INSERT INTO pdoodbc_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')");
23 foreach ($db->query('SELECT name FROM pdoodbc_002') as $row) {
32 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
33 $db->exec("DROP TABLE IF EXISTS pdoodbc_002");
/php-src/ext/pdo_pgsql/tests/
H A Dpdopgsql_001.phpt17 $db = new PdoPgsql($config['ENV']['PDOTEST_DSN']);
19 $db->query('CREATE TABLE pdopgsql_001 (id INT, name TEXT)');
20 $db->query("INSERT INTO pdopgsql_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')");
22 foreach ($db->query('SELECT name FROM pdopgsql_001') as $row) {
/php-src/ext/pdo_mysql/tests/inc/
H A Dmysql_pdo_test.inc23 $db = new $classname($dsn, $user, $pass, $attr);
24 if (!$db) {
31 return $db;
42 $db->exec("DROP TABLE IF EXISTS {$table}");
84 static function getClientVersion($db) {
88 static function getServerVersion($db) {
146 foreach ($db->query("SHOW ENGINES") as $row) {
166 $db = self::factory();
173 $db = self::factory();
187 $db = self::factory();
[all …]
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_interface.phpt13 $db = MySQLPDOTest::factory();
33 $classname = get_class($db);
H A Dpdomysql_001.phpt15 $db = MySQLPDOTest::factory(PdoMysql::class);
17 $db->query('CREATE TABLE pdomysql_001 (id INT, name TEXT)');
19 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP")');
20 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP6")');
22 foreach ($db->query('SELECT name FROM pdomysql_001') as $row) {
31 $db = MySQLPDOTest::factory();
32 $db->exec('DROP TABLE IF EXISTS pdomysql_001');
H A Dpdomysql_002.phpt15 $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');
H A Dpdomysql_003.phpt15 $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 $assertWarnings = function ($db, $q, $count) {
21 $db->query($q);
22 printf("Query %s produced %d warnings\n", $q, $db->getWarningCount());
24 $assertWarnings($db, 'SELECT 1 = 1', 0);
25 $assertWarnings($db, 'SELECT 1 = "A"', 1);
/php-src/ext/pdo_dblib/tests/
H A Dtimeout.phpt15 $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 …]
H A Dtypes.phpt14 $db = getDbConnection();
17 global $db;
19 switch ($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION)) {
44 $stmt = $db->query($sql);
56 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
57 $stmt = $db->query($sql);
H A Ddbtds.phpt14 $db = getDbConnection();
16 $version = $db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION);
H A Ddbversion.phpt14 $db = getDbConnection();
16 $version = $db->getAttribute(PDO::DBLIB_ATTR_VERSION);
H A Dpdo_dblib_param_str_natl.phpt14 $db = getDbConnection();
16 $stmt = $db->prepare('SELECT :value');
H A Dpdo_dblib_quote.phpt13 $db = getDbConnection();
14 var_dump($db->quote(true, PDO::PARAM_BOOL));
15 var_dump($db->quote(false, PDO::PARAM_BOOL));
16 var_dump($db->quote(42, PDO::PARAM_INT));
17 var_dump($db->quote(null, PDO::PARAM_NULL));
18 var_dump($db->quote('\'', PDO::PARAM_STR));
19 var_dump($db->quote('foo', PDO::PARAM_STR));
20 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
21 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
27 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR));
[all …]
H A Dpdodblib_001.phpt14 $db = getDbConnection(PdoDblib::class);
16 $db->query("CREATE TABLE #pdo_dblib_001(name VARCHAR(32)); ");
17 $db->query("INSERT INTO #pdo_dblib_001 VALUES('PHP'), ('PHP6');");
19 foreach ($db->query('SELECT name FROM #pdo_dblib_001') as $row) {
28 $db = getDbConnection();
29 $db->query('DROP TABLE IF EXISTS #pdo_dblib_001');
H A Dpdodblib_002.phpt15 $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');
H A Dstringify_uniqueidentifier.phpt8 $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 Dbatch_stmt_ins_up.phpt8 $db = getDbConnection();
9 if (!driver_supports_batch_statements_without_select($db)) die('xfail test will fail with this vers…
15 $db = getDbConnection();
16 $stmt = $db->query(

Completed in 31 milliseconds

12345678910>>...35