How to show data users from the database on the site with MVC-PHP 8?

I have an mvc folder, In the folder are 5 file

index.php
route.php
User.php
UserController.php
view.php

index.php

<?php

require_once 'route.php';

route.php

<?php

require_once 'UserController.php';

$controller = new UserController();

if ($_SERVER['REQUEST_METHOD'] === 'GET') {
    if ($_SERVER['REQUEST_URI'] === '/') {
        $controller->index();
    }
}

UserController.php

<?php

require_once 'User.php';

class UserController {
    private $user;

    public function __construct() {
        $this->user = new User();
    }

    public function index() {
        $users = $this->user->getAll();
        require 'view.php';
    }

    // Add more methods here to handle other requests
}

User.php

<?php

class User {
    private $db;

    public function __construct() {
        $this->db = new PDO('mysql:host=localhost;dbname=php', 'root', '');
    }

    public function getAll() {
        $stmt = $this->db->query('SELECT * FROM users');
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    // Add more methods here to interact with the database
}

view.php

<!DOCTYPE html>
<html>
<head>
    <title>Users</title>
</head>
<body>
    <h1>Users</h1>
    <ul>
        <?php foreach ($users as $user): ?>
            <li><?= $user['id'] ?></li>
            <li><?= $user['name'] ?></li>
            <li><?= $user['email'] ?></li>
        <?php endforeach ?>
    </ul>
</body>
</html>

This code does not display any data correctly.

vincent15000

3 years ago

Level 63

You have here a very good tutorial on PHP, Jeffrey Way explains step by step how to use PHP to build a first small application with an MVC architecture.

https://laracasts.com/series/php-for-beginners-2023-edition

I find that this serie is a very good introduction to understand how Laravel is developed.

Please or to participate in this conversation.