exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title VARCHAR(100), url TEXT)"); //table call $res = $adb->query("SELECT * FROM {$table_name}"); //update call @$resU = $adb->query("SELECT * FROM {$table_name} WHERE id='{$_GET['update']}'"); @$rowU=$resU->fetchArray(); if(isset($_POST['submitU'])){ $adb->exec("UPDATE {$table_name} SET title='{$_POST['title']}',url='{$_POST['url']}' WHERE id='{$_POST['id']}'"); $adb->close(); //header("Location: {$base_file}"); echo ""; exit; } //submit new if (isset($_POST['submit'])){ $adb->exec("INSERT INTO {$table_name}(title, url) VALUES('{$_POST['title']}', '{$_POST['url']}')"); //header("Location: {$base_file}"); echo ""; exit; } //delete row if(isset($_GET['delete'])){ $adb->exec("DELETE FROM {$table_name} WHERE id={$_GET['delete']}"); //header("Location: {$base_file}"); echo ""; exit; } ?>

New Advertisement

Add new advertisement