<?php
// Database credentials
$host = '208.91.199.11';
$port = '3306';
$user = 'lcitschool24';
$password = '#Lcit#@2025';
$database = 'lcitschool';

// Connect to MySQL
$conn = new mysqli($host, $user, $password, $database, $port);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Set filename
$filename = $database . '_backup_' . date('Y-m-d_H-i-s') . '.sql';

// Set headers
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Pragma: no-cache');
header('Expires: 0');

// Start output
$output = "";

// Get all tables
$tables = [];
$result = $conn->query("SHOW TABLES");
while ($row = $result->fetch_array()) {
    $tables[] = $row[0];
}

// Export each table
foreach ($tables as $table) {
    // Table structure
    $res = $conn->query("SHOW CREATE TABLE `$table`");
    $row = $res->fetch_assoc();
    $output .= "\n\n" . $row['Create Table'] . ";\n";

    // Table data
    $res = $conn->query("SELECT * FROM `$table`");
    while ($row = $res->fetch_assoc()) {
        $vals = array_map([$conn, 'real_escape_string'], array_values($row));
        $output .= "INSERT INTO `$table` VALUES ('" . implode("','", $vals) . "');\n";
    }
}

// Output the SQL
echo $output;
$conn->close();
exit;
?>