exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title VARCHAR(100), url TEXT)");
// Chamada para a tabela
$res = $db->query("SELECT * FROM {$table_name}");
// Chamada para o update
@$resU = $db->query("SELECT * FROM {$table_name} WHERE id='{$_GET['update']}'");
@$rowU = $resU->fetchArray();
// Processar o formulário de atualização
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}");
}
// Processar o formulário de inserção de novo DNS
if (isset($_POST['submit'])) {
$db->exec("INSERT INTO {$table_name}(title, url) VALUES('{$_POST['title']}', '{$_POST['url']}')");
header("Location: {$base_file}");
}
// Processar o delete de um DNS
if (isset($_GET['delete'])) {
$db->exec("DELETE FROM {$table_name} WHERE id={$_GET['delete']}");
header("Location: {$base_file}");
}
// Processar a alteração do ID (Index)
if (isset($_POST['submit_id'])) {
$current_id = $_POST['current_id'];
$new_id = $_POST['new_id'];
// Verificar se o novo ID já existe
$checkQuery = $db->query("SELECT id FROM {$table_name} WHERE id = '{$new_id}'");
if ($checkQuery->fetchArray()) {
echo "O ID {$new_id} já existe!";
} else {
// Atualizar o ID
$db->exec("UPDATE {$table_name} SET id = '{$new_id}' WHERE id = '{$current_id}'");
header("Location: {$base_file}");
}
}
?>
Manage DNS
New DNS
| Index |
Title |
DNS |
Actions |
fetchArray()) { ?>
|
|
|
|
|