<?php
// save_message.php

// Database connection parameters
$servername = "localhost";
$username = "chemtech";
$password = "chemtech@123";
$dbname = "chemtech";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die(json_encode(["status" => "error", "message" => "Connection failed: " . $conn->connect_error]));
}

// Get message and sender from POST request
$message = isset($_POST['message']) ? trim($_POST['message']) : '';
$sender = isset($_POST['sender']) ? trim($_POST['sender']) : '';

// Validate input
if (empty($message) || empty($sender)) {
    echo json_encode(["status" => "error", "message" => "Message or sender is missing!"]);
    exit;
}

// Sanitize input to prevent XSS or unwanted characters
$message = htmlspecialchars($message, ENT_QUOTES, 'UTF-8');
$sender = htmlspecialchars($sender, ENT_QUOTES, 'UTF-8');

// Prepare and bind
$stmt = $conn->prepare("INSERT INTO messages (message, sender) VALUES (?, ?)");
$stmt->bind_param("ss", $message, $sender);

// Execute the statement
if ($stmt->execute()) {
    echo json_encode(["status" => "success", "message" => "Message saved successfully!"]);
} else {
    echo json_encode(["status" => "error", "message" => "Error saving message: " . $stmt->error]);
}

$stmt->close();
$conn->close();
?>
