File "profile.php"

Full path: /home/eshuaesb/public_html/www.mhawaterpark.com/api/profile.php
File size: 1.3 KB B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
header("Cache-Control: no-cache, no-store, must-revalidate");
header("Pragma: no-cache");
header("Expires: 0");

$servername = "localhost";
$username = "eshuaesb_waterpark_api";
$password = "Waterpark@321";
$dbname = "eshuaesb_waterpark_api";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    echo json_encode(["status" => "error", "message" => "Database connection failed"]);
    exit;
}

if (isset($_GET['mobile']) && !empty($_GET['mobile'])) {
    $mobile = $conn->real_escape_string($_GET['mobile']);
    $query = "SELECT * FROM tbl_user WHERE mobile = '$mobile'";

    $result = $conn->query($query);

    if ($result && $result->num_rows > 0) {
        $userDetails = $result->fetch_assoc();
        echo json_encode(["status" => "success", "userDetails" => $userDetails]);
    } else {
        echo json_encode(["status" => "error", "message" => "No user found"]);
    }
} else {
    echo json_encode(["status" => "error", "message" => "Mobile number is required"]);
}

$conn->close();
?>