PHP MVC项目架构详解

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mvc_db";
?>

<?php
class UserModel {
  public function getUsers() {
    $conn = new mysqli($servername, $username, $password, $dbname);
    $sql = "SELECT * FROM users";
    $result = $conn->query($sql);
    return $result;
  }
}
?>

<?php
$users = $userModel->getUsers();
?>
<table>
  <thead>
    <tr>
      <th>ID</th>
      <th>Name</th>
      <th>Email</th>
    </tr>
  </thead>
  <tbody>
    <?php foreach ($users as $user): ?>
      <tr>
        <td><?php echo $user['id']; ?></td>
        <td><?php echo $user['name']; ?></td>
        <td><?php echo $user['email']; ?></td>
      </tr>
    <?php endforeach; ?>
  </tbody>
</table>

<?php
class UsersController {
  public function index() {
    $userModel = new UserModel();
    require_once 'View/users.php';
  }
}

<?php
require_once 'config.php';
$controller = new UsersController();
$controller->index();
?>