fetch_messages.php 376 B

123456789
  1. <?php
  2. header('Content-Type: application/json');
  3. $pdo = new PDO('mysql:host=sql101.infinityfree.com;dbname=if0_39567875_nex', 'if0_39567875', 'PIvOR9WViHm'); // Update
  4. $stmt = $pdo->query("SELECT m.*, u.username FROM messages m JOIN users u ON m.user_id = u.id ORDER BY m.created_at ASC");
  5. $messages = $stmt->fetchAll(PDO::FETCH_ASSOC);
  6. echo json_encode($messages);