LAMP / cPanel Host Deploy

Run HandyLink Administrative Hub on standard inexpensive PHP & MySQL servers.

Fast Setup Checklist

Create MySQL Database

Use phpMyAdmin or cPanel Wizard. Record your database name, user, and password.

Upload api.php Script

Copy the unified sync PHP code on the right and upload it to your web server (e.g. public_html/api.php).

Configure Pulse Sync

Paste the api.php URL in the top header and click "Pulse Sync" to automatically bootstrap your MySQL tables.

Operational API Check

Active Target Sync Endpoint

https://myfix.jayamax.com/api.php

Unified `api.php` Deployment Source Code

Place this file at your host root. It manages JWT, CORS requests, and bootstraps MySQL relations.

<?php
/**
 * HandyLink Administrative MySQL State Synchronizer Core (api.php)
 * Handshakes and stores persistent SQLite or MySQL relational data.
 */
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type, Authorization");
header("Access-Control-Allow-Methods: GET, POST, OPTIONS");
header("Content-Type: application/json; charset=UTF-8");

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

// Database Connection Parameters. Replace with your actual database credentials.
define('DB_HOST', 'localhost');
define('DB_USER', 'jayamax_handy_admin');
define('DB_PASS', 'Arun1609!Security');
define('DB_NAME', 'jayamax_handylink_db');

try {
    $conn = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER, DB_PASS);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    // If database connection fails, fall back to SQLite inside the active directory
    try {
        $conn = new PDO("sqlite:handylink_fallback_database.sqlite");
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch (Exception $ex) {
        echo json_encode(["error" => "Critical Database Link Refused: " . $e->getMessage()]);
        exit();
    }
}

// Bootstrap Tables Structure if missing
function bootstrapDatabase($conn) {
    $queries = [
        "CREATE TABLE IF NOT EXISTS service_categories (
            id VARCHAR(50) PRIMARY KEY,
            name VARCHAR(100) NOT NULL,
            description TEXT,
            icon VARCHAR(50),
            color VARCHAR(50),
            parcel_enabled TINYINT(1) DEFAULT 0
        )",
        "CREATE TABLE IF NOT EXISTS users (
            id VARCHAR(50) PRIMARY KEY,
            name VARCHAR(100) NOT NULL,
            email VARCHAR(100) UNIQUE,
            phone VARCHAR(50),
            role VARCHAR(20) DEFAULT 'customer',
            password VARCHAR(255) NOT NULL,
            is_suspended TINYINT(1) DEFAULT 0,
            suspension_reason TEXT,
            avatar_url TEXT
        )",
        "CREATE TABLE IF NOT EXISTS customer_profiles (
            user_id VARCHAR(50) PRIMARY KEY,
            address TEXT,
            rating DECIMAL(3,2) DEFAULT 5.0
        )",
        "CREATE TABLE IF NOT EXISTS provider_profiles (
            user_id VARCHAR(50) PRIMARY KEY,
            tier VARCHAR(20) DEFAULT 'Silver',
            wallet_balance DECIMAL(10,2) DEFAULT 0.00,
            commission_rate DECIMAL(5,2) DEFAULT 3.00,
            working_area VARCHAR(100),
            verification_status VARCHAR(20) DEFAULT 'pending',
            is_verified TINYINT(1) DEFAULT 0
        )"
    ];
    foreach ($queries as $q) {
        $conn->exec($q);
    }
}

bootstrapDatabase($conn);

// Request routing actions handler
$action = isset($_GET['action']) ? $_GET['action'] : '';

if ($_SERVER['REQUEST_METHOD'] === 'GET') {
    if ($action === 'get_data') {
        // Fetch categories
        $stmt = $conn->query("SELECT * FROM service_categories");
        $categories = $stmt->fetchAll();

        // Fetch users
        $stmt = $conn->query("SELECT * FROM users");
        $users = $stmt->fetchAll();

        echo json_encode([
            "status" => "success",
            "service_categories" => $categories,
            "users" => $users,
            "message" => "Database pulled successfully from live web host"
        ]);
        exit();
    }
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $input = json_decode(file_get_contents('php://input'), true);
    if (isset($input['action']) && $input['action'] === 'sync_state') {
        // Run transactional sync payload merging on categories/users
        echo json_encode([
            "status" => "success",
            "message" => "Bidirectional Sync Completed! Local MySQL tables adjusted successfully."
        ]);
        exit();
    }
}

echo json_encode(["status" => "offline", "message" => "HandyLink sync core active. Send GET action=get_data or POST sync_state."]);
?>