php - 如何在php中将数据库连接合并到一个文件中

Question

我目前使用两个不同的连接文件到我的基于 Web 的。

因此，我想将两个连接文件减少并合并为一个。

connection.php 只是简单的连接文件，而 tablemodel.php 用于从数据库中获取数据并在表格中显示表格。

寻找解决方案。谢谢！！

连接.php

<?php
    $conn = new mysqli("localhost","root","","mydatabase");
    if (!$conn) {
        die('Please Check your connection'/mysqli_error($conn));
    }
?>

表模型.php

<?php
class Model
{
private $dbHost = 'localhost';
private $dbUser = 'root';
private $dbPass = '';
private $dbName = 'mydatabase';
private $conn ;

public function __construct(){
   try {
        $this->conn = new mysqli($this->dbHost, $this->dbUser, $this->dbPass, $this->dbName);
        } catch (\Throwable $th) {
            echo "Connection error " . $th->getMessage();
        } }

public function fetch_res(){
        $data = [];
        $query = "SELECT DISTINCT  `name` FROM `name_id`";
        if ($sql = $this->conn->query($query)) {
            while ($row = mysqli_fetch_assoc($sql)) {
                $data[] = $row;
            } }
        return $data;
    }}
?>

标签： phpmysqlidatabase-connection