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']}',path='{$_POST['path']}' WHERE id='{$_POST['id']}'");
$db->close();
header("Location: {$base_file}");
}
//submit new
if (isset($_POST['submit'])){
$db->exec("INSERT INTO {$table_name}(title, path) VALUES('{$_POST['title']}', '{$_POST['path']}')");
header("Location: {$base_file}");
}
//delete row
if(isset($_GET['delete'])){
$db->exec("DELETE FROM {$table_name} WHERE id={$_GET['delete']}");
header("Location: {$base_file}");
}
?>
;
Editar imagens do anúncio
;