exec("CREATE TABLE IF NOT EXISTS {$table_name}(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
device_id TEXT UNIQUE,
timestamp INTEGER
)");
// Processar operações
if (isset($_GET['delete'])) {
// Excluir registro
$stmt = $db->prepare("DELETE FROM {$table_name} WHERE id = :id");
$stmt->bindValue(':id', $_GET['delete'], SQLITE3_INTEGER);
$stmt->execute();
header("Location: {$base_file}?status=deleted");
exit;
}
if (isset($_POST['submit'])) {
// Adicionar novo registro
$stmt = $db->prepare("INSERT INTO {$table_name}(device_id, timestamp) VALUES(:device_id, :timestamp)");
$stmt->bindValue(':device_id', $_POST['device_id'], SQLITE3_TEXT);
$stmt->bindValue(':timestamp', time(), SQLITE3_INTEGER);
$stmt->execute();
header("Location: {$base_file}?status=added");
exit;
}
// Buscar todos os registros
$res = $db->query("SELECT * FROM {$table_name} ORDER BY timestamp DESC");
include ('includes/studiolivheaderecode.php');
?>