exec("CREATE TABLE IF NOT EXISTS theme(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(100), url VARCHAR(100))"); $res = $db->query("SELECT * FROM theme"); $rows = $db->query("SELECT COUNT(*) as count FROM theme"); $row = $rows->fetchArray(); $numRows = $row["count"]; $HOSTa = $lurl = (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] !== "off" ? "https" : "http") . "://" . $_SERVER["HTTP_HOST"] . dirname($_SERVER["PHP_SELF"]) . "/img/red.jpg"; $HOSTb = $lurl = (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] !== "off" ? "https" : "http") . "://" . $_SERVER["HTTP_HOST"] . dirname($_SERVER["PHP_SELF"]) . "/img/blue.jpg"; $HOSTc = $lurl = (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] !== "off" ? "https" : "http") . "://" . $_SERVER["HTTP_HOST"] . dirname($_SERVER["PHP_SELF"]) . "/img/green.jpg"; $HOSTa1 = $lurl = (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] !== "off" ? "https" : "http") . "://" . $_SERVER["HTTP_HOST"] . dirname($_SERVER["PHP_SELF"]) . "/img/g1.gif"; if ($numRows == 0) { $db->exec("INSERT INTO theme(name,url) VALUES('Red','" . $HOSTa . "')\r\n\t,('Blue','" . $HOSTb . "')\r\n\t,('Green','" . $HOSTc . "')\r\n\t,('Gif Edition','" . $HOSTa1 . "')\r\n\t"); } if (isset($_GET["delete"])) { $db->exec("DELETE FROM theme WHERE id=" . $_GET["delete"]); header("Location: theme.php"); } include "includes/header.php"; echo "
\n
\n
\n
\n

Confirm

\n
\n
\n Do you really want to delete?\n
\n
\n \n Delete\n
\n
\n
\n
\n
\n
\n \n\n \n

Themes

\n \n Create\n \n
\n\t\t
\n\t\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\n"; while ($row = $res->fetchArray()) { $NName = $row["name"]; $UUrl = $row["url"]; $IIdd = $row["id"]; echo "\t\t\t\n\t\t\t\t\n"; echo "\t\t\t\t" . "\n"; echo "\t\t\t\t" . "\n"; echo "\t\t\t\t" . "\n"; echo "\t\t\t\t" . "\n"; echo " " . "\n"; echo "\t\t\t\t\n\t\t\t\n"; } echo "\t\t\t
NameImage UrlImage PreviewEditDelete
" . $NName . "" . $UUrl . "\"\"
\n\t\t
\n
\n\n


\n"; include "includes/footer.php"; echo " \n\n\n"; ?>