2 $dsn = 'sqlite::memory:';
7 catch (PDOException
$e)
9 die('Connection failed: ' . $e->getMessage());
12 $db->exec("CREATE TABLE test (x INT,z TEXT)");
13 $db->exec("INSERT INTO test VALUES (1,'one')");
14 $db->exec("INSERT INTO test VALUES (2,'two')");
15 $db->exec("INSERT INTO test VALUES (3,'three')");
17 /* Execute a prepared statement by passing an array of values */
18 $sth = $db->prepare('SELECT * FROM test WHERE x < :num', array(PDO
::ATTR_CURSOR
=> PDO
::CURSOR_FWDONLY
));
19 $sth->execute(array(':num' => 100));
20 foreach ($sth->fetchAll() as $row)
22 print $row['x'] . "\t" . $row['z'] . "\n";
25 $sth->execute(array('num' => 3));
26 foreach ($sth->fetchAll() as $row)
28 print $row['x'] . "\t" . $row['z'] . "\n";