/PHP-5.5/ext/phar/tests/files/ |
H A D | pear2coverage.phar.php | 927 protected $db; 937 $this->db = new \Sqlite3($path); 953 $this->db->exec(' 962 $this->db->exec('BEGIN'); 989 @$this->db->exec('ROLLBACK'); 1058 $this->db->exec('COMMIT'); 1300 …$this->db->exec('DELETE FROM xdebugs WHERE xdebugpath="' . $this->db->escapeString($xdebugpath) . … 1443 $this->db->exec($query); 1452 $this->db->exec($query); 1497 $this->db->exec('BEGIN'); [all …]
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_33_reset.phpt | 11 $db = new SQLite3(':memory:'); 13 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); 14 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 21 //var_dump($db); 22 //var_dump($db->close());
|
H A D | sqlite3_24_last_insert_rowid.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')")); 16 var_dump($db->lastInsertRowID()); 17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 18 var_dump($db->lastInsertRowID()); 21 var_dump($db->close());
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_attr_fetch_table_names.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 15 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 1); 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 20 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 0); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
|
H A D | pdo_mysql_attr_client_version.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION); 27 if (false !== $db->setAttribute(PDO::ATTR_CLIENT_VERSION, '1.0')) 30 $new_version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION);
|
H A D | pdo_mysql_stmt_rowcount.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 17 if (0 !== ($tmp = $db->query('SELECT id FROM test WHERE 1 = 0')->rowCount())) 20 if (1 !== ($tmp = $db->query('SELECT id FROM test WHERE id = 1')->rowCount())) 25 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdo_mysql_attr_statement_class.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 16 $default = $db->getAttribute(PDO::ATTR_STATEMENT_CLASS); 19 if (false !== ($tmp = @$db->setAttribute(PDO::ATTR_STATEMENT_CLASS))) 22 if (false !== ($tmp = @$db->setAttribute(PDO::ATTR_STATEMENT_CLASS, 'foo'))) 81 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS)); 82 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2'); 92 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2'); 98 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1'); [all …]
|
H A D | pdo_mysql_prepare_native_mixed_style.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 14 MySQLPDOTest::createTestTable($db); 16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 20 $stmt = $db->query('DELETE FROM test'); 21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)'); 23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
|
H A D | pecl_bug_5802.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt'); 15 $db->exec('create table test ( bar char(3) NULL )'); 16 $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo()); 30 $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo()); 40 $db = MySQLPDOTest::factory(); 41 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_subclass.phpt | 59 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 60 $db->exec('DROP TABLE IF EXISTS test'); 61 $db->exec('CREATE TABLE test(id INT)'); 62 $db->exec('INSERT INTO test(id) VALUES (1), (2)'); 63 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC'); 66 $db->intercept_call(); 71 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 74 $db->exec('DROP TABLE IF EXISTS test'); 80 $db = MySQLPDOTest::factory(); 81 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_attr_errmode.phpt | 8 $db = MySQLPDOTest::factory(); 15 $db = MySQLPDOTest::factory(); 45 $code = $db->errorCode(); 46 $info = $db->errorInfo(); 61 $code = $db->errorCode(); 62 $info = $db->errorInfo(); 80 $code = $db->errorCode(); 81 $info = $db->errorInfo(); 116 global $db, $line; 118 $code = $db->errorCode(); [all …]
|
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 22 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); 23 MySQLPDOTest::createTestTable($db); 25 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2'); 58 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 61 $db->exec('DROP TABLE IF EXISTS test');
|
/PHP-5.5/ext/pdo_firebird/tests/ |
H A D | execute.phpt | 13 $db = new PDO("firebird:dbname=$test_base",$user,$password) or die; 15 var_dump($db->getAttribute(PDO::ATTR_CONNECTION_STATUS)); 17 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 19 $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32), 21 $db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')"); 23 $s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE"); 39 var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c")); 44 unset($db);
|
/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_009.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); 18 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); 19 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); 20 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); 21 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))'); 22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\')'); 23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\')'); 24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\')'); 25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\')'); [all …]
|
H A D | pdo_019.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); 18 $db->exec('INSERT INTO test VALUES(0, \'String0\')'); 19 $db->exec('INSERT INTO test VALUES(1, \'String1\')'); 20 $db->exec('INSERT INTO test VALUES(2, \'String2\')'); 21 $db->exec('INSERT INTO test VALUES(3, \'String3\')'); 24 var_dump($db->query('SELECT COUNT(*) FROM test')->fetchColumn()); 26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
|
H A D | pdo_010.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); 18 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); 19 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); 20 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); 21 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCH… 22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')'); 23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')'); 24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')'); 25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')'); [all …]
|
H A D | bug_39656.phpt | 16 $db = PDOTest::factory(); 18 @$db->exec("DROP TABLE test"); 19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 21 $db->exec("CREATE TABLE test (id INTEGER NOT NULL PRIMARY KEY, usr VARCHAR( 256 ) NOT NULL)"); 22 $db->exec("INSERT INTO test (id, usr) VALUES (1, 'user')"); 24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?"); 35 @$db->exec("DROP TABLE test");
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | copy_to.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(); 35 $db->commit(); 38 var_dump($db->pgsqlCopyToArray('test')); 40 var_dump($db->pgsqlCopyToArray('test',";","NULL")); 42 var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c')); 45 var_dump($db->pgsqlCopyToArray('test_error')); 51 var_dump($db->pgsqlCopyToFile('test',$filename)); [all …]
|
H A D | large_objects.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(); 20 $oid = $db->pgsqlLOBCreate(); 22 $stm = $db->pgsqlLOBOpen($oid, 'w+b'); 25 $stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)"); 36 $stmt = $db->prepare("SELECT * from test"); 47 $stmt = $db->prepare("SELECT * from test"); 58 $stmt = $db->prepare("SELECT * from test"); [all …]
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | bug38710.phpt | 12 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket); 13 $qry=$db->stmt_init(); 18 …at('a', ($IS_MYSQLND || mysqli_get_server_version($db) > 50110)? 100000:(mysqli_get_server_version…
|
H A D | mysqli_change_user_old.phpt | 9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 11 $host, $user, $db, $port, $socket)); 38 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 40 $host, $user, $db, $port, $socket); 57 $host, $user, $db, $port, $socket); 69 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 79 if ($tmp['dbname'] != $db) 93 $host, $user, $db, $port, $socket); 103 $host, $user, $db, $port, $socket); 107 (empty db = no db send with COM_CHANGE_USER) */ [all …]
|
/PHP-5.5/ext/pdo_oci/tests/ |
H A D | bug46274_2.phpt | 13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 19 $db->exec("DROP TABLE test_one_blob"); 23 $db->beginTransaction(); 25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)'); 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 49 $res = $db->query("SELECT blob1 from test_one_blob"); 60 $db->exec("DROP TABLE test_one_blob");
|
/PHP-5.5/ext/pgsql/tests/ |
H A D | 23sync_query_params.phpt | 13 $db = pg_connect($conn_str); 15 $version = pg_version($db); 17 $result = pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)); 40 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 41 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))); 49 …$result = pg_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC… 54 pg_close($db);
|
H A D | 06copy.phpt | 10 $db = pg_connect($conn_str); 12 $rows = pg_copy_to($db, $table_name); 14 pg_query($db, "DELETE FROM $table_name"); 16 pg_copy_from($db, $table_name, $rows);
|
/PHP-5.5/ext/sybase_ct/tests/ |
H A D | test_close.phpt | 14 $db= sybase_connect_ex(); 15 var_dump($db); 16 sybase_close($db); 17 var_dump($db); 18 var_dump(sybase_query('select getdate()', $db));
|