/PHP-5.3/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_prefetch_2.phpt | 16 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 10… 18 echo "Test 1: Can't set prefetch after prepare\n"; 22 $s = $dbh->prepare("select dummy from dual" ); 29 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 0)… 30 $s = $dbh->prepare("select dummy from dual" ); 40 Test 1: Can't set prefetch after prepare
|
/PHP-5.3/ext/sqlite3/tests/ |
H A D | sqlite3_prepare_faultystmt.phpt | 2 SQLite3::prepare test, testing for faulty statement 14 $stmt = $db->prepare('SELECT foo FROM bar'); 19 Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: bar in %s on line %d
|
H A D | sqlite3_prepare_wrongparams.phpt | 2 SQLite3::prepare test, testing for wrong parameters 15 $stmt = $db->prepare(); 19 Warning: SQLite3::prepare() expects exactly 1 parameter, 0 given in %s on line %d
|
H A D | sqlite3_prepare_with_empty_string.phpt | 2 SQLite3::prepare test with empty string argument 11 var_dump($db->prepare(''));
|
H A D | sqlite3_35_stmt_readonly.phpt | 24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 28 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?"); 32 $stmt = $db->prepare("DELETE FROM test");
|
/PHP-5.3/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native_mixed_style.phpt | 2 MySQL PDO->prepare(), native PS, mixed, wired style 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… 35 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional para… 37 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number in %s on line %d
|
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 2 MySQL PDO->prepare(), native PS, named placeholder II 26 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES (1, :placeholder, :placeholder)'… 35 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 1'); 45 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES(2, :placeholder, :placeholder)'); 54 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 2'); 67 $stmt = $db->prepare($sql); 81 $stmt = $db->prepare($sql);
|
H A D | pdo_mysql_prepare_native_column.phpt | 2 MySQL PDO->prepare(), native PS, named placeholder 20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1"); 24 $db->prepare('SELECT :placeholder FROM test WHERE :placeholder > :placeholder');
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 2 MySQL PDO->prepare(), native PS, clear line after error 28 $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC'); 35 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC'); 48 $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC'); 55 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC'); 94 Warning: PDO::prepare(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown_column' in…
|
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 2 MySQL PDO->prepare(), emulated PS, anonymous placeholder 23 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')"); 31 $stmt = $db->prepare('SELECT id, label FROM test'); 42 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')"); 50 $stmt = $db->prepare('SELECT id, label FROM test');
|
H A D | bug_pecl_12925.phpt | 21 $stmt = $db->prepare("UPDATE test SET id = 'b'"); 23 $stmt = $db->prepare("UPDATE test SET id = 'c'"); 25 $stmt = $db->prepare('SELECT id FROM test');
|
H A D | bug_61207.phpt | 18 $handle1 = $link->prepare('insert into bug61207(id) values(1); 34 $handle2 = $link->prepare('select * from bug61207 where id = ?; 50 $handle3 = $link->prepare('update bug61207 set id = 2 where id = ?; 66 $handle4 = $link->prepare('insert into bug61207(id) values(3);
|
H A D | pdo_mysql_prepare_native_named_placeholder.phpt | 2 MySQL PDO->prepare(), native PS, named placeholder 25 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES (100, ':placeholder')"); 38 $stmt = $db->prepare('SELECT id, label FROM test'); 48 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(101, ':placeholder')"); 58 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id');
|
H A D | bug44327.phpt | 15 $stmt = $db->prepare("SELECT 1 AS \"one\""); 28 $stmt = $db->prepare("SELECT id FROM test"); 37 $stmt = $db->prepare('foo');
|
H A D | pdo_mysql_prepare_match_against.phpt | 20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 22 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 45 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 108 Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.ihopeitdoesn…
|
H A D | pdo_mysql_prepare_native.phpt | 2 MySQL PDO->prepare(), native PS 20 $stmt = @$db->prepare($query); 22 $stmt = $db->prepare($query); 24 if (is_array($error_info) && isset($error_info['prepare'])) { 27 if (isset($error_info['prepare']['sqlstate']) && 28 ($error_info['prepare']['sqlstate'] !== $tmp[0])) { 30 $offset, $error_info['prepare']['sqlstate'], $tmp[0]); 34 if (isset($error_info['prepare']['mysql']) && 35 ($error_info['prepare']['mysql'] !== $tmp[1])) { 37 $offset, $error_info['prepare']['mysql'], $tmp[0]); [all …]
|
/PHP-5.3/ext/pdo_firebird/tests/ |
H A D | rowCount.phpt | 21 $stmt = $dbh->prepare($query); 28 $stmt = $dbh->prepare('UPDATE testZ SET A="A" WHERE A != ?'); 33 $stmt = $dbh->prepare('DELETE FROM testz');
|
/PHP-5.3/ext/interbase/tests/ |
H A D | 006.phpt | 40 /* prepare data */ 110 /* prepare data */ 177 echo "prepare and exec insert\n"; 179 /* prepare table */ 182 /* prepare query */ 194 echo "prepare and exec select\n"; 196 /* prepare query */ 237 prepare and exec insert 250 prepare and exec select
|
/PHP-5.3/ext/pdo/ |
H A D | pdo.php | 11 $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES (:name, :value)"); 47 $stmt = $x->prepare("select NAME, VALUE from test where value like ?");
|
/PHP-5.3/ext/mysqli/tests/ |
H A D | mysqli_stmt_attr_set.phpt | 47 $stmt->prepare("SELECT * FROM test"); 77 $stmt->prepare("SELECT label FROM test"); 93 $stmt->prepare("SELECT label FROM test"); 113 $stmt->prepare("SELECT label FROM test"); 148 $stmt->prepare("SELECT id, label FROM test"); 168 $stmt->prepare("SELECT id, label FROM test"); 180 $stmt->prepare("SELECT id, label FROM test"); 197 $stmt->prepare("SELECT id, label FROM test"); 223 $stmt->prepare("SELECT id, label FROM test"); 238 $stmt->prepare("SELECT label FROM test"); [all …]
|
/PHP-5.3/ext/pdo/tests/ |
H A D | bug_40285.phpt | 2 PDO Common: Bug #40285 (The prepare parser goes into an infinite loop on ': or ":) 21 $s = $db->prepare("INSERT INTO test VALUES( ':id', 'name', 'section', 22)" );
|
H A D | pdo_021.phpt | 23 $select = $db->prepare('SELECT COUNT(id) FROM test'); 36 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 45 $stmt2 = $db->prepare("INSERT INTO test VALUES(:first, :second, :third)");
|
/PHP-5.3/ext/pdo_sqlite/tests/ |
H A D | bug33841.phpt | 14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )"); 19 $stmt = $db->prepare("UPDATE test SET text = :text ");
|
/PHP-5.3/ext/pdo_pgsql/tests/ |
H A D | bug_49985.phpt | 2 Bug #49985 (pdo_pgsql prepare() re-use previous aborted transaction) 21 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)");
|