diff options
Diffstat (limited to 'ext/pdo/pdo.php')
-rwxr-xr-x | ext/pdo/pdo.php | 62 |
1 files changed, 0 insertions, 62 deletions
diff --git a/ext/pdo/pdo.php b/ext/pdo/pdo.php deleted file mode 100755 index 1008f7bd04..0000000000 --- a/ext/pdo/pdo.php +++ /dev/null @@ -1,62 +0,0 @@ -<?php -dl('pdo.so'); -dl('pdo_sqlite.so'); - -//$x = new PDO("oci:dbname=hostname", 'php', 'php'); -$x = new PDO("sqlite::memory:"); - -$x->query("create table test(name string, value string)"); -debug_zval_dump($x); - -$stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES (:name, :value)"); - -$stmt->bindParam(":name", $the_name, PDO_PARAM_STR, 32); -$stmt->bindParam(":value", $the_value, PDO_PARAM_STR, 32); - -for ($i = 0; $i < 4; $i++) { - $the_name = "foo" . rand(); - $the_value = "bar" . rand(); - - if (!$stmt->execute()) { - break; - } -} - -$stmt = null; - -echo "DEFAULT:\n"; -foreach ($x->query("select NAME, VALUE from test") as $row) { - print_r($row); -} - -echo "OBJ:\n"; - -class Foo { - public $NAME = "Don't change me"; -} - -$foo = new foo; - -foreach ($x->query("select NAME, VALUE from test", PDO_FETCH_COLUMN, 1) as $row) { - debug_zval_dump($row); -} - -echo "Done\n"; -exit; - -$stmt = $x->prepare("select NAME, VALUE from test where value like ?"); -$the_name = 'bar%'; -$stmt->execute(array($the_name)) or die("failed to execute!"); -$stmt->bindColumn('VALUE', $value); - -while ($row = $stmt->fetch()) { - echo "name=$row[NAME] value=$row[VALUE]\n"; - echo "value is $value\n"; - echo "\n"; -} - -echo "Let's try an update\n"; - -echo "All done\n"; - -?> |