| 123456789 |
- <?php
- header('Content-Type: application/json');
- $pdo = new PDO('mysql:host=sql101.infinityfree.com;dbname=if0_39567875_nex', 'if0_39567875', 'PIvOR9WViHm'); // Update
- $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");
- $messages = $stmt->fetchAll(PDO::FETCH_ASSOC);
- echo json_encode($messages);
|