<?php
// Database connection
$con = mysqli_connect("localhost", "chemtech", "chemtech@123", "chemtech");
if (!$con) {
    die("Connection failed: " . mysqli_connect_error());
}

// Check if the reply message and message ID are set
if (isset($_POST['message']) && isset($_POST['message_id'])) {
    $message = mysqli_real_escape_string($con, $_POST['message']);
    $message_id = intval($_POST['message_id']);
    $sender = 'support';  // Admin is replying

    // Get the user_id of the message to send the reply to the correct user
    $query = "SELECT user_id FROM chat_messages WHERE id = $message_id";
    $result = mysqli_query($con, $query);
    $row = mysqli_fetch_assoc($result);
    $user_id = $row['user_id'];

    // Insert the reply message into the database
    $reply_query = "INSERT INTO chat_messages (user_id, message, sender) VALUES ($user_id, '$message', '$sender')";

    if (mysqli_query($con, $reply_query)) {
        echo "Reply sent successfully.";
    } else {
        echo "Error: " . mysqli_error($con);
    }
} else {
    echo "Required parameters missing.";
}

// Close the database connection
mysqli_close($con);
?>
