connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// ============================================
// CREATE TABLES
// ============================================
$conn->query("CREATE TABLE IF NOT EXISTS products (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(200) NOT NULL,
price DECIMAL(10,2) NOT NULL,
image VARCHAR(500),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");
$conn->query("CREATE TABLE IF NOT EXISTS leads (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
phone VARCHAR(20) NOT NULL,
address TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");
$conn->query("CREATE TABLE IF NOT EXISTS orders (
id INT PRIMARY KEY AUTO_INCREMENT,
order_number VARCHAR(50) UNIQUE,
customer_name VARCHAR(100),
customer_phone VARCHAR(20),
customer_address TEXT,
product_name VARCHAR(200),
quantity INT,
total DECIMAL(10,2),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");
// Add sample product if empty
$check = $conn->query("SELECT id FROM products LIMIT 1");
if ($check->num_rows == 0) {
$conn->query("INSERT INTO products (name, price, image) VALUES
('Premium Product', 999, 'https://via.placeholder.com/400')");
}
// ============================================
// API ROUTES
// ============================================
$is_api = strpos($_SERVER['REQUEST_URI'], '/api/') !== false;
if ($is_api) {
header('Content-Type: application/json');
$input = json_decode(file_get_contents('php://input'), true);
// Get products
if ($_SERVER['REQUEST_URI'] == '/api/products') {
$result = $conn->query("SELECT * FROM products ORDER BY id DESC");
$products = [];
while ($row = $result->fetch_assoc()) {
$products[] = $row;
}
echo json_encode($products);
exit();
}
// Save lead
if ($_SERVER['REQUEST_URI'] == '/api/save-lead') {
$stmt = $conn->prepare("INSERT INTO leads (name, phone, address) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $input['name'], $input['phone'], $input['address']);
$stmt->execute();
echo json_encode(['success' => true]);
exit();
}
// Create order
if ($_SERVER['REQUEST_URI'] == '/api/create-order') {
$order_no = 'ORD' . time() . rand(100, 999);
$stmt = $conn->prepare("INSERT INTO orders (order_number, customer_name, customer_phone, customer_address, product_name, quantity, total) VALUES (?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param("sssssis", $order_no, $input['name'], $input['phone'], $input['address'], $input['product'], $input['qty'], $input['total']);
$stmt->execute();
$message = "🛍️ NEW ORDER!\nOrder: $order_no\nName: {$input['name']}\nPhone: {$input['phone']}\nAddress: {$input['address']}\nProduct: {$input['product']}\nTotal: ₹{$input['total']}";
$whatsapp = "https://wa.me/" . ADMIN_WHATSAPP . "?text=" . urlencode($message);
echo json_encode(['success' => true, 'whatsapp_url' => $whatsapp]);
exit();
}
echo json_encode(['error' => 'API not found']);
exit();
}
// ============================================
// ADMIN PANEL
// ============================================
if (isset($_GET['admin'])) {
if ($_GET['admin'] == 'login') {
?>
Admin Login
Admin Login
Use: admin / admin123
query("SELECT COUNT(*) as c FROM products")->fetch_assoc()['c'];
$orders = $conn->query("SELECT COUNT(*) as c FROM orders")->fetch_assoc()['c'];
$leads = $conn->query("SELECT COUNT(*) as c FROM leads")->fetch_assoc()['c'];
?>
Admin Dashboard
