Product Fitting & Service Query

// Check if POST request has tracking number input if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Get the raw POST data $data = json_decode(file_get_contents("php://input"), true); $tracking_number = $data['tracking_number'] ?? ''; // Database connection $servername = "localhost"; $username = "furnitur_pintu"; $password = "S0naiJanu..."; $dbname = "furnitur_pro"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Prepare and execute the query $stmt = $conn->prepare("SELECT shop_name, product_type, service_type, assign_date, fitter_name, status FROM service_fitter_assignment WHERE tracking_number = ?"); $stmt->bind_param("s", $tracking_number); $stmt->execute(); $result = $stmt->get_result(); // Check if a row was found if ($result->num_rows > 0) { $row = $result->fetch_assoc(); echo json_encode([ "success" => true, "shop_name" => $row['shop_name'], "product_type" => $row['product_type'], "service_type" => $row['service_type'], "assign_date" => $row['assign_date'], "fitter_name" => $row['fitter_name'], "status" => $row['status'] ]); } else { echo json_encode(["success" => false]); } // Close connection $stmt->close(); $conn->close(); } ?>