query("SELECT role FROM users WHERE id = {$_SESSION['user_id']}")->fetch_assoc(); if (($check['role'] ?? '') !== 'admin') { die("Access Denied"); } $msg = ""; // 2. HANDLE BACKUP GENERATION if (isset($_POST['create_backup'])) { $tables = []; $result = $conn->query("SHOW TABLES"); while($row = $result->fetch_row()) { $tables[] = $row[0]; } $sqlScript = ""; foreach($tables as $table) { $result = $conn->query("SELECT * FROM $table"); $num_fields = $result->field_count; $sqlScript .= "DROP TABLE IF EXISTS $table;"; $row2 = $conn->query("SHOW CREATE TABLE $table")->fetch_row(); $sqlScript .= "\n\n" . $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while($row = $result->fetch_row()) { $sqlScript .= "INSERT INTO $table VALUES("; for($j=0; $j < $num_fields; $j++) { $row[$j] = $row[$j]; if (isset($row[$j])) { $sqlScript .= '"' . $conn->real_escape_string($row[$j]) . '"'; } else { $sqlScript .= '""'; } if ($j < ($num_fields - 1)) { $sqlScript .= ','; } } $sqlScript .= ");\n"; } } $sqlScript .= "\n"; } // Save File $backup_dir = '../backups/'; if (!file_exists($backup_dir)) { mkdir($backup_dir, 0777, true); } $filename = 'db_backup_' . date('Y-m-d_H-i-s') . '.sql'; $handle = fopen($backup_dir . $filename, 'w+'); fwrite($handle, $sqlScript); fclose($handle); $msg = "Backup created successfully: $filename"; } // 3. HANDLE DELETE if (isset($_GET['delete'])) { $file = '../backups/' . basename($_GET['delete']); if (file_exists($file)) { unlink($file); } header("Location: backups.php"); exit(); } ?> Database Backups - Admin

Database Backups

$msg
"; ?>
Create New Backup

This will export all Users, QR Codes, Settings, and Analytics into a single SQL file.

Available Backups
0) { // Sort by newest first usort($files, function($a, $b) { return filemtime($b) - filemtime($a); }); foreach($files as $file) { $filename = basename($file); $size = round(filesize($file) / 1024, 2) . ' KB'; $date = date('M d, Y H:i:s', filemtime($file)); echo ""; } } else { echo ""; } ?>
FilenameSizeDateActions
$filename $size $date Download Delete
No backups found.