/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_007.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES('A', 'A')"); 19 $db->exec("INSERT INTO test VALUES('B', 'A')"); 20 $db->exec("INSERT INTO test VALUES('C', 'C')"); 22 $stmt = $db->prepare('SELECT id, val from test');
|
H A D | pdo_020.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')"); 24 $stmt = $db->query($sql);
|
H A D | bug65946.phpt | 15 $db = PDOTest::factory(); 16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); 17 $db->exec('CREATE TABLE test(id int)'); 18 $db->exec('INSERT INTO test VALUES(1)'); 19 $stmt = $db->prepare('SELECT * FROM test LIMIT :limit');
|
H A D | pdo_027.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('create table test (id int, name varchar(10))'); 18 $db->exec("INSERT INTO test (id,name) VALUES(1,'test1')"); 19 $db->exec("INSERT INTO test (id,name) VALUES(2,'test2')"); 21 foreach ($db->query("SELECT * FROM test", PDO::FETCH_LAZY) as $v) {
|
H A D | bug_35671.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE test (field1 VARCHAR(32), field2 VARCHAR(32), field3 VARCHAR(32))'); 18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 20 $insert = $db->prepare("insert into test (field1, field2, field3) values (:value1, :value2, :value3… 31 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_32_last_insert_rowid_param.phpt | 11 $db = new SQLite3(':memory:'); 14 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 17 var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)')); 21 $db->lastInsertRowID(""); 27 var_dump($db->close());
|
H A D | sqlite3_prepare_wrongparams.phpt | 11 $db = new SQLite3(':memory:'); 12 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); 13 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); 15 $stmt = $db->prepare();
|
H A D | sqlite3_14_querysingle.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->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 19 var_dump($db->querySingle("SELECT id FROM test WHERE id = 'a'")); 20 var_dump($db->querySingle("SELECT id, time FROM test WHERE id = 'a'", true));
|
H A D | sqlite3_21_security.phpt | 10 $file = uniqid() . '.db'; 13 $db = new SQLite3($directory . $file); 14 var_dump($db); 15 var_dump($db->close()); 20 $db = new SQLite3('../bad' . $file);
|
H A D | sqlite3_prepared_stmt_clear_with_params.phpt | 10 $db = new SQLite3(':memory:'); 13 $db->exec('CREATE TABLE test (time INTEGER, id STRING)'); 15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 18 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 21 var_dump($db->close());
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | mysqli_pconn_twice.phpt | 19 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 21 $host, $user, $db, $port, $socket); 23 if (true !== ($tmp = my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket))) 37 if (!$link = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) 39 $host, $user, $db, $port, $socket); 42 if (true !== ($tmp = $link->real_connect($host, $user, $passwd, $db, $port, $socket))) 56 if (NULL !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket))) 59 if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 61 $host, $user, $db, $port, $socket); 63 if (NULL !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket)))
|
H A D | 049.phpt | 14 $mysql = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 16 $mysql->select_db($db); 22 if ($row[0] != $db) 23 printf("[001] Expecting '%s' got '%s'\n", $db, $row[0]);
|
/PHP-5.5/ext/mysql/tests/ |
H A D | mysql_select_db.phpt | 18 if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) 20 $host, $user, $db, $port, $socket); 22 if (!is_null($tmp = @mysql_select_db($db, $link, "foo"))) 25 /* does not make too much sense, unless we have access to at least one more database than $db */ 26 if (!mysql_select_db($db, $link)) 27 printf("[004] Cannot select DB %s, [%d] %s\n", $db, mysql_errno($link), mysql_error($link)); 35 if ($row['dbname'] !== (string)$db) 36 printf("[007] Expecting database '%s', found '%s'\n", $db, $row['dbname']); 44 // ($db) was done by mysql__connect() already and the previous test 63 if (false !== ($tmp = mysql_select_db($db, $link)))
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | bug66141.phpt | 12 $db = MySQLPDOTest::factory(); 16 $quotedInput0 = $db->quote($input); 18 $db->query('set session sql_mode="NO_BACKSLASH_ESCAPES"'); 22 $quotedInput1 = $db->quote($input); 24 $db->query('something that throws an exception'); 26 $quotedInput2 = $db->quote($input);
|
H A D | pdo_mysql___construct_options_libmysql.phpt | 22 $db = new PDO($dsn, $user, $pass, array($option => $value)); 23 if (!is_object($db) || (!$ignore_diff && ($value !== ($tmp = @$db->getAttribute($option))))) 53 $db = new PDO($dsn, $user, $pass); 56 $tmp = @$db->getAttribute($option); 74 (is_object($db)) ? $db->errorCode() : 'n/a', 75 (is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a');
|
H A D | bug_41698.phpt | 14 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 18 $db->exec('CREATE TABLE test(floatval DECIMAL(8,6))'); 19 $db->exec('INSERT INTO test VALUES(2.34)'); 21 $stmt = $db->prepare('INSERT INTO test VALUES(?)'); 23 var_dump($db->query('SELECT * from test')->fetchAll(PDO::FETCH_ASSOC));
|
H A D | last_insert_id.phpt | 13 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 15 print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)")); 17 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)")); 19 print_r($db->query("INSERT INTO test (num) VALUES (451)")); 21 print_r($db->lastInsertId());
|
H A D | pdo_mysql_attr_connection_status.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 $status = $db->getAttribute(PDO::ATTR_CONNECTION_STATUS); 27 if (false !== $db->setAttribute(PDO::ATTR_CONNECTION_STATUS, 'my own connection status')) 30 $status2 = $db->getAttribute(PDO::ATTR_CONNECTION_STATUS);
|
/PHP-5.5/ext/pgsql/tests/ |
H A D | 03sync_query.phpt | 10 $db = pg_connect($conn_str); 12 $result = pg_query($db, "SELECT * FROM ".$table_name.";"); 55 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 56 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); 64 $result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');"); 68 pg_close($db);
|
H A D | 14pg_update_9.phpt | 14 $db = pg_connect($conn_str); 15 pg_query($db, "SET standard_conforming_strings = 0"); 20 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n"; 21 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
|
H A D | 18pg_escape_bytea_before.phpt | 14 $db = pg_connect($conn_str); 15 @pg_query($db, "SET bytea_output = 'escape'"); 17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');'); 18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
H A D | 18pg_escape_bytea_esc.phpt | 11 $db = pg_connect($conn_str); 12 @pg_query($db, "SET bytea_output = 'escape'"); 17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
H A D | 18pg_escape_bytea_hex.phpt | 14 $db = pg_connect($conn_str); 15 @pg_query($db, "SET bytea_output = 'hex'"); 20 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 21 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
/PHP-5.5/ext/sybase_ct/tests/ |
H A D | test_unbuffered_no_full_fetch.phpt | 14 $db= sybase_connect_ex(); 15 var_dump($db); 18 $q= sybase_unbuffered_query('select name from master..systypes', $db); 22 $q= sybase_unbuffered_query('select name from master..systypes', $db); 27 $q= sybase_unbuffered_query('select name from master..systypes', $db); 31 sybase_close($db);
|
H A D | bug28354.phpt | 14 $db= sybase_connect_ex(); 20 var_dump(sybase_select_db(TEMPDB, $db)); 21 if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) { 33 $r= sybase_query('exec '.$sp_name, $db); 39 sybase_close($db);
|