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