连接到数据库时未定义的变量


Undefined variable when connecting to a database

我不知道为什么当我尝试调用connect()方法时userhostpassword变量未定义

    $app->get('/get', function () use($app){
        $db = new Db_handler;
        $db->connect();
    }
);

这是Db_handler类本身

    <?php
        class Db_handler{
                private $driver;
                private $host;
                private $port;
                private $schema;
                private $username;
                private $password;
                function Db_handler( $config_file = 'connection.ini' ){
                        if(!$connection_data = parse_ini_file($config_file, true)) throw new exception("No se puedo abrr el fichero de configuracion ".$config_file." .");
                        $driver = $connection_data["database"]["driver"];
                        $host = $connection_data["database"]["host"];
                        $port = $connection_data["database"]["port"];
                        $schema = $connection_data["database"]["schema"];
                        $username = $connection_data["database"]["username"];
                        $password = $connection_data["database"]["password"];
                        echo $host;
                        echo $username;
                        echo $password;
                }
                function connect(){
                        $link = mysql_connect($host, $username, $root)
                        or die('No se pudo conectar: ' . mysql_error());
                }
        }
?>

构造函数的回显正确显示变量。

在构造函数和 connect() 方法中,使用 $this 为每个变量名称添加前缀。

$this->driver = ...
$this->host   = ...

等。

编辑连接函数。更改此行:

$link = mysql_connect($host, $username, $root)

对此:

$link = mysql_connect($this->host, $this->username, $this->password)

函数连接中使用的变量是未初始化的局部变量。当您将关键字$this与指针 -> 一起使用时,您将调用已在构造函数中定义的类变量。同样重要的是,在构造函数中设置类私有变量也很重要:

$this->driver = $connection_data["database"]["driver"];
$this->host = $connection_data["database"]["host"];
$this->port = $connection_data["database"]["port"];
$this->schema = $connection_data["database"]["schema"];
$this->username = $connection_data["database"]["username"];
$this->password = $connection_data["database"]["password"];

我认为未定义的变量只是$root。你打电话给mysql_connect($host, $username, $root) 而且$root没有在任何地方声明。