Prime Properties in Margallah Enclave Islamabad

How to Deploy on Hostinger (www.brizlar.com)

1. Log in to your Hostinger hPanel (hpanel.hostinger.com).
2. Go to Websites → Select www.brizlar.com → Open File Manager.
3. Navigate to the folder: public_html.
4. Save this current webpage file as index.html and upload it directly into public_html.
5. Go to Databases → MySQL Databases in hPanel, create a new database (e.g. u123456_brizlar) and user with a strong password.
6. Click Enter phpMyAdmin, open the SQL tab, and execute the SQL schema below.

Updated with Sector checks (ME-I, ME-II, ME-III, ME-IV) and size integrity constraints:

-- ========================================================
-- BRIZLAR MARGALLAH ENCLAVE PORTAL DATABASE SCHEMA
-- Compatible with Hostinger MySQL / MariaDB (www.brizlar.com)
-- ========================================================

CREATE DATABASE IF NOT EXISTS `brizlar_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `brizlar_db`;

-- 1. Table for Properties with Sector & Plot Size Integrity
CREATE TABLE IF NOT EXISTS `properties` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR(255) NOT NULL,
  `purpose` ENUM('sale', 'rent') NOT NULL DEFAULT 'sale',
  `category` ENUM('plot', 'villa', 'commercial') NOT NULL DEFAULT 'plot',
  `sector` ENUM('Sector ME-I', 'Sector ME-II', 'Sector ME-III', 'Sector ME-IV') NOT NULL,
  `size` VARCHAR(100) NOT NULL, -- '1 Kanal', '10 Marla', '5 Marla', 'Commercial'
  `price_pkr` VARCHAR(100) NOT NULL,
  `price_numeric` BIGINT NOT NULL DEFAULT 0,
  `bedrooms` INT DEFAULT 0,
  `bathrooms` INT DEFAULT 0,
  `image_url` TEXT NULL,
  `description` TEXT NULL,
  `is_featured` TINYINT(1) DEFAULT 0,
  `is_verified` TINYINT(1) DEFAULT 1,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

-- 2. Table for Buyer / Investor Inquiries
CREATE TABLE IF NOT EXISTS `inquiries` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `property_id` INT NULL,
  `client_name` VARCHAR(150) NOT NULL,
  `phone` VARCHAR(50) NOT NULL,
  `sector_interest` VARCHAR(100) NULL,
  `purpose` VARCHAR(100) NULL,
  `message` TEXT NULL,
  `status` ENUM('new', 'contacted', 'scheduled', 'closed') DEFAULT 'new',
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (`property_id`) REFERENCES `properties`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB;

-- 3. Table for Verified Reviews
CREATE TABLE IF NOT EXISTS `reviews` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `author_name` VARCHAR(150) NOT NULL,
  `sector_location` VARCHAR(150) NOT NULL,
  `rating` INT NOT NULL DEFAULT 5,
  `comment` TEXT NOT NULL,
  `is_approved` TINYINT(1) DEFAULT 1,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

-- Pre-seed Realistic Margallah Enclave Properties
INSERT INTO `properties` (`title`, `purpose`, `category`, `sector`, `size`, `price_pkr`, `price_numeric`, `bedrooms`, `bathrooms`, `image_url`, `description`, `is_featured`, `is_verified`) VALUES
('1 Kanal Prime Boulevard Ridge Plot', 'sale', 'plot', 'Sector ME-II', '1 Kanal', 'Rs 3.90 Crore', 39000000, 0, 0, 'https://images.unsplash.com/photo-1500382017468-9049fed747ef?q=80&w=1200', 'Direct panoramic view of Margalla Hills ridge. Exclusively 1 Kanal sector, 100% possession-ready level ground.', 1, 1),
('1 Kanal Corner Facing Park Plot', 'sale', 'plot', 'Sector ME-III', '1 Kanal', 'Rs 4.10 Crore', 41000000, 0, 0, 'https://images.unsplash.com/photo-1524813686514-a57563d77d66?q=80&w=1200', 'Prime corner plot opposite the central botanical park in Sector ME-III. Strictly 1 Kanal luxury zone.', 1, 1),
('10 Marla Designer Modern Villa', 'sale', 'villa', 'Sector ME-I', '10 Marla', 'Rs 5.25 Crore', 52500000, 5, 6, 'https://images.unsplash.com/photo-1600585154340-be6161a56a0c?q=80&w=1200', 'Architect-built contemporary villa in Sector ME-I. Spanish porcelain tiles, solid ash wood doors, solar power.', 1, 1),
('5 Marla Possession Residential Plot', 'sale', 'plot', 'Sector ME-IV', '5 Marla', 'Rs 1.35 Crore', 13500000, 0, 0, 'https://images.unsplash.com/photo-1513694203232-719a280e022f?q=80&w=1200', 'Compact modern plot in Sector ME-IV. Near educational complex and community sports club.', 0, 1),
('1 Kanal Royal Mountain Palace House', 'sale', 'villa', 'Sector ME-II', '1 Kanal', 'Rs 8.90 Crore', 89000000, 6, 7, 'https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?q=80&w=1200', 'Magnificent 1 Kanal residence in Sector ME-II with private pool, rooftop terrace, servant quarters.', 1, 1),
('8 Marla Main Civic Center Commercial Plot', 'sale', 'commercial', 'Sector ME-I', '8 Marla', 'Rs 5.80 Crore', 58000000, 0, 0, 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?q=80&w=1200', 'High-density commercial plot in ME-I Markaz. Ground plus 4 storeys approved for banks/retail.', 1, 1),
('4 Marla Commercial Plaza Markaz', 'sale', 'commercial', 'Sector ME-III', '4 Marla', 'Rs 3.60 Crore', 36000000, 0, 2, 'https://images.unsplash.com/photo-1497366216548-37526070297c?q=80&w=1200', 'Commercial plaza unit in ME-III commercial strip. High rental ROI pre-leased to pharmaceutical chain.', 0, 1),
('10 Marla Executive Mountain Villa', 'rent', 'villa', 'Sector ME-IV', '10 Marla', 'Rs 2.50 Lakh / mo', 250000, 4, 5, 'https://images.unsplash.com/photo-1512917774080-9991f1c4c750?q=80&w=1200', 'Fully furnished executive house for rent in ME-IV. Inverter ACs, backup generator, automated gates.', 0, 1);

Upload this file as api.php into Hostinger public_html:

<?php
// ========================================================
// BRIZLAR REAL ESTATE BACKEND API (api.php)
// Place this inside Hostinger public_html for www.brizlar.com
// ========================================================

header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET, POST, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type");
header("Content-Type: application/json; charset=UTF-8");

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit();
}

// 1. Database Credentials (Replace with Hostinger MySQL credentials)
$db_host = "localhost";
$db_name = "u123456_brizlar";   // Your Hostinger DB Name
$db_user = "u123456_user";      // Your Hostinger DB User
$db_pass = "YourHostingerPassword"; // Your Hostinger DB Password

try {
    $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
    ]);
} catch (PDOException $e) {
    echo json_encode(["status" => "error", "message" => "DB connection failed: " . $e->getMessage()]);
    exit();
}

$action = $_GET['action'] ?? '';

// 2. Fetch Properties: GET /api.php?action=get_properties
if ($action === 'get_properties' && $_SERVER['REQUEST_METHOD'] === 'GET') {
    $stmt = $pdo->query("SELECT * FROM properties ORDER BY id DESC");
    $data = $stmt->fetchAll();
    echo json_encode(["status" => "success", "data" => $data]);
    exit();
}

// 3. Save Inquiry: POST /api.php?action=save_inquiry
if ($action === 'save_inquiry' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $input = json_decode(file_get_contents('php://input'), true);
    $name = trim($input['name'] ?? '');
    $phone = trim($input['phone'] ?? '');
    $sector = trim($input['sector'] ?? '');
    $purpose = trim($input['purpose'] ?? '');
    $msg = trim($input['message'] ?? '');

    if (empty($name) || empty($phone)) {
        echo json_encode(["status" => "error", "message" => "Name and phone are required."]);
        exit();
    }

    $stmt = $pdo->prepare("INSERT INTO inquiries (client_name, phone, sector_interest, purpose, message) VALUES (?, ?, ?, ?, ?)");
    $stmt->execute([$name, $phone, $sector, $purpose, $msg]);

    echo json_encode(["status" => "success", "message" => "Inquiry saved to Margallah Enclave database."]);
    exit();
}

// 4. Save Review: POST /api.php?action=save_review
if ($action === 'save_review' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $input = json_decode(file_get_contents('php://input'), true);
    $author = trim($input['author'] ?? '');
    $location = trim($input['location'] ?? '');
    $rating = intval($input['rating'] ?? 5);
    $comment = trim($input['comment'] ?? '');

    if (empty($author) || empty($comment)) {
        echo json_encode(["status" => "error", "message" => "Author and comment are required."]);
        exit();
    }

    $stmt = $pdo->prepare("INSERT INTO reviews (author_name, sector_location, rating, comment) VALUES (?, ?, ?, ?)");
    $stmt->execute([$author, $location, $rating, $comment]);

    echo json_encode(["status" => "success", "message" => "Review recorded successfully."]);
    exit();
}

echo json_encode(["status" => "error", "message" => "Invalid API action."]);
?>