exec("CREATE TABLE IF NOT EXISTS notifications(id INTEGER PRIMARY KEY NOT NULL, Title TEXT, Description TEXT, CreateDate TEXT)"); $res = $db->query("SELECT * FROM notifications"); if (isset($_GET["delete"])) { $db->exec("DELETE FROM notifications WHERE id=" . $_GET["delete"]); $db->close(); header("Location: notifications.php"); } include "includes/header.php"; echo "\r\r
\r
\r
\r
\r
\r
\r \r
\r \r
\r
\r\t\t\t\t\t\t\t
\r \t\t\t\t

  Notifications

\r \t\t\t
\r
\r\t\t\t\t\t\t\t
\r\t\t\t\t\t\t\t\t
\r\t \t\t\t\t\t\t\r \t\t\t\t\t\t\t
\r\t\t\t\t\t\t\t
\r\t\t\t\t\t\t
\r\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t"; while ($row = $res->fetchArray()) { echo "\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t\r\t\t\t\t\t\t\t"; } echo "\t\t\t\t\t\t\t
TitleDescriptionTimeStampEditDelete
"; echo $row["Title"]; echo ""; echo $row["Description"]; echo ""; echo $row["CreateDate"]; echo "
\r\t\t\t\t\t\t
\r
\r
\r
\r \r
\r
\r \r \r \r
\r \r \r \r
\r"; include "includes/functions.php"; ?>