exec("CREATE TABLE IF NOT EXISTS " . $table_name . "(id INTEGER PRIMARY KEY NOT NULL, Title TEXT, Description TEXT, CreateDate TEXT)"); $res = $db->query("SELECT * FROM " . $table_name); $resU = @$db->query("SELECT * FROM " . $table_name . " WHERE id='" . @sanitize($_GET["update"]) . "'"); $rowU = @$resU->fetchArray(); if (isset($_POST["submitU"])) { submit("sub_up", $db, $table_name); header("Location: " . $base_file . "?status=2"); } if (isset($_POST["submit"])) { submit("sub_new", $db, $table_name); header("Location: " . $base_file . "?status=1"); } if (isset($_GET["delete"])) { submit("sub_del", $db, $table_name); header("Location: " . $base_file . "?status=3"); } echo "
\r\n\t
\r\n\t\t
\r\n\t\t\t
\r\n\t\t\t\t

Confirm

\r\n\t\t\t
\r\n\t\t\t
\r\n\t\t\t\tDo you really want to delete?\r\n\t\t\t
\r\n\t\t\t
\r\n\t\t\t\t\r\n\t\t\t\tDelete\r\n\t\t\t
\r\n\t\t
\r\n\t
\r\n
\r\n"; if (isset($_GET["create"])) { echo "\r\n
\r\n
\r\n
\r\n
\r\n
\r\n

Add Note

\r\n
\r\n
\r\n \r\n
\r\n
\r\n

Create Note

\r\n
\r\n
\r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n\r\n\r\n"; } else { if (isset($_GET["update"])) { echo "\r\n
\r\n
\r\n
\r\n
\r\n
\r\n

Add Note

\r\n
\r\n
\r\n \r\n
\r\n
\r\n

Create Note

\r\n
\r\n
\r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n"; } else { echo "\r\n
\r\n
\r\n
\r\n
\r\n
\r\n

Current Notes

\r\n
\r\n
\r\n\r\n
\r\n
\r\n \t
\r\n\t \t\t\t\t\tNew Note\r\n\t \t\t\t\t
\r\n \t\t\t\t\t
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t"; while ($row = $res->fetchArray()) { echo "\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t"; } echo "\t\t\t\t\t\t\t
IndexTitleDescriptionCreateDateEdit   Delete
"; echo $row["id"]; echo ""; echo $row["Title"]; echo ""; echo $row["Description"]; echo ""; echo $row["CreateDate"]; echo "\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t   \r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t
\r\n\t\t\t
\r\n\t\t
\r\n"; } } echo "\r\n"; include "includes/footer.php"; echo "\r\n\r\n"; // @Protected ioncube.dk encoding key. function Submit() { } ?>