impl/pdo.php

   1 <?php
   2 $dsn = 'sqlite::memory:';
   3
   4 try {
   5     $db = new PDO($dsn);
   6 }
   7 catch (PDOException $e)
   8 {
   9     die('Connection failed: ' . $e->getMessage());
  10 }
  11
  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')");
  16
  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)
  21 {
  22   print $row['x'] . "\t" . $row['z'] . "\n";
  23 }
  24 print "\n";
  25 $sth->execute(array('num' => 3));
  26 foreach ($sth->fetchAll() as $row)
  27 {
  28   print $row['x'] . "\t" . $row['z'] . "\n";
  29 }
  30 ?>