File "fetch-messages.php"

Full Path: /home/quiczmwg/lightspringdigitals.com/admin/dist/fetch-messages.php
File size: 921 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
require_once('../_db.php');

$userId = $_GET['user'] ?? null;
$productId = $_GET['product'] ?? null;

if ($userId && $productId) {
    $query = "SELECT message, sender_id, created_at, image FROM messages 
              WHERE (sender_id = ? OR receiver_id = ?) AND product_id = ? 
              ORDER BY created_at";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ssi", $userId, $userId, $productId);
    $stmt->execute();
    $result = $stmt->get_result();

    $messages = [];
    while ($row = $result->fetch_assoc()) {
        $messages[] = [
            'message' => $row['message'],
            'image' => $row['image'] ? 'uploads/chat/' . $row['image'] : null, // adjust path if needed
            'isAdmin' => $row['sender_id'] == 'admin',
            'created_at' => date("M j, Y • g:i A", strtotime($row['created_at']))
        ];
    }

    echo json_encode(['messages' => $messages]);
}
?>