<?php
// save_message.php

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get data from POST
    $message = isset($_POST['message']) ? $_POST['message'] : '';
    $sender = isset($_POST['sender']) ? $_POST['sender'] : '';

    // Validate input
    if (!empty($message) && !empty($sender)) {
        // Database connection (change the credentials as per your setup)
        try {
            $pdo = new PDO('mysql:host=localhost;dbname=chemtech', 'chemtech', 'chemtech@123');
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            // Insert message into the database
            $stmt = $pdo->prepare("INSERT INTO messages (message, sender) VALUES (?, ?)");
            $stmt->execute([$message, $sender]);

            echo "✅ Message saved successfully!";
        } catch (PDOException $e) {
            echo "❌ Error: " . $e->getMessage();
        }
    } else {
        echo "❌ Invalid input.";
    }
}
?>
