<?php
// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Include database configuration
include 'config.php';

// Check if the form was submitted using POST
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Capture the form data
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $address = $_POST['address'];
    $city = $_POST['city'];
    $state = $_POST['state'];
    $zip = $_POST['zip'];
    $website = $_POST['website'];
    $description = $_POST['description'];
    $category = $_POST['category'];
    $spots = $_POST['spots']; // Number of spots selected

    // Debug: Print the captured form data
    echo "Name: $name, Email: $email, Phone: $phone, Address: $address, City: $city, State: $state, Zip: $zip, Website: $website, Description: $description, Category: $category, Spots: $spots";

    // Create a new database connection
    $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

    // Check if the connection is successful
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    // SQL query to insert the data into the database
    $sql = "INSERT INTO vendors (name, email, phone, address, city, state, zip, website, description, category, spots) 
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    // Prepare the statement
    $stmt = $conn->prepare($sql);

    // Check if the statement was prepared successfully
    if ($stmt === false) {
        die("Error preparing the statement: " . $conn->error); // Output error if prepare() fails
    }

    // Bind the parameters to the query
    $stmt->bind_param("ssssssssssi", $name, $email, $phone, $address, $city, $state, $zip, $website, $description, $category, $spots);

    // Execute the query and check for errors
    if ($stmt->execute()) {
        // Redirect to a success page or confirmation page
        header("Location: success.php"); // Change this to your success page
        exit();
    } else {
        // If the query fails, display the error message
        echo "Error executing query: " . $stmt->error;
    }

    // Close the statement and connection
    $stmt->close();
    $conn->close();
}
?>