/PHP-7.4/ext/pdo_mysql/tests/ |
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 | bug_61207.phpt | 18 $handle1 = $db->prepare('insert into test(id) values(1); 34 $handle2 = $db->prepare('select * from test where id = ?; 50 $handle3 = $db->prepare('update test set id = 2 where id = ?; 66 $handle4 = $db->prepare('insert into test(id) values(3);
|
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_stmt_errorcode.phpt | 23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 57 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 …]
|
H A D | bug_61755.phpt | 18 $s = $db->prepare("SELECT \"a\0b\", ?"); 26 $s = $db->prepare("SELECT /*");
|
/PHP-7.4/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 …]
|
H A D | ps_cursor_multiple_result_sets.phpt | 27 $stmt = $db->prepare("call testPs()"); 42 $stmt = $db->prepare("call testPs()"); 59 $stmt = $db->prepare("call testPs()");
|
H A D | mysqli_ps_select_union.phpt | 27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C… 47 The metadata mysqlnd has available after prepare is better than 52 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C… 83 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT … 103 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT … 132 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2"))) 152 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2"))) 173 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?"))) 192 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?"))) 213 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST(? AS CHAR) U… [all …]
|
H A D | bug66124.phpt | 34 $stmt = $link->prepare($table_insert); 36 printf("Can't prepare\n"); 68 $stmt = $link->prepare($table_insert);
|
/PHP-7.4/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 ");
|
H A D | bug78192.phpt | 13 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)'); 19 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id');
|
/PHP-7.4/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)");
|
H A D | pdo_028.phpt | 18 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)'); 27 $stmt = $db->prepare('SELECT * from test');
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug70313.phpt | 18 $stmt = $db->prepare(");"); 27 $stmt = $db->prepare(");");
|
H A D | bug71885.phpt | 22 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\''); 28 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
|
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 (?)");
|
H A D | large_objects.phpt | 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");
|
/PHP-7.4/ext/pdo_firebird/tests/ |
H A D | bug_62024.phpt | 21 $sttmt = $dbh->prepare($sql); 36 $sttmt = $dbh->prepare('DELETE FROM test_insert');
|
H A D | bug_47415.phpt | 21 $stmt = $dbh->prepare($query); 30 $stmt = $dbh->prepare('DELETE FROM testz');
|
H A D | bug_48877.phpt | 23 $stmt = $dbh->prepare($query); 31 $stmt = $dbh->prepare('DELETE FROM testz');
|
H A D | bug_64037.phpt | 22 $stmt = $dbh->prepare($query); 30 $stmt = $dbh->prepare('DELETE FROM price');
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | bug57702.phpt | 19 $stmt = $db->prepare($query); 23 $stmt = $db->prepare($query); 29 …$stmt = $db->prepare("insert into bug57702 (id, data1, data2) values (:id, empty_blob(), empty_blo… 52 $stmt = $db->prepare('select data1, data2 from bug57702 order by id'); 74 $stmt = $db->prepare('select data1 as d3_1, data2 as d3_2 from bug57702 order by id'); 143 $stmt = $db->prepare($query);
|