prepare("SELECT * FROM restaurants WHERE id = ?");
$stmt->execute([$restaurant_id]);
$restaurant = $stmt->fetch();
// 3. Horaires pour le footer
$stmt = $pdo->prepare("SELECT * FROM horaires WHERE restaurant_id = ? ORDER BY jour");
$stmt->execute([$restaurant_id]);
$horaires = $stmt->fetchAll();
// 4. Gestion du formulaire contact
$successMsg = "";
$errorMsg = "";
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['message'])) {
$nom = trim($_POST['nom'] ?? '');
$email = trim($_POST['email'] ?? '');
$telephone = trim($_POST['telephone'] ?? '');
$message = trim($_POST['message'] ?? '');
if ($nom && $message) {
try {
$stmt = $pdo->prepare("INSERT INTO contacts (nom, email, telephone, message) VALUES (?, ?, ?, ?)");
$stmt->execute([$nom, $email ?: null, $telephone ?: null, $message]);
$successMsg = "✅ Votre message a bien été envoyé.";
// (option) header("Location: contact.php?sent=1"); exit;
} catch (PDOException $e) {
$errorMsg = "Erreur lors de l'envoi : " . $e->getMessage();
}
} else {
$errorMsg = "Veuillez remplir tous les champs obligatoires.";
}
}
// 5. Fonction multilingue (facultative)
function t($cle, $langue='fr', $section='contact') {
static $cache = [];
global $pdo;
$key = "$section|$cle|$langue";
if (isset($cache[$key])) return $cache[$key];
$stmt = $pdo->prepare("SELECT $langue FROM textes_site WHERE section = ? AND cle = ?");
$stmt->execute([$section, $cle]);
$valeur = $stmt->fetchColumn();
return $cache[$key] = $valeur ?: "[$cle]";
}
?>
Contact – <?= htmlspecialchars($restaurant['nom']) ?>