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->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
15@$dbh->exec('DROP TABLE testz');
16$dbh->exec('CREATE TABLE testz (A integer)');
17$dbh->exec("INSERT INTO testz VALUES ('1')");
18$dbh->exec("INSERT INTO testz VALUES ('2')");
19$dbh->exec("INSERT INTO testz VALUES ('3')");
20$dbh->commit();
21
22$query = "SELECT * FROM testz WHERE A = :paramno";
23
24$stmt = $dbh->prepare($query);
25$stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
26$stmt->execute();
27$rows = $stmt->fetch();
28var_dump($stmt->fetch());
29var_dump($stmt->rowCount());
30
31
32$stmt = $dbh->prepare('DELETE FROM testz');
33$stmt->execute();
34
35$dbh->commit();
36
37$dbh->exec('DROP TABLE testz');
38
39unset($stmt);
40unset($dbh);
41
42?>
43--EXPECT--
44bool(false)
45int(1)
46