Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
<?php
include "db.php";
echo "<h1>Setting Up Reviews Table</h1>";
try {
$conn->exec("
CREATE TABLE IF NOT EXISTS reviews (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
rating INT NOT NULL CHECK (rating BETWEEN 1 AND 5),
comment VARCHAR(200) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)
");
echo "✅ Created reviews table successfully<br>";
} catch (PDOException $e) {
echo "❌ Error creating reviews table: " . $e->getMessage() . "<br>";
}
echo "<p>Setup complete! <a href='homepage.php'>Return to homepage</a></p>";
?>