exec('UPDATE ' . $table_name . ' SET Title=\'' . sanitize($_POST['Title']) . '\', Description=\'' . sanitize($_POST['Description']) . '\',CreateDate=\'' . sanitize($_POST['CreateDate']) . '\' WHERE id=\'' . sanitize($_POST['id']) . '\''); } else if ($sub_type == 'sub_new') { $db->exec('INSERT INTO ' . $table_name . '(Title, Description , CreateDate) VALUES(\'' . sanitize($_POST['Title']) . '\', \'' . sanitize($_POST['Description']) . '\', \'' . sanitize($_POST['CreateDate']) . '\')'); } else if ($sub_type == 'sub_del') { $db->exec('DELETE FROM ' . $table_name . ' WHERE id=' . sanitize($_GET['delete'])); } $db->close(); } include 'includes/header.php'; $table_name = 'note'; $db->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"; 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\t" . 'New 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" . ''; ?>