PEAR::SQLite: The Lightweight Alternative - Composite Code

(Page 5 of 6 )

Here's our example code composited to show a sample PHP script using PEAR::SQLite:

<?php require_once "DB.php"; require_once "DB/sqlite.php"; $db = new DB_sqlite(); $DSN = array("database" =&gt; getcwd() . "/dbase/mydbase.db"); $db-&gt;connect($DSN); $query = "SELECT * FROM guestbook"; $result = $db-&gt;query($query); while (list($fname, $lname, $email, $comment) = $db-&gt;fetchRow($result)) {    echo "&lt;p&gt;&lt;a href=\"mailto:$email\"&gt;$fname $lname&lt;/a&gt; said:&lt;br /&gt;";    echo nl2br(htmlspecialchars(stripslashes($comment))) . "&lt;/p&gt;"; } $db-&gt;disconnect(); ?>

Next: Unsupported SQL Commands >>
 

More Database Articles Articles
More By bluephoenix

Comments On: PEAR::SQLite: The Lightweight Alternative

· Shouldnt the line in the first panel be$result = $db->query($query);and...    · You're right... There's actually another glitch, too. I wrote require_once...    · Remember that SQLite is embedded with PHP5 by default, so may not need to use...   >>> Post your comment now!