1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / public_html / chitpavan.in / admin_panel /
Filename : update_health.php
back
<?php
// header('Content-Type: application/json');
include('config.php');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {

    // Get data from POST request
    $user_id = isset($_POST['user_id']) ? $conn->real_escape_string($_POST['user_id']) : '';
    $comments = isset($_POST['comments']) ? $conn->real_escape_string($_POST['comments']) : '';
    $approval_status = isset($_POST['approval_status']) ? $conn->real_escape_string($_POST['approval_status']) : '';
    $approval_date = isset($_POST['approval_date']) ? $conn->real_escape_string($_POST['approval_date']) : '';
  $approved_amount = isset($_POST['approved_amount']) ? $_POST['approved_amount'] : null;

    // Check if record already exists
    $check_query = "SELECT id FROM `health_comments` WHERE `user_id` = ?";
    $stmt_check = $conn->prepare($check_query);
    $stmt_check->bind_param("i", $user_id);
    $stmt_check->execute();
    $stmt_check->store_result();

    if ($stmt_check->num_rows > 0) {
        // If record exists, update the existing record
        $update_query = "UPDATE `health_comments` SET `comments` = ?, `approval_status` = ?, `approval_date` = ?, approved_amount = ?,`updated_at` = CURRENT_TIMESTAMP WHERE `user_id` = ?";
        
        $stmt_update = $conn->prepare($update_query);
        $stmt_update->bind_param("sssii", $comments, $approval_status, $approval_date, $approved_amount,$user_id);
        
        if ($stmt_update->execute()) {
            echo "<script>alert('Data updated successfully.');</script>";
                        echo "<script>window.location.href = 'HealthReport.php';</script>";

        } else {
            echo "<script>alert('Error: " . $stmt_update->error . "');</script>";
        }

        // Close update statement
        if ($stmt_update) {
            $stmt_update->close();
        }

    } else {
        // If no record exists, insert a new one
        $insert_query = "INSERT INTO `health_comments` 
    (`user_id`, `comments`, `approval_status`, `approval_date`, `created_at`, `updated_at`, `approved_amount`) 
    VALUES (?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)";
        
$stmt_insert = $conn->prepare($insert_query);
$stmt_insert->bind_param("isssd", $user_id, $comments, $approval_status, $approval_date, $approved_amount);
        
        
        
        if ($stmt_insert->execute()) {
         echo "<script>alert('Data inserted successfully.');</script>";
          echo "<script>window.location.href = 'HealthReport.php';</script>";
            // exit();
        } else {
            echo "<script>alert('Error: " . $stmt_insert->error . "');</script>";
        }

        // Close insert statement
        if ($stmt_insert) {
            $stmt_insert->close();
        }
    }

    // Close check statement
    if ($stmt_check) {
        $stmt_check->close();
    }
}
?>