/PHP-5.6/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_types_zerofill.phpt | 15 $db->exec('DROP TABLE IF EXISTS test'); 17 @$db->exec($sql); 18 if ($db->errorCode() != 0) { 37 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 38 $stmt = $db->query('SELECT id, label FROM test'); 78 $stmt = $db->query('SELECT id, label FROM test'); 89 $db = MySQLPDOTest::factory(); 91 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 94 $stmt = $db->prepare('SELECT @@sql_mode AS _mode'); 124 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_stmt_nextrowset.phpt | 10 $db = MySQLPDOTest::factory(); 40 function test_proc1($db) { 75 test_proc1($db); 76 test_proc2($db); 82 test_proc1($db); 83 test_proc2($db); 91 test_proc1($db); 92 test_proc2($db); 99 test_proc1($db); 100 test_proc2($db); [all …]
|
H A D | pdo_mysql_get_attribute.phpt | 8 $db = MySQLPDOTest::factory(); 15 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 30 if (!$db->setAttribute($attribute, $value)) { 42 $tmp = $db->getAttribute($attribute); 52 $db->errorCode(), implode(' ', $db->errorInfo())); 59 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, 1); 61 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0); 62 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1); 64 set_and_get(4, $db, PDO::ATTR_AUTOCOMMIT, $obj); [all …]
|
H A D | pdo_mysql_prepare_emulated.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 22 $stmt = $db->prepare($query); 25 $tmp = $db->errorInfo(); 79 $db->errorCode(), implode(' ', $db->errorInfo())); 92 prepex(3, $db, '', 183 $db->quote('%ro%')); 190 $db->quote('%ro%')); 292 $db->quote('%ro%')); 299 $db->quote('%ro%')); [all …]
|
H A D | pdo_mysql_attr_case.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 31 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 37 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 45 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 49 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 53 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 59 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 67 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); 73 var_export($db->errorInfo(), true), var_export($db->errorCode(), true)); [all …]
|
H A D | pdo_mysql_prepare_native.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 22 $stmt = $db->prepare($query); 25 $tmp = $db->errorInfo(); 90 $db->errorCode(), implode(' ', $db->errorInfo())); 103 prepex(3, $db, '', 190 $db->quote('%ro%')); 196 $db->quote('%go%')); 315 $db->quote('%ro%')); 321 $db->quote('%ro%')); [all …]
|
H A D | bug_pecl_7976.phpt | 9 $db = MySQLPDOTest::factory(); 24 $db = MySQLPDOTest::factory(); 26 function bug_pecl_7976($db) { 28 $db->exec('DROP PROCEDURE IF EXISTS p'); 31 $stmt = $db->query('CALL p()'); 35 $stmt = $db->query('CALL p()'); 42 $db = MySQLPDOTest::factory(); 44 bug_pecl_7976($db); 47 $db = MySQLPDOTest::factory(); 49 bug_pecl_7976($db); [all …]
|
H A D | pdo_mysql_stmt_columncount.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 29 $stmt = $db->query('SELECT * FROM test'); 34 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 39 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 40 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 47 $stmt = $db->query('SELECT * FROM test'); [all …]
|
H A D | bug_44454.phpt | 16 function bug_44454($db) { 20 $db->exec('DROP TABLE IF EXISTS test'); 22 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 24 $stmt = $db->query('SELECT a, b FROM test'); 36 $db->exec('DROP TABLE IF EXISTS test'); 44 $stmt = $db->query('SELECT a, b FROM test'); 61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 62 bug_44454($db); 66 bug_44454($db); 73 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql___construct_options.phpt | 21 if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option)))) 71 printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db); 74 printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db); 82 $db = new PDO($dsn, $user, $pass); 85 $tmp = @$db->getAttribute($option); 93 if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 97 if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 112 if (!is_object($db)) 121 if (!is_object($db)) 159 (is_object($db)) ? $db->errorCode() : 'n/a', [all …]
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 10 $db = MySQLPDOTest::factory(); 25 $db = MySQLPDOTest::factory(); 59 $stmt = $db->prepare('CALL p(?)'); 72 $db = MySQLPDOTest::factory(); 90 $db->exec('SET @numcols = 1'); 91 $stmt = $db->prepare('CALL p()'); 96 $db->exec('SET @numcols = 1'); 103 $db = MySQLPDOTest::factory(); 106 $db->exec('SET @numcols = 1'); 112 $db->exec('SET @numcols = 1'); [all …]
|
H A D | pdo_mysql_exec_select.phpt | 11 function exec_and_count($offset, &$db, $sql, $exp) { 15 $ret = $db->exec($sql); 19 $db->errorCode(), implode(' ', $db->errorInfo())); 25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 33 $db = MySQLPDOTest::factory(); 34 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 39 exec_and_count(2, $db, 'DROP TABLE IF EXISTS test', 0); 45 exec_and_count(5, $db, 'SELECT id FROM test', 0); 51 $db->errorCode(), implode(' ', $db->errorInfo())); 59 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_exec_load_data.phpt | 10 $db = MySQLPDOTest::factory(); 11 $stmt = $db->query('SELECT USER() as _user'); 37 $ret = $db->exec($sql); 41 $db->errorCode(), implode(' ', $db->errorInfo())); 47 if (42000 == $db->errorCode()) { 54 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 63 $db = MySQLPDOTest::factory(); 64 MySQLPDOTest::createTestTable($db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 108 $db->errorCode(), implode(' ', $db->errorInfo())); 116 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_attr_multi_statements.phpt | 8 $db = MySQLPDOTest::factory(); 21 $db = new PDO($dsn, $user, $pass); 22 $db->exec(sprintf('DROP TABLE IF EXISTS %s', $table)); 24 $db->exec($create); 28 $info = $db->errorInfo(); 30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 33 $stmt = $db->query('SELECT 1 AS value;'); 40 $info = $db->errorInfo(); 43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 46 $stmt = $db->query('SELECT 1 AS value;'); [all …]
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 27 MySQLPDOTest::createTestTable($db); 29 $db->exec('DROP TABLE test'); 32 var_dump($db->errorInfo()); 36 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); 48 MySQLPDOTest::createTestTable($db); 51 $db->exec('DROP TABLE test'); 54 var_dump($db->errorInfo()); [all …]
|
/PHP-5.6/ext/pdo_pgsql/tests/ |
H A D | getnotify.phpt | 17 $pid = $db->pgsqlGetPid(); 21 var_dump($db->pgsqlGetNotify()); 24 $db->exec("LISTEN notifies_phpt"); 25 var_dump($db->pgsqlGetNotify()); 29 $db->exec("NOTIFY notifies_phpt"); 30 $notify = $db->pgsqlGetNotify(); 37 $db->exec("NOTIFY notifies_phpt"); 38 $notify = $db->pgsqlGetNotify(); 44 $db->exec("NOTIFY notifies_phpt"); 51 $db->exec("NOTIFY notifies_phpt"); [all …]
|
H A D | bug68199.phpt | 10 $db = PDOTest::factory(); 23 $pid = $db->pgsqlGetPid(); 27 var_dump($db->pgsqlGetNotify()); 30 $db->exec("LISTEN notifies_phpt"); 31 var_dump($db->pgsqlGetNotify()); 35 $db->exec("NOTIFY notifies_phpt, 'payload'"); 36 $notify = $db->pgsqlGetNotify(); 44 $db->exec("NOTIFY notifies_phpt, 'payload'"); 45 $notify = $db->pgsqlGetNotify(); 52 $db->exec("NOTIFY notifies_phpt, 'payload'"); [all …]
|
H A D | copy_from.phpt | 40 $db->beginTransaction(); 47 $db->rollback(); 50 $db->beginTransaction(); 56 $db->rollback(); 65 $db->rollback(); 74 $db->rollback(); 84 $db->rollback(); 93 $db->rollback(); 102 $db->rollback(); 111 $db->rollback(); [all …]
|
H A D | is_in_transaction.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 19 $db->beginTransaction(); 22 var_dump($db->inTransaction()); 29 $db->commit(); 32 var_dump($db->inTransaction()); 34 $db->beginTransaction(); 44 var_dump($db->inTransaction()); 45 $db->rollBack(); [all …]
|
/PHP-5.6/ext/pgsql/tests/ |
H A D | 32nb_async_query.phpt | 14 $db = pg_connect($conn_str); 16 $version = pg_version($db); 22 $db_socket = pg_socket($db); 29 nb_flush($db, $db_socket); 32 nb_consume($db, $db_socket); 34 if (!($result = pg_get_result($db))) { 54 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 67 nb_flush($db, $db_socket); 70 nb_consume($db, $db_socket); 72 if (!($result = pg_get_result($db))) { [all …]
|
H A D | 01createdb.phpt | 2 PostgreSQL create db 11 $db = pg_connect($conn_str); 12 if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name))) 14 pg_query($db,$table_def); // Create table here 16 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');"); 24 if (version_compare($v['server'], '9.2', '>=') && !@pg_num_rows(@pg_query($db, "SELECT * FROM ".$ta… 26 pg_query($db,$table_def_92); // Create table here 33 pg_query($db,$view_def); 35 pg_close($db);
|
H A D | 30nb_async_query_params.phpt | 14 $db = pg_connect($conn_str); 16 $version = pg_version($db); 22 $db_socket = pg_socket($db); 25 $sent = pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)); 29 nb_flush($db, $db_socket); 32 nb_consume($db, $db_socket); 34 if (!($result = pg_get_result($db))) { 53 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 54 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 67 nb_flush($db, $db_socket); [all …]
|
/PHP-5.6/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_createcollation.phpt | 8 $db = new pdo('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 11 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)'); 13 $db->query('INSERT INTO foobar VALUES (NULL, "1")'); 14 $db->query('INSERT INTO foobar VALUES (NULL, "2")'); 15 $db->query('INSERT INTO foobar VALUES (NULL, "10")'); 17 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); 19 $result = $db->query('SELECT name FROM foobar ORDER BY name COLLATE MYCOLLATE'); 24 $result = $db->query('SELECT name FROM foobar ORDER BY name'); 29 $db->query('DROP TABLE foobar');
|
H A D | pdo_sqlite_lastinsertid.phpt | 8 $db = new pdo('sqlite::memory:'); 9 $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)'); 10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")'); 11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")'); 12 var_dump($db->query('SELECT * FROM foo')); 13 var_dump($db->errorInfo()); 14 var_dump($db->lastInsertId()); 16 $db->query('DROP TABLE foo');
|
/PHP-5.6/ext/dba/tests/ |
H A D | bug36436.phpt | 14 $db = dba_popen($db_filename, 'c', 'db4'); 16 dba_insert('X', 'XYZ', $db); 17 dba_insert('Y', '123', $db); 19 var_dump($db, dba_fetch('X', $db)); 21 var_dump(dba_firstkey($db)); 22 var_dump(dba_nextkey($db)); 24 dba_close($db);
|