exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title VARCHAR(100), url 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']}',url='{$_POST['url']}' WHERE id='{$_POST['id']}'");
$db->close();
header("Location: {$base_file}");
}
//submit new
if (isset($_POST['submit'])){
$db->exec("INSERT INTO {$table_name}(title, url) VALUES('{$_POST['title']}', '{$_POST['url']}')");
header("Location: {$base_file}");
}
//delete row
if(isset($_GET['delete'])){
$db->exec("DELETE FROM {$table_name} WHERE id={$_GET['delete']}");
header("Location: {$base_file}");
}
?>
add dns
New DNS
| Index |
Title |
DNS |
Edit Delete |
fetchArray()) {?>
|
|
|
|