UserHelpRequests.php

<?php
include "Conx.php"; 

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: Content-Type, Authorization');
header('Access-Control-Allow-Methods: GET');
header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['user_id'])) {
        $user_id = $_GET['user_id'];

        $stmt = $conn->prepare("
            SELECT 
                hr.id AS help_id, 
                hr.crop, 
                hr.irrigation, 
                IFNULL(hr.plastic_house, 'no') AS plastichouse, 
                hr.problem, 
                a.answer, 
                u.name AS answered_by
            FROM help_requests hr
            LEFT JOIN answers a ON hr.id = a.help_id
            LEFT JOIN users u ON a.user_id = u.id
            WHERE hr.user_id = ?
        ");
        $stmt->bind_param("i", $user_id);
        $stmt->execute();
        $result = $stmt->get_result();
        $requests = $result->fetch_all(MYSQLI_ASSOC);

        echo json_encode(['success' => true, 'data' => $requests]);
        $stmt->close();
    } else {
        echo json_encode(['success' => false, 'message' => 'User ID not provided']);
    }
}

$conn->close();
?>