PHP-使用名称空间创建PDO连接

Question

我有一个项目文件夹名称实用程序。目录列表是：- utilities    - tli        - database            Connection.php    index.phpConnection.php是PDOConnection。代码是：<?phpnamespace app\tli\database;use PDO;use PDOException;Class Connection{    private $server = "mysql:host=localhost;dbname=ytsurumaru_hanwa_coil_v.2";    private $user = "root";    private $pass = "";    private $options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,);    protected $con;    public function openConnection()    {        try {            $this->con = new PDO($this->server, $this->user, $this->pass, $this->options);            return $this->con;        } catch (PDOException $e) {            return "There is some problem in connection: " . $e->getMessage();        }    }    public function closeConnection()    {        $this->con = null;    }}更新的来源现在，我需要index.php中的这个Connection实例<?phpnamespace app;use app\tli\database\Connection;use PDOException as PDOEx;require('tli/database/Connection.php');try {    $connection = new Connection(); // not found    $connection->openConnection();} catch (PDOEx $e) {    echo $e->getMessage();}当我运行它时D:\wamp64\www\utilities\tli>php index.phpWarning: require(tli/database/Connection.php): failed to open stream: No such file or directory in D:\wamp64\www\utilities\tli\index.php on line 8Fatal error: require(): Failed opening required 'tli/database/Connection.php' (include_path='.;C:\php\pear') in D:\wamp64\www\utilities\tli\index.php on line 8如何解决这个，我的名字有问题吗？

Answer 1

这还不足以访问您的数据库连接吗？

require 'tli/database/Connection.php';

然后，由于您位于不同的名称空间并且没有别名，因此在“ try catch块”中，您应该代替：

$connection = new Connection(); // not found

做类似的事情：

$connection = new \tli\database\Connection();

确保正确设置路径。

或者

您可以使用其他名称作为别名，如下所示：

namespace app;

require 'tli/database/Connection.php';

use tli\database\Connection as MyConnection;

$connection = new MyConnection();

Answer 2

您需要使用以下之一：

include('tli/database/Connection.php')

include_once('tli/database/Connection.php')

require('tli/database/Connection.php') 

require_once('tli/database/Connection.php')

或者，如果您需要更多自动化功能，请使用autoloader。您可能需要查看此SO问题以及所有链接的内容。