<?php
header('Content-Type: application/json');

$user = 'ariku129';
$pass = '30118331%#!';
$host = "localhost";
$database = $user . "_CAMPUS"; // Added $ and changed + to .

// 1. Capture Inputs
$campus = isset($_REQUEST['campus']) ? $_REQUEST['campus'] : '';
$cuisine = isset($_REQUEST['cuisine']) ? $_REQUEST['cuisine'] : '';
$place = isset($_REQUEST['place']) ? $_REQUEST['place'] : '';

$err = "0";
$msg = "";

// 2. Validate Inputs
if ($campus > '' && $place > '' && $cuisine > '') {
    try {
        $dsn = "mysql:host=$host;dbname=$database";
        $pdo = new PDO($dsn, $user, $pass);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        // A3.1 requires adding to two tables typically (check your schema)
        // First Insert: Campus and Place
        $sql1 = "INSERT INTO CAMPUS_PLACES (CAMPUS, PLACE) VALUES ('$campus', '$place')";
        $pdo->query($sql1);

        // Second Insert: Place and Cuisine
        $sql2 = "INSERT INTO PLACE_CUISINES (PLACE, CUISINE) VALUES ('$place', '$cuisine')";
        $pdo->query($sql2);

        $msg = "Successfully added $place";
        
    } catch (PDOException $e) {
        $err = "1";
        $msg = "Database Error: " . $e->getMessage();
    }
} else {
    $err = "1";
    $msg = "campus, cuisine, or place not specified";
}

// 3. Final Output
$out = json_encode([
    "msg" => $msg,
    "error" => $err,
    "campus" => $campus,
    "cuisine" => $cuisine,
    "place" => $place
]);

echo $out;
?>