<?php
session_start();
include 'config.php'; // Include database configuration

// Database connection
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Capture 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']; // New field for number of spots

    // Prepare the insert statement
    $stmt = $conn->prepare("INSERT INTO vendors (name, email, phone, address, city, state, zip, website, description, category, spots) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("ssssssssssi", $name, $email, $phone, $address, $city, $state, $zip, $website, $description, $category, $spots);
    
    // Execute the statement and check for errors
    if ($stmt->execute()) {
        // Redirect to the payment page after successful registration
        header("Location: payment.php");
        exit();
    } else {
        echo "Error: " . $stmt->error;
    }

    $stmt->close();
}

$conn->close();
?>