/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_columncount.phpt | 25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test"); 26 $stmt->execute(); 27 var_dump($stmt->columnCount()); 29 $stmt = $db->query('SELECT * FROM test'); 30 var_dump($stmt->columnCount()); 43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test"); 44 $stmt->execute(); 45 var_dump($stmt->columnCount()); 47 $stmt = $db->query('SELECT * FROM test'); 48 var_dump($stmt->columnCount());
|
H A D | pdo_mysql_stmt_errorcode.phpt | 23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 24 $stmt->execute(); 25 var_dump($stmt->errorCode()); 39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 40 $stmt->execute(); 41 var_dump($stmt->errorCode());
|
H A D | pdo_mysql_stmt_unbuffered_2050.phpt | 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 48 $stmt = PDO::query(<some query>) 52 $stmt->fetchAll() 56 $stmt = PDO::query(<some query>) 63 $stmt = PDO::query(<some query>) 68 current value of stmt: 78 PDO to $stmt. 91 $stmt->execute(); 95 $stmt->execute(); 98 unset($stmt); [all …]
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 65 $stmt->execute(); 79 $stmt->execute(); 92 $stmt->execute(); 93 check_result(11, $stmt, 1); 94 $stmt->execute(); 95 check_result(12, $stmt, 2); 97 $stmt->execute(); 98 check_result(13, $stmt, 1); 108 $stmt->execute(); 110 $stmt->execute(); [all …]
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 35 $stmt->bindparam(':id', $id); 36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 37 $stmt->execute(); 45 $stmt->bindparam(':id', $id); 46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 47 $stmt->execute();
|
H A D | bug54379.phpt | 24 $stmt = $db->prepare("SELECT * FROM test"); 25 $stmt->execute(); 26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_oci_attr_action.phpt | 18 $stmt = $dbh->query($query); 19 $row = $stmt->fetch(); 25 $stmt = $dbh->query($query); 26 $row = $stmt->fetch(); 32 $stmt = $dbh->query($query); 33 $row = $stmt->fetch(); 39 $stmt = $dbh->query($query); 40 $row = $stmt->fetch();
|
H A D | pdo_oci_attr_client_info.phpt | 18 $stmt = $dbh->query($query); 19 $row = $stmt->fetch(); 25 $stmt = $dbh->query($query); 26 $row = $stmt->fetch(); 32 $stmt = $dbh->query($query); 33 $row = $stmt->fetch(); 39 $stmt = $dbh->query($query); 40 $row = $stmt->fetch();
|
H A D | pdo_oci_fread_1.phpt | 30 foreach ($stmtarray as $stmt) { 31 $dbh->exec($stmt); 53 foreach ($stmtarray as $stmt) { 54 $dbh->exec($stmt);
|
H A D | pdo_oci_quote1.phpt | 17 $stmt = $db->prepare('select * from poq_tab'); 33 $stmt->execute(); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_oci_stmt_getcolumnmeta.phpt | 41 $stmt->execute(); 66 $stmt->execute(); 67 $native = $stmt->getColumnMeta(0); 77 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 138 $stmt = $db->prepare($sql); 139 $stmt->execute(); 148 $stmt->execute(); 149 $meta = $stmt->getColumnMeta(1); 221 $meta = $stmt->getColumnMeta(0); 234 $stmt = $db->prepare($sql); [all …]
|
H A D | pdo_oci_stream_1.phpt | 26 foreach ($stmtarray as $stmt) { 27 $dbh->exec($stmt); 82 foreach ($stmtarray as $stmt) { 83 $dbh->exec($stmt);
|
H A D | pdo_oci_stream_2a.phpt | 18 $stmt = $db->prepare($query); 19 $stmt->execute(); 22 $stmt = $db->prepare($query); 23 $stmt->execute(); 28 …$stmt = $db->prepare("insert into pdo_oci_stream_2 (id, data1, data2) values (:id, empty_blob(), e… 29 $stmt->bindParam(':id', $id); 30 $stmt->bindParam(':blob1', $blob1, PDO::PARAM_LOB); 31 $stmt->bindParam(':blob2', $blob2, PDO::PARAM_LOB); 34 $stmt->execute();
|
H A D | pdo_oci_templob_1.phpt | 27 $stmt->execute(); 28 $row = $stmt->fetch(); 30 $stmt->execute(); 33 $stmt->execute(); 36 $stmt->execute(); 39 $stmt->execute(); 42 $stmt->execute(); 45 $stmt->execute(); 48 $stmt->execute(); 51 $stmt->execute(); [all …]
|
H A D | pecl_bug_6364.phpt | 21 $stmt = $dbh->prepare("call bug_6364_sp('p1','p2','p3',?,?)"); 26 $stmt->bindParam(1, $out_param1,PDO::PARAM_STR, 1024); 27 $stmt->bindParam(2, $out_param2,PDO::PARAM_STR, 1024); 29 $stmt->execute() or die ("Execution error: " . var_dump($dbh->errorInfo()));
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug70861.phpt | 35 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => P… 37 $stmt->bindparam(':foo', $f, PDO::PARAM_LOB); 38 $stmt->execute();
|
H A D | bug71885.phpt | 22 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\''); 23 $stmt->execute(); 28 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\''); 29 $stmt->execute(); 31 var_dump($stmt->fetch());
|
H A D | bug71885_2.phpt | 30 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?"); 31 $stmt->execute(['b']); 32 var_dump($stmt->fetch()); 34 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???"); 35 $stmt->execute(['a']); 36 var_dump($stmt->fetch());
|
H A D | copy_from.phpt | 43 $stmt = $db->query("select * from test"); 44 foreach($stmt as $r) { 52 $stmt = $db->query("select * from test"); 53 foreach($stmt as $r) { 61 $stmt = $db->query("select * from test"); 62 foreach($stmt as $r) { 80 $stmt = $db->query("select * from test"); 81 foreach($stmt as $r) { 89 $stmt = $db->query("select * from test"); 90 foreach($stmt as $r) { [all …]
|
H A D | bug36727.phpt | 16 $stmt = $db->prepare('SELECT * FROM child'); 17 var_dump($stmt->bindValue(':test', 1, PDO::PARAM_INT));
|
H A D | bug43925.phpt | 31 $stmt = $dbh->prepare(' 41 $stmt->bindValue('left', 1, PDO::PARAM_INT); 42 $stmt->bindValue('rootId', 3, PDO::PARAM_INT); 43 $stmt->bindValue('x', 5, PDO::PARAM_INT); 44 $stmt->bindValue('y', 50, PDO::PARAM_INT); 46 $stmt->execute(); 48 foreach ($stmt->fetchAll() as $row) {
|
H A D | bug46274.phpt | 24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)"); 31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 32 $stmt->execute(); 35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 36 $stmt->execute(); 43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 44 $stmt->execute(); 47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 48 $stmt->execute();
|
H A D | bug46274_2.phpt | 24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)"); 31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 32 $stmt->execute(); 35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 36 $stmt->execute(); 43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 44 $stmt->execute(); 47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 48 $stmt->execute();
|
H A D | bug48764.phpt | 54 $stmt = $db->prepare("SELECT ?", $options); 55 $stmt->execute(array(1));
|
H A D | bug66584.phpt | 49 $stmt = $pdo->prepare("SELECT COUNT(*) FROM b66584 WHERE a IN ({$bind})"); 53 $stmt->execute($data); 55 var_dump($stmt->fetchColumn());
|