File "submit.php"

Full Path: /home/ccipcixf/public_html/offline/submit.php
File size: 1.34 KB
MIME-type: text/x-php
Charset: utf-8

<?php
header('Content-Type: application/json');

$servername = "localhost";
$username = "bizkzvvd_offline";
$password = "Hxu?TLF@Ldk1";
$dbname = "bizkzvvd_offline";

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

if ($conn->connect_error) {
    http_response_code(500);
    echo json_encode(["message" => "Connection failed: " . $conn->connect_error]);
    exit();
}

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    echo json_encode(["message" => "Method Not Allowed"]);
    exit();
}

$data = json_decode(file_get_contents('php://input'), true);

if (!$data || !isset($data['name']) || !isset($data['email'])) {
    http_response_code(400);
    echo json_encode(["message" => "Invalid input"]);
    exit();
}

$name = $data['name'];
$email = $data['email'];

$stmt = $conn->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
if ($stmt === false) {
    http_response_code(500);
    echo json_encode(["message" => "Prepare statement failed: " . $conn->error]);
    exit();
}

$stmt->bind_param("ss", $name, $email);

if ($stmt->execute()) {
    echo json_encode(["message" => "New record created successfully"]);
} else {
    http_response_code(500);
    echo json_encode(["message" => "Execute failed: " . $stmt->error]);
}

$stmt->close();
$conn->close();
?>