当前位置：文江博客话题详情

我应该将 MySQL 数据库连接放在 PHP 函数中吗？

发布于 2024-11-06 21:02:26 字数 54 浏览 1 评论 0原文

将我的 MySQL 数据库连接放置在 PHP 函数中以便其他 PHP 函数可以使用它是否安全？

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

—━☆沉默づ 2024-11-13 21:02:26

是的。这是个好主意。

我什至把我的放在一个班级里。

class database {

     protected $databaseLink;

     function __construct($mysql_db, $mysql_user, $mysql_pass, $mysql_dbName){
            $this->databaseName = $mysql_dbName;
            $this->database = $mysql_db;
            $this->mysql_user = $mysql_user;
            $this->mysql_pass = $mysql_pass;
            $this->openConnection();
      }

      function openConnection(){
            $this->databaseLink = mysql_connect($this->database, $this->mysql_user, $this->mysql_pass);
            mysql_select_db($this->databaseName, $this->databaseLink);
      }

      function get_link(){
            return $this->databaseLink;
      }

}

然后你可以这样做：

 $db = new database('database', 'username', 'password', 'dbName');

 //to do a query:
 mysql_query("some query", $db->get_link());

Yes. it is a good idea.

I even place mine in a class.

class database {

     protected $databaseLink;

     function __construct($mysql_db, $mysql_user, $mysql_pass, $mysql_dbName){
            $this->databaseName = $mysql_dbName;
            $this->database = $mysql_db;
            $this->mysql_user = $mysql_user;
            $this->mysql_pass = $mysql_pass;
            $this->openConnection();
      }

      function openConnection(){
            $this->databaseLink = mysql_connect($this->database, $this->mysql_user, $this->mysql_pass);
            mysql_select_db($this->databaseName, $this->databaseLink);
      }

      function get_link(){
            return $this->databaseLink;
      }

}

Then you can just do:

 $db = new database('database', 'username', 'password', 'dbName');

 //to do a query:
 mysql_query("some query", $db->get_link());

回复收藏 0 原文

耳钉梦 2024-11-13 21:02:26

您可能不想在常规 PHP 函数 中创建它。如果您将有多个其他函数在同一脚本中访问数据库连接，请记住，如果您执行类似

function get_db()
{
  $db = mysql_connect(...);
  return $db;
}

“Then”的操作，则每次调用它时，您都将创建并返回一个新连接。最好在类中为每个脚本创建一次作为 Singleton，并让类方法将数据库一个连接返回到调用它的任何函数。

编辑尼尔的答案实际上很好地演示了单例模式。用更完整的代码答案打败我。

You probably don't want to create it in a regular PHP function. If you will have multiple other functions accessing the db connection in the same script, remember that if you do something like

function get_db()
{
  $db = mysql_connect(...);
  return $db;
}

Then each time you call it, you will be creating and returning a new connection. It may be better to create it once per script inside a class as a Singleton, and have a class method return the database one connection to any function that calls it.

EDIT Neal's answer actually demonstrates the singleton pattern for this nicely. Beat me to it with a more code-complete answer.

回复收藏 0 原文