exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY NOT NULL, Title TEXT, Description TEXT, CreateDate TEXT)");
//table call
$res = $db->query("SELECT * FROM {$table_name}");
//update call
@$resU = $db->query("SELECT * FROM {$table_name} WHERE id='{$_GET['update']}'");
@$rowU=$resU->fetchArray();
if(isset($_POST['submitU'])){
$db->exec("UPDATE {$table_name} SET Title='{$_POST['Title']}', Description='{$_POST['Description']}',CreateDate='{$_POST['CreateDate']}' WHERE id='{$_POST['id']}'");
$db->close();
header("Location: {$base_file}");
}
//submit new
if (isset($_POST['submit'])){
$db->exec("INSERT INTO {$table_name}(Title, Description , CreateDate) VALUES('{$_POST['Title']}', '{$_POST['Description']}', '{$_POST['CreateDate']}')");
header("Location: {$base_file}");
}
//delete row
if(isset($_GET['delete'])){
$db->exec("DELETE FROM {$table_name} WHERE id={$_GET['delete']}");
header("Location: {$base_file}");
}
?>
adds Notes
Nova Note
| Index |
Title |
Description |
CreateDate |
Edit Delete |
fetchArray()) {?>
|
|
|
|
|