🎛️ Multi-Pin System Setup
";
$sql = file_get_contents(__DIR__ . '/create_pins_system.sql');
$statements = array_filter(array_map('trim', explode(';', $sql)));
$success = 0;
$errors = 0;
foreach ($statements as $statement) {
if (empty($statement) || strpos($statement, '--') === 0) continue;
try {
$db->exec($statement);
$success++;
if (preg_match('/CREATE TABLE.*?`(\w+)`/i', $statement, $matches)) {
echo "
✅ Table created: {$matches[1]}
";
} elseif (preg_match('/INSERT INTO.*?`(\w+)`/i', $statement, $matches)) {
echo "
✅ Sample data inserted into: {$matches[1]}
";
}
} catch (PDOException $e) {
$errors++;
echo "
❌ Error: " . htmlspecialchars($e->getMessage()) . "
";
}
}
echo "
";
echo "
";
} catch (Exception $e) {
echo "❌ Fatal Error: " . htmlspecialchars($e->getMessage()) . "
";
}
?>