Starting Local Database Setup...";
// Read SQL file
$sqlFile = 'database.sql';
if (!file_exists($sqlFile)) {
die("Error: database.sql not found!");
}
$sql = file_get_contents($sqlFile);
// Split SQL into individual queries
$queries = explode(';', $sql);
$successCount = 0;
$errorCount = 0;
foreach ($queries as $query) {
if (trim($query) != '') {
try {
if ($conn->query($query)) {
$successCount++;
}
} catch (Exception $e) {
// Ignore trivial errors like 'database exists'
if (strpos($e->getMessage(), 'exists') === false) {
echo "Error executing query: " . $e->getMessage() . "
";
$errorCount++;
} else {
$successCount++;
}
}
}
}
echo "Setup Complete! Successfully executed $successCount queries.
";
if ($errorCount > 0) {
echo "Handled $errorCount potential conflicts.
";
}
echo "
Go to Website Home";
?>