1--TEST--
2PDO_Firebird: rowCount
3--SKIPIF--
4<?php require('skipif.inc'); ?>
5--ENV--
6LSAN_OPTIONS=detect_leaks=0
7--FILE--
8<?php
9
10require("testdb.inc");
11
12@$dbh->exec('DROP TABLE testz');
13$dbh->exec('CREATE TABLE testz (A VARCHAR(10))');
14$dbh->exec("INSERT INTO testz VALUES ('A')");
15$dbh->exec("INSERT INTO testz VALUES ('A')");
16$dbh->exec("INSERT INTO testz VALUES ('B')");
17$dbh->commit();
18
19$query = "SELECT * FROM testz WHERE A = ?";
20
21$stmt = $dbh->prepare($query);
22$stmt->execute(array('A'));
23$rows = $stmt->fetch();
24$rows = $stmt->fetch();
25var_dump($stmt->fetch());
26var_dump($stmt->rowCount());
27
28$stmt = $dbh->prepare('UPDATE testZ SET A="A" WHERE A != ?');
29$stmt->execute(array('A'));
30var_dump($stmt->rowCount());
31$dbh->commit();
32
33$stmt = $dbh->prepare('DELETE FROM testz');
34$stmt->execute();
35var_dump($stmt->rowCount());
36
37$dbh->commit();
38
39$dbh->exec('DROP TABLE testz');
40
41unset($stmt);
42unset($dbh);
43
44?>
45--EXPECT--
46bool(false)
47int(2)
48int(1)
49int(3)
50