Tul xxx Tul

Viewing: api.php

<?php
// API pública para operaciones del frontend (guestbook, RSVP)
header('Content-Type: application/json');
require_once 'admin/includes/db.php';

$db = getDB();
$action = $_POST['action'] ?? $_GET['action'] ?? '';
$response = ['success' => false, 'message' => 'Acción no válida'];

try {
    switch ($action) {
        case 'save_message':
            $name = trim($_POST['name'] ?? '');
            $message = trim($_POST['message'] ?? '');
            if ($name && $message) {
                $stmt = $db->prepare('INSERT INTO guestbook_messages (name, message) VALUES (?, ?)');
                $stmt->execute([$name, $message]);
                $response = ['success' => true, 'message' => 'Mensaje guardado'];
            } else {
                $response = ['success' => false, 'message' => 'Nombre y mensaje requeridos'];
            }
            break;

        case 'get_messages':
            $messages = $db->query('SELECT name, message, created_at FROM guestbook_messages ORDER BY created_at DESC')->fetchAll();
            $response = ['success' => true, 'data' => $messages];
            break;

        case 'save_rsvp':
            $names = trim($_POST['names'] ?? '');
            $guests = intval($_POST['guests_count'] ?? 1);
            $status = trim($_POST['status'] ?? '');
            if ($status) {
                $stmt = $db->prepare('INSERT INTO rsvp_confirmations (names, guests_count, status) VALUES (?, ?, ?)');
                $stmt->execute([$names, $guests, $status]);
                $response = ['success' => true, 'message' => 'Confirmación registrada'];
            }
            break;
    }
} catch (Exception $e) {
    $response = ['success' => false, 'message' => 'Error del servidor'];
}

echo json_encode($response);

User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64