1--TEST--
2PDO_Firebird: bug 48877 The "bindValue" and "bindParam" do not work for PDO Firebird if we use named parameters (:parameter).
3--SKIPIF--
4<?php require('skipif.inc'); ?>
5--ENV--
6LSAN_OPTIONS=detect_leaks=0
7--FILE--
8<?php
9
10require("testdb.inc");
11
12$value = '2';
13
14@$dbh->exec('DROP TABLE testz');
15$dbh->exec('CREATE TABLE testz (A integer)');
16$dbh->exec("INSERT INTO testz VALUES ('1')");
17$dbh->exec("INSERT INTO testz VALUES ('2')");
18$dbh->exec("INSERT INTO testz VALUES ('3')");
19$dbh->commit();
20
21$query = "SELECT * FROM testz WHERE A = :paramno";
22
23$stmt = $dbh->prepare($query);
24$stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
25$stmt->execute();
26$rows = $stmt->fetch();
27var_dump($stmt->fetch());
28var_dump($stmt->rowCount());
29
30
31$stmt = $dbh->prepare('DELETE FROM testz');
32$stmt->execute();
33
34$dbh->commit();
35
36$dbh->exec('DROP TABLE testz');
37
38unset($stmt);
39unset($dbh);
40
41?>
42--EXPECT--
43bool(false)
44int(1)
45