Annotation of embedaddon/php/ext/pdo_firebird/tests/execute.phpt, revision 1.1.1.3
1.1 misho 1: --TEST--
2: PDO_Firebird: prepare/execute/binding
3: --SKIPIF--
4: <?php include("skipif.inc"); ?>
1.1.1.3 ! misho 5: <?php function_exists("ibase_query") or die("skip"); ?>
1.1 misho 6: --INI--
7: ibase.timestampformat=%Y-%m-%d %H:%M:%S
8: --FILE--
1.1.1.2 misho 9: <?php /* $Id$ */
1.1 misho 10:
11: require("testdb.inc");
12:
13: $db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
14:
15: var_dump($db->getAttribute(PDO::ATTR_CONNECTION_STATUS));
16:
17: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
18:
19: $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32),
20: datetime TIMESTAMP DEFAULT '2000-02-12' NOT NULL)");
21: $db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')");
22:
23: $s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
24:
25: $id = 0;
26: $s->bindParam(1,$id);
27: $var = null;
28: $s->bindColumn("TEXT",$var);
29: $id = 1;
30: $s->execute();
31: $s->setAttribute(PDO::ATTR_CURSOR_NAME, "c");
32:
33: var_dump($id);
34:
35: var_dump($s->fetch());
36:
37: var_dump($var);
38:
39: var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
40:
41: var_dump($s->fetch());
42:
43: unset($s);
44: unset($db);
45: echo "done\n";
46:
47: ?>
48: --EXPECT--
49: bool(true)
50: int(1)
51: array(6) {
52: ["ID"]=>
53: string(1) "1"
54: [0]=>
55: string(1) "1"
56: ["TEXT"]=>
57: string(3) "bla"
58: [1]=>
59: string(3) "bla"
60: ["DATETIME"]=>
61: string(19) "2000-02-12 00:00:00"
62: [2]=>
63: string(19) "2000-02-12 00:00:00"
64: }
65: string(3) "bla"
66: int(1)
67: bool(false)
68: done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>