/php-src/ext/pgsql/tests/ |
H A D | 09notice.phpt | 21 $db = pg_connect($conn_str); 23 _set_lc_messages($db); 29 var_dump(pg_last_notice($db)); 30 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL)); 32 pg_query($db, "BEGIN;"); 33 pg_query($db, "BEGIN;"); 34 pg_query($db, "BEGIN;"); 35 pg_query($db, "BEGIN;"); 38 var_dump(pg_last_notice($db)); 39 var_dump(pg_last_notice($db, PGSQL_NOTICE_ALL)); [all …]
|
H A D | 30nb_async_query_params.phpt | 16 $db = pg_connect($conn_str); 17 pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 18 pg_query($db, "INSERT INTO {$table_name} (num) VALUES(1000)"); 20 $db_socket = pg_socket($db); 27 nb_flush($db, $db_socket); 30 nb_consume($db, $db_socket); 32 if (!($result = pg_get_result($db))) { 65 nb_flush($db, $db_socket); 71 pg_close($db); 80 $db = pg_connect($conn_str); [all …]
|
H A D | bug77047.phpt | 16 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} ( 23 pg_insert($db, $table_name, array("t" => "13:31")); 27 pg_insert($db, $table_name, array("t" => "13:31:13")); 28 pg_insert($db, $table_name, array("t" => "1:2:3")); 30 pg_insert($db, $table_name, array("t" => "xyz")); 34 pg_insert($db, $table_name, array("t" => NULL)); 35 pg_insert($db, $table_name, array("t" => "")); 37 $res = pg_query($db, "SELECT t FROM {$table_name}"); 48 $db = pg_connect($conn_str); [all …]
|
H A D | 25async_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 if (!pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))) { 22 while(pg_connection_busy($db)); // busy wait: intended 23 if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 26 if (!($result = pg_get_result($db))) 50 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 66 pg_close($db); 75 $db = pg_connect($conn_str); [all …]
|
H A D | bug37100_9.phpt | 16 $db = pg_connect($conn_str); 18 pg_query($db, "CREATE TABLE {$table_name} (binfield byteA) ;"); 19 pg_query($db, "INSERT INTO {$table_name} VALUES (decode('0103AA000812','hex'))"); 22 $data = pg_query($db, "SELECT binfield FROM {$table_name}"); 29 $data = pg_query($db, $sql); 35 pg_close($db); 37 $db = pg_connect($conn_str); 38 pg_close($db); 47 $db = pg_connect($conn_str); 48 pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
|
H A D | 24sync_query_prepared.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_prepare($db, "php_test", "SELECT * FROM ".$table_name." WHERE num > \$1;"); 22 $result = pg_execute($db, "php_test", array(100)); 45 pg_num_rows(pg_execute($db, "php_test", array(100))); 46 pg_num_fields(pg_execute($db, "php_test", array(100))); 57 $result = pg_execute($db, "php_test2", array(9999, "A'BC")); 61 pg_close($db); 70 $db = pg_connect($conn_str); [all …]
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_anonymous_placeholders.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $stmt = @$db->prepare($query); 21 $stmt = $db->prepare($query); 24 $tmp = $db->errorInfo(); 78 $db->errorCode(), implode(' ', $db->errorInfo())); 86 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 87 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 91 prepex(3, $db, '', [], ['execute' => ['sqlstate' => '42000']]); 152 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table , $db); 29 MySQLPDOTest::createTestTable($table, $db); 31 $db->exec("DROP TABLE {$table}"); 34 var_dump($db->errorInfo()); 38 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); 50 MySQLPDOTest::createTestTable($table, $db); 53 $db->exec("DROP TABLE {$table}"); 56 var_dump($db->errorInfo()); 60 $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); [all …]
|
H A D | bug_39858.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 16 function bug_39858($db) { 20 $db->exec(" 30 $stmt = $db->prepare("CALL {$procedure}()"); 36 $stmt = $db->prepare("CALL {$procedure}()"); 45 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 46 bug_39858($db); 49 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 50 bug_39858($db); [all …]
|
H A D | pdo_mysql_quote.phpt | 13 $db = MySQLPDOTest::factory(); 15 var_dump($db->quote('foo', PDO::PARAM_STR)); 16 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); 17 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL)); 19 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_CHAR); 20 $db->setAttribute(PDO::ATTR_DEFAULT_STR_PARAM, PDO::PARAM_STR_NATL); 21 var_dump($db->getAttribute(PDO::ATTR_DEFAULT_STR_PARAM) === PDO::PARAM_STR_NATL); 23 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); 24 var_dump($db->quote('über', PDO::PARAM_STR)); 25 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL));
|
H A D | native_types.phpt | 15 $db = MySQLPDOTest::factory(); 16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 18 $db->exec('CREATE TABLE test_native_types (i INT, f FLOAT)'); 19 $db->exec('INSERT INTO test_native_types VALUES (42, 42.5)'); 21 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 22 var_dump($db->query('SELECT * FROM test_native_types')->fetchAll(PDO::FETCH_ASSOC)); 24 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 25 var_dump($db->query('SELECT * FROM test_native_types')->fetchAll(PDO::FETCH_ASSOC)); 30 $db = MySQLPDOTest::factory(); 31 $db->exec('DROP TABLE IF EXISTS test_native_types');
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 13 $db = MySQLPDOTest::factory(); 16 MySQLPDOTest::createTestTable($table, $db); 18 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, true); 19 var_dump($db->getAttribute(PDO::ATTR_FETCH_TABLE_NAMES)); 20 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1"); 24 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, false); 25 var_dump($db->getAttribute(PDO::ATTR_FETCH_TABLE_NAMES)); 26 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1"); 35 $db = MySQLPDOTest::factory(); 36 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_fetch_table_names');
|
H A D | pdo_mysql_attr_multi_statements.phpt | 22 $db = new PDO($dsn, $user, $pass); 23 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 24 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 27 $db->exec($create); 31 $info = $db->errorInfo(); 33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 36 $stmt = $db->query('SELECT 1 AS value;'); 42 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 45 $info = $db->errorInfo(); 51 $stmt = $db->query('SELECT 1 AS value;'); [all …]
|
H A D | pdo_mysql_stmt_multiquery.phpt | 16 function mysql_stmt_multiquery_wrong_usage($db) { 37 $db = MySQLPDOTest::factory(); 38 MySQLPDOTest::createTestTable($table, $db); 40 mysql_stmt_multiquery_wrong_usage($db); 41 mysql_stmt_multiquery_proper_usage($db); 44 $db = MySQLPDOTest::factory(); 45 MySQLPDOTest::createTestTable($table, $db); 47 mysql_stmt_multiquery_wrong_usage($db); 48 mysql_stmt_multiquery_proper_usage($db); 52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_multi_stmt_nextrowset.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 18 MySQLPDOTest::createTestTable($table, $db); 20 function test_proc($db) { 24 $db->exec("DROP PROCEDURE IF EXISTS {$procedure}"); 26 $stmt = $db->query("CALL {$procedure}()"); 47 test_proc($db); 55 test_proc($db); 64 $info = $db->errorInfo(); 69 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | bug_44707.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 16 function bug_44707($db) { 31 $stmt = $db->query('SELECT * FROM test_44707'); 40 $stmt = $db->query('SELECT * FROM test_44707'); 48 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 49 bug_44707($db); 53 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 54 bug_44707($db); 61 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_get_attribute.phpt | 13 $db = MySQLPDOTest::factory(); 15 function set_and_get($offset, $db, $attribute, $value) { 18 if (!$db->setAttribute($attribute, $value)) { 30 $tmp = $db->getAttribute($attribute); 39 $db->errorCode(), implode(' ', $db->errorInfo())); 46 set_and_get(1, $db, PDO::ATTR_AUTOCOMMIT, true); 48 set_and_get(2, $db, PDO::ATTR_AUTOCOMMIT, 0); 49 set_and_get(3, $db, PDO::ATTR_AUTOCOMMIT, -1); 51 set_and_get(4, $db, PDO::ATTR_AUTOCOMMIT, $obj); 53 set_and_get(5, $db, PDO::MYSQL_ATTR_LOCAL_INFILE, 1); [all …]
|
H A D | pdo_mysql___construct_options.phpt | 22 if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option)))) 71 printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db); 76 printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db); 82 $db = new PDO($dsn, $user, $pass); 86 $tmp = @$db->getAttribute($option); 94 if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 98 if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT)) 113 if (!is_object($db)) 122 if (!is_object($db)) 165 (is_object($db)) ? $db->errorCode() : 'n/a', [all …]
|
H A D | pdo_mysql_prepare_emulated.phpt | 13 $db = MySQLPDOTest::factory(); 14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $stmt = @$db->prepare($query); 21 $stmt = $db->prepare($query); 24 $tmp = $db->errorInfo(); 77 $db->errorCode(), implode(' ', $db->errorInfo())); 85 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 96 $stmt = prepex(4, $db, 'SELECT 1 AS "one"'); 153 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 161 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdomysql_003.phpt | 15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 16 if (!$db instanceof Pdo\Mysql) { 17 echo "Wrong class type. Should be Pdo\Mysql 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_odbc/tests/ |
H A D | autocommit.phpt | 18 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 19 $db->exec("CREATE TABLE {$table} (id INT, name VARCHAR(255))"); 20 unset($db); 22 $db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS'), [ 26 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1); 27 $db->query("INSERT INTO {$table} (id, name) VALUES (1, 'test')"); 28 unset($db); 30 $db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS')); 32 $r = $db->query("SELECT * FROM {$table}"); 40 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); [all …]
|
H A D | autocommit_change_mode.phpt | 19 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true); 20 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 24 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false); 25 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 29 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false); 34 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true); 41 $db->beginTransaction(); 61 $db->rollback(); 64 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false); 67 $db->beginTransaction(); [all …]
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | copy_from.phpt | 42 $db->beginTransaction(); 49 $db->rollback(); 52 $db->beginTransaction(); 58 $db->rollback(); 67 $db->rollback(); 76 $db->rollback(); 86 $db->rollback(); 95 $db->rollback(); 104 $db->rollback(); 113 $db->rollback(); [all …]
|
/php-src/ext/dba/tests/ |
H A D | bug36436.phpt | 13 $db_name = 'bug36436.db'; 15 $db = set_up_db_ex('db4', $db_name, LockFlag::DbLock, persistent: true); 17 var_dump($db, dba_fetch('key1', $db)); 19 var_dump(dba_firstkey($db)); 20 var_dump(dba_nextkey($db)); 22 dba_close($db); 28 $db_name = 'bug36436.db';
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_filename_uri.phpt | 9 $db = new PDO('sqlite:file::memory:?cache=shared'); 11 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);')); 14 $db = new PDO('sqlite:file::memory:?cache=shared'); 16 var_dump($db->exec('SELECT * from test_sqlite_filename_uri')); 19 $filename = "file:" . __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_filename_uri.db"; 21 $db = new PDO('sqlite:' . $filename); 23 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);')); 26 $filename = "file:" . __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_filename_uri.db?mode=ro"; 28 $db = new PDO('sqlite:' . $filename); 30 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri_2 (id INT);')); [all …]
|