参见英文答案 > How to properly set up a PDO connection 4个
这是制作PDO连接的正确方法吗?
我有不同的类(每个类都有自己的文件)然后有配置文件包含PDO对象和所有类对象.我正确地做了或者有更好的做法.
classA.php
class classA {
private $PDO;
function __construct($PDO) {
$this->PDO = $PDO;
}
//other functions
}
classB.php
class classB {
private $PDO;
function __construct($PDO) {
$this->PDO = $PDO;
}
//other functions
}
classC.php
class classC {
private $PDO;
function __construct($PDO) {
$this->PDO = $PDO;
}
//other functions
}
在config.php页面中:
include_once("db.php"); //contains db variables values
try
{
$PDO = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password, $options);
}
catch(PDOException $ex)
{
die("Failed to connect database: " . $ex->getMessage());
}
require 'classA.php';
require 'classB.php';
require 'classC.php';
$objA = new classA($PDO);
$objB = new classB($PDO);
$objC = new classC($PDO);
几乎每个页面都包含config.php.