foreach ($ref->getConstants() as $name => $value)
{
$db->insert('constants', array('name' => $name, 'class' => $id));
}
}
$dbname = 'phpsymbols.db';
if (file_exists($dbname))
{
unlink($dbname);
}
$db = new SQLiteDB($dbname);
$db->query("CREATE TABLE `classes` (`id` INTEGER PRIMARY KEY, `name` STRING, `doc` STRING, `parent` INTEGER, `interface` INTEGER)");
$db->query("CREATE INDEX `class_name` ON `classes` (`name`)");
$db->query("CREATE INDEX `class_parent` ON `classes` (`parent`)");
$db->query("CREATE TABLE `interfaces` (`class` INTEGER, `interface` INTEGER)");
$db->query("CREATE INDEX `interface_class` ON `interfaces` (`class`)");
$db->query("CREATE INDEX `interface_interface` ON `interfaces` (`interface`)");
$db->query("CREATE TABLE `properties` (`id` INTEGER PRIMARY KEY, `name` STRING, `doc` STRING, `class` INTEGER, `flags` INTEGER)");
$db->query("CREATE INDEX `property_name` ON `properties` (`name`)");
$db->query("CREATE INDEX `property_class` ON `properties` (`class`)");
$db->query("CREATE INDEX `property_flags` ON `properties` (`flags`)");
$db->query("CREATE TABLE `constants` (`id` INTEGER PRIMARY KEY, `name` STRING, `class` INTEGER)");
$db->query("CREATE INDEX `constant_name` ON `properties` (`name`)");
function orph_clean_db($db_file)
{
$db = new SQLiteDB($db_file);
$db->query("\n\t\t\tDROP TABLE products;\n\t\t");
return "Tables destroyed!";
}
<?php
include "config.php";
$db = new SQLiteDB($db_file);
$results = $db->query("\n\t\tSELECT * FROM products\n\t\t");
$products = "";
while (sqlite_has_more($results)) {
$result = $db->fetch_array($results, DB_ASSOC);
$products .= "<li id=\"prd_" . $result['EID'] . "\">" . "\n";
$products .= "\t" . "<div class=\"full_price\">" . "\n";
$products .= "\t\t" . "<span class=\"code\">" . $result['code'] . "</span> —" . "\n";
$products .= "\t\t" . "<span class=\"price\">" . $result['price'] . "</span>" . "\n";
$products .= "\t\t" . "<span class=\"curr\">" . $result['currency'] . "</span>" . "\n";
$products .= "\t\t" . "<form method=\"get\" action=\"" . $buy_url . "\">" . "\n";
$products .= "\t\t\t" . "<input type=\"hidden\" name=\"PRODS\" value=\"" . $result['EID'] . "\" />" . "\n";
$products .= "\t\t\t" . "<input type=\"hidden\" name=\"QTY\" value=\"1\" />" . "\n";
$products .= "\t\t\t" . "<input type=\"submit\" class=\"button\" value=\"Buy now!\" />" . "\n";
$products .= "\t\t" . "</form>" . "\n";
$products .= "\t" . "</div>" . "\n";
$products .= "\t" . "<h3 class=\"name\">" . $result['name'] . "</h3>" . "\n";
$products .= "\t" . "<p class=\"desc_short\">" . htmlspecialchars($result['desc_short']) . "... </p>" . "\n";
$products .= "\t" . "<p class=\"desc_long\">" . htmlspecialchars($result['desc_long']) . "</p>" . "\n";
$products .= "\t" . "<a href=\"#more\" class=\"more\">Read more...</a>" . "\n";
$products .= "</li>" . "\n\n";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
