Quotation

connect_error) {
die(“DB Connection failed: ” . $conn->connect_error);
}

// ———- DATABASE SETUP (run once) ———-
$conn->query(“CREATE TABLE IF NOT EXISTS leads (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
phone VARCHAR(30),
message TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)”);

$conn->query(“CREATE TABLE IF NOT EXISTS customers (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
phone VARCHAR(30),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)”);

$conn->query(“CREATE TABLE IF NOT EXISTS bookings (
id INT AUTO_INCREMENT PRIMARY KEY,
customer_id INT,
property_name VARCHAR(150),
checkin DATE,
checkout DATE,
status VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)”);

// ———- ADD LEAD ———-
if(isset($_POST[‘add_lead’])){
$stmt = $conn->prepare(“INSERT INTO leads(name,email,phone,message) VALUES(?,?,?,?)”);
$stmt->bind_param(“ssss”, $_POST[‘name’], $_POST[’email’], $_POST[‘phone’], $_POST[‘message’]);
$stmt->execute();
}

// ———- FETCH DATA ———-
$leads = $conn->query(“SELECT * FROM leads ORDER BY id DESC”);
$customers = $conn->query(“SELECT * FROM customers ORDER BY id DESC”);
$bookings = $conn->query(“SELECT * FROM bookings ORDER BY id DESC”);
?>

BookMyStay CRM Dashboard