如何在php的另一个类中导入数据库连接类 - How to import database connection class in another class in php

How to import database connection class in another class in php

我将在控制器类中导入DatabaseConnector类。DatabaseConnector类包含数据库连接查询。这两个类是不同的php文件。

这是我的代码。

DatabaseConnector:

class DatabaseConnector
{
    public $con;
    //function for getting connected to database
    public function getConnection()
    {
        $con=mysqli_connect("localhost","root","","abcd");
        // Check connection
        if (mysqli_connect_errno()) {
          echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }
        return $con;
    }
    public function closeConnection()
    {
        mysqli_close($con);
    }
}

控制器:

include "database_connector.php";
    $dc = new DatabaseConnector();
    $con = $dc->getConnection();
class Controller
{
    public function __construct(){
    }
    public function insertData()
    {
        $name = "Abcde";
        $sql = "insert into user_details values('".$name."')";
        mysql_query($con, $sql);
    }

}

在这段代码中我错了。它显示了mysql_query($con，$sql)上的错误:$con in undefined variable;mysql_query()需要两个参数

请帮帮我。

您的$con不在类中。

include "database_connector.php";
class Controller
{
    protected $con;
    public function __construct(){
        $dc = new DatabaseConnector();
        $this->con = $dc->getConnection();
    }
    public function insertData()
    {
        $name = "Abcde";
        $sql = "insert into user_details values('".$name."')";
        mysqli_query($this->con, $sql);
    }
}

我没有测试代码，但这应该可以工作