/php-src/ext/pdo_mysql/tests/ |
H A D | bug_41997.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 18 $db->exec("CREATE PROCEDURE {$procedure}() BEGIN SELECT 1 AS 'one'; END"); 20 $stmt = $db->query("CALL {$procedure}()"); 26 $stmt = $db->query('SELECT 2 AS "two"'); 34 $db = MySQLPDOTest::factory(); 35 $db->exec("DROP PROCEDURE IF EXISTS bug_41997_pdo_mysql_p");
|
H A D | bug70862.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->exec(sprintf('CREATE TABLE test_70862(id INT, label BLOB)')); 17 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 18 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 31 $stmt = $db->prepare('INSERT INTO test_70862(id, label) VALUES (1, :para)'); 42 $db = MySQLPDOTest::factory(); 43 $db->exec('DROP TABLE IF EXISTS test_70862');
|
H A D | bug53551.phpt | 13 $db = MySQLPDOTest::factory(); 15 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 21 $db->exec($createSql); 22 $db->exec("INSERT INTO bug53551 SET `count` = 1 "); 23 $db->exec("SET sql_mode = 'Traditional'"); 25 $stmt = $db->prepare($sql); 44 $db = MySQLPDOTest::factory(); 45 $db->exec('DROP TABLE IF EXISTS bug53551');
|
H A D | pdo_mysql_attr_server_info.phpt | 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 22 if (false !== $db->setAttribute(PDO::ATTR_SERVER_INFO, 'new uptime: 0s')) 25 $new_info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 30 if (!$stmt = $db->query("SHOW STATUS LIKE '%uptime%'")) 31 printf("[004] Cannot run SHOW STATUS, [%s]\n", $db->errorCode()); 34 printf("[005] Unable to fetch uptime, [%s]\n", $db->errorCode());
|
H A D | pdo_mysql_subclass.phpt | 54 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 55 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 56 $db->exec('CREATE TABLE test_subclass(id INT)'); 57 $db->exec('INSERT INTO test_subclass(id) VALUES (1), (2)'); 58 $stmt = $db->query('SELECT * FROM test_subclass ORDER BY id ASC'); 61 $db->intercept_call(); 66 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 69 $db->exec('DROP TABLE IF EXISTS test_subclass'); 75 $db = MySQLPDOTest::factory(); 76 $db->exec('DROP TABLE IF EXISTS test_subclass');
|
H A D | pdo_mysql_stmt_blobs.phpt | 13 $db = MySQLPDOTest::factory(); 26 function test_blob($db, $offset, $sql_type, $test_len) { 28 $db->exec('DROP TABLE IF EXISTS test_stmt_blobs'); 41 $stmt = $db->query('SELECT id, label FROM test_stmt_blobs'); 70 $stmt = $db->query('SELECT id, label FROM test_stmt_blobs'); 90 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 91 test_blob($db, ++$offset, $sql_type, $test_len); 92 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 93 test_blob($db, ++$offset, $sql_type, $test_len); 101 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_native_named_placeholder.phpt | 13 $db = MySQLPDOTest::factory(); 19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 20 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 24 …$stmt = $db->prepare("INSERT INTO test_prepare_native_named_placeholder(id, label) VALUES (100, ':… 37 $stmt = $db->prepare('SELECT id, label FROM test_prepare_native_named_placeholder'); 42 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 43 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 57 … $stmt = $db->prepare('SELECT id, label FROM test_prepare_native_named_placeholder ORDER BY id'); 63 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 71 $db = MySQLPDOTest::factory(); [all …]
|
/php-src/ext/dba/tests/ |
H A D | dba_array_keys_errors.phpt | 13 $name = 'array_keys_errors.db'; 15 $db = get_any_db($name); 18 dba_insert([], "Content String 1", $db); 23 dba_insert(["a", "b", "c"], "Content String 2", $db); 31 var_dump(dba_insert([$o, 'obj'], 'Test', $db)); 36 var_dump(dba_insert(['group', $o], 'Test', $db)); 41 dba_close($db); 47 $db_name = 'array_keys_errors.db';
|
H A D | bug71514.phpt | 13 $db = dba_open($filename, 'c', 'inifile'); 15 dba_insert('foo', 'value1', $db); 16 dba_replace('foo', 'value2', $db); 17 var_dump(dba_fetch('foo', $db)); 19 dba_close($db);
|
/php-src/ext/pdo/tests/ |
H A D | bug_52098.phpt | 16 $db = PDOTest::factory(); 18 $db->exec("CREATE TABLE test52098 (x int)"); 19 $db->exec("INSERT INTO test52098 VALUES (1)"); 31 $derived = $db->prepare('SELECT * FROM test52098', array(PDO::ATTR_STATEMENT_CLASS=>array('MyStatem… 40 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('MyStatement')); 41 $r = $db->query('SELECT * FROM test52098'); 55 $db = PDOTest::factory(); 56 PDOTest::dropTableIfExists($db, "test52098");
|
H A D | pdo_020.phpt | 16 $db = PDOTest::factory(); 18 $db->exec('CREATE TABLE test020(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))'); 19 $db->exec("INSERT INTO test020 VALUES(1, 'A', 'A')"); 20 $db->exec("INSERT INTO test020 VALUES(2, 'B', 'B')"); 21 $db->exec("INSERT INTO test020 VALUES(3, 'C', 'C')"); 25 $stmt = $db->query($sql); 35 $db = PDOTest::factory(); 36 PDOTest::dropTableIfExists($db, "test020");
|
H A D | gh8626.phpt | 12 $db = PDOTest::factory(); 13 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') { 22 $db = PDOTest::factory(); 23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 25 $db->exec('CREATE TABLE test8626 (x int NOT NULL)'); 27 $stmt = $db->prepare('INSERT INTO test8626 VALUES(?)'); 45 $db = PDOTest::factory(); 46 PDOTest::dropTableIfExists($db, "test8626");
|
H A D | bug_39398.phpt | 17 $db = PDOTest::factory(); 18 $db->exec("CREATE TABLE test39398 (test INT)"); 21 $stmt = $db->prepare('INSERT INTO test39398 VALUES (:boolean)'); 25 var_dump($db->query("SELECT * FROM test39398")->fetchAll(PDO::FETCH_ASSOC)); 30 $db = PDOTest::factory(); 31 PDOTest::dropTableIfExists($db, "test39398");
|
H A D | bug_40285.phpt | 17 $db = PDOTest::factory(); 19 $db->exec('CREATE TABLE test40285 (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32), fiel… 21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 22 $s = $db->prepare("INSERT INTO test40285 VALUES( ':id', 'name', 'section', 22)" ); 30 $db = PDOTest::factory(); 31 PDOTest::dropTableIfExists($db, "test40285");
|
H A D | bug_50458.phpt | 17 $db = PDOTest::factory(); 18 $db->exec("CREATE TABLE test50458 (a VARCHAR(10))"); 19 $db->exec("INSERT INTO test50458 (a) VALUES ('xyz')"); 20 $res = $db->query("SELECT a FROM test50458"); 27 $db = PDOTest::factory(); 28 PDOTest::dropTableIfExists($db, "test50458");
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | gh13998.phpt | 13 $db = new PDO('sqlite::memory:'); 14 $db->query('CREATE TABLE test (a int, b int)'); 15 $stmt = $db->query('INSERT INTO test VALUES (1, 1), (2, 2), (3, 3)'); 16 $db->sqliteCreateAggregate('S', $step, $finalize, 1); 19 $db->query('SELECT S(a) FROM test');
|
H A D | pdo_sqlite_createaggregate.phpt | 8 $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 D | pdo_sqlite_open_flags.phpt | 8 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db"; 11 $db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); 13 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags (id INT);')); 15 $db = new PDO('sqlite:' . $filename, null, null, [PDO::SQLITE_ATTR_OPEN_FLAGS => PDO::SQLITE_OPEN_R… 17 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags_2 (id INT);')); 21 $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
|
H A D | bug33841.phpt | 8 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 10 $db->exec('CREATE TABLE test_33841 (text)'); 12 $stmt = $db->prepare("INSERT INTO test_33841 VALUES ( :text )"); 17 $stmt = $db->prepare("UPDATE test_33841 SET text = :text "); 25 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 26 $db->exec('DROP TABLE IF EXISTS test_33841');
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_39_toggleExtended.phpt | 10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )"); 13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 14 echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL; 17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)"); 18 echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL; 21 $db->enableExtendedResultCodes(true); 22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)"); 23 echo "Third (Extended) Error Code: " . $db->lastErrorCode() . PHP_EOL; 26 var_dump($db->close());
|
H A D | sqlite3_rename_column.phpt | 14 $db = new SQLite3(':memory:'); 16 $db->exec('CREATE TABLE tbl (orig text)'); 17 $db->exec('insert into tbl values ("one"), ("two")'); 19 $res1 = $db->prepare('select * from tbl')->execute(); 20 $res2 = $db->prepare('select * from tbl')->execute(); 25 $db->exec('alter table tbl rename column orig to changed');
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | large_objects.phpt | 15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 21 $db->beginTransaction(); 22 $oid = $db->pgsqlLOBCreate(); 24 $stm = $db->pgsqlLOBOpen($oid, 'w+b'); 38 $stmt = $db->prepare("SELECT * from test_large_objects"); 49 $stmt = $db->prepare("SELECT * from test_large_objects"); 79 $db->pgsqlLOBUnlink($oid); 84 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); [all …]
|
H A D | bug71885.phpt | 16 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 18 $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM); 21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate); 24 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\''); 30 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
|
/php-src/ext/pdo_odbc/tests/ |
H A D | bug80783.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 14 $db->exec("CREATE TABLE bug80783 (name IMAGE)"); 17 $db->exec("INSERT INTO bug80783 VALUES('$string')"); 19 $stmt = $db->prepare("SELECT name FROM bug80783"); 29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 30 $db->exec("DROP TABLE IF EXISTS bug80783");
|
/php-src/ext/pgsql/tests/ |
H A D | 10pg_convert_json_array.phpt | 17 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name_92} (textary text[], jsn json)"); 24 $converted = pg_convert($db, $table_name_92, $fields); 27 if (!pg_insert($db, $table_name_92, $fields)) { 39 $db = pg_connect($conn_str); 40 pg_query($db, "DROP TABLE IF EXISTS {$table_name_92}");
|