php - 关闭 MySQL 连接 (PHP)

Question

我编写了一个类来创建与 MySQL 的自动连接并创建查询。这是它的样子:

include("constants.php");

class MySQLDB {
    var $connection;

    function __construct() {
        $this->connection = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die(mysql_error());
        mysql_select_db(DB_NAME, $this->connection);
        mysql_set_charset('utf8', $this->connection);
    }

    // SELECT ALL FROM
    function sf($unit, $table) {
        return mysql_query("SELECT ".$unit." FROM ".$table, $this->connection);
    }
        // and so on...
}

$mysql = new MySQLDB;

现在，我认为在其他 php 页面中运行其中一些函数后关闭连接会更好。那么我该如何在这门课中做到这一点(最有效的方法)？

我尝试在类(class)末尾(右括号之前)添加 mysql_close($this->connection); 但它给了我一个错误。

Answer 1

如果您阅读 manual，您可能不需要这个它说:

Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

如果你仍然想使用它你需要但是类中的函数...

      function close() {
          mysql_close($this->connection);
      }
          // and so on...
 }
$mysql = new MySQLDB;