send-message.php

<?php

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $date = $_POST['date'];
    $id = $_POST['user_id'];
    $msg = $_POST['msg'];


    // Create a new SQLite database connection
    $db = new SQLite3('db.sqlite');
    // Prepare the INSERT statement
    $stmt = $db->prepare('INSERT INTO main.chat_history (date, user_id, human) VALUES (:date, :user_id, :human)');

    // Bind the parameters and execute the statement for each row of data
    $row = ['date' => $date, 'user_id' => $id, 'human' => $msg];

    $stmt->bindValue(':date', $row['date']);
    $stmt->bindValue(':user_id', $row['user_id']);
    $stmt->bindValue(':human', $row['human']);
    $stmt->execute();


    //
    // Close the database connection
    // Set the HTTP response header to indicate that the response is JSON
    header('Content-Type: application/json');
    
    // data
    $data = [
        "id" => $db->lastInsertRowID()
    ];

    // Convert the chat history array to JSON and send it as the HTTP response body
    echo json_encode($data);

    $db->close();
}