query("SELECT * FROM {$table_name}"); //update call @$resU = $db->query("SELECT * FROM {$table_name} WHERE id='".sanitize($_GET['update'])."'"); @$rowU=$resU->fetchArray(); if(isset($_POST['submitU'])){ $stmt = $db->prepare('UPDATE '.$table_name.' SET title=?, message=?, created_on=? WHERE id=?'); $stmt->bindParam(1, $_POST['title']); $stmt->bindParam(2, $_POST['message']); $stmt->bindParam(3, $_POST['created_on']); $stmt->bindParam(4, sanitize($_GET['update'])); $stmt->execute(); echo ""; } //submit new if (isset($_POST['submit'])){ $stmt = $db->prepare("INSERT INTO $table_name (title, message, created_on) VALUES (?, ?,?)"); $stmt->bindParam(1, $_POST['title']); $stmt->bindParam(2, $_POST['message']); $stmt->bindParam(3, $_POST['created_on']); $stmt->execute(); echo ""; } //delete row if(isset($_GET['delete'])){ $stmt = $db->prepare('DELETE FROM '.$table_name.' WHERE id=?'); $stmt->bindParam(1, sanitize($_GET['delete'])); $stmt->execute(); echo ""; } ?>

Add Note

Create Note

Add Note

Create Note

Current Notes

New Note

fetchArray()) {?>

Index	Title	Message	CreateDate	Edit Delete