扩展 MySQLi 类

问题描述

我希望能够创建扩展 MySQLi 类以执行其所有 SQL 查询的类.

I want to be able to make classes which extend the MySQLi class to perform all its SQL queries.

$mysql = new mysqli('localhost', 'root', 'password', 'database') or die('error connecting to the database');

如果不将 $mysql 对象全球化以在我的其他方法或类中使用，我不知道如何做到这一点.

I dont know how to do this without globalising the $mysql object to use in my other methods or classes.

class Blog {

public function comment() {
    global $mysql;

    //rest here
}

}

任何帮助将不胜感激.

谢谢.

推荐答案

我的建议是创建一个 Singleton DataAccess 类，在全局配置文件中实例化该类并在您的 Blog 类中调用它，例如 $query = DataAccess::query("SELECT * FROM blog WHERE id = ".$id).

My suggestion is to create a Singleton DataAccess class, instantiate that class in a global config file and call it in your Blog class like $query = DataAccess::query("SELECT * FROM blog WHERE id = ".$id).

看看单例模式，这是一个非常容易理解的设计模式.非常适合这种情况.

Look into the Singleton pattern, it's a pretty easy to understand designpattern. Perfect for this situation.

您的 DataAccess 类可以有多种方法，例如 query、fetchAssoc、numRows、checkUniqueValue、transactionStart、transactionCommit、transactionRollback 等.这些函数也可以设置为由 DataAccess 类实现的接口.这样您就可以轻松地为多个数据库管理系统扩展您的 DataAccess 类.

Your DataAccess class can have several methods like query, fetchAssoc, numRows, checkUniqueValue, transactionStart, transactionCommit, transactionRollback etc etc. Those function could also be setup as an Interface which gets implemented by the DataAccess class. That way you can easily extend your DataAccess class for multiple database management systems.

以上几乎描述了我的 DataAccess 模型.

The above pretty much describes my DataAccess model.

这篇关于扩展 MySQLi 类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！