query("SELECT COUNT(*) as count FROM dns");
$rowC = $row_C->fetchArray();
return $rowC['count'];
}
//create if not
$db->exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title TEXT, url TEXT)");
//table call
$res = $db->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'])){
$db->exec("UPDATE {$table_name} SET title='".sanitize($_POST['title'])."',
url='".sanitize($_POST['url'])."'
WHERE
id='".sanitize($_GET['update'])."'");
$db->close();
header("Location: {$base_file}");
}
//submit new
if (isset($_POST['submit'])){
$db->exec("INSERT INTO {$table_name}(title, url) VALUES('".sanitize($_POST['title'])."', '".sanitize($_POST['url'])."')");
header("Location: {$base_file}");
}
//delete row
if(isset($_GET['delete'])){
$db->exec("DELETE FROM {$table_name} WHERE id=".sanitize($_GET['delete']));
header("Location: ". basename($_SERVER["SCRIPT_NAME"])."?status=2");
}
//delete modal
?>