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" => getcwd() . "/dbase/mydbase.db");
$db->connect($DSN);
$query = "SELECT * FROM guestbook";
$result = $db->query($query);
while (list($fname, $lname, $email, $comment) = $db->fetchRow($result))
{
echo "<p><a href=\"mailto:$email\">$fname $lname</a> said:<br />";
echo nl2br(htmlspecialchars(stripslashes($comment))) . "</p>";
}
$db->disconnect();
?> |
Next: Unsupported SQL Commands >>
More Database Articles Articles
More By bluephoenix
blog comments powered by 
