php mysql 跨库_PHP PDO-MYSQL：如何跨不同类使用数据库连接

我对使用MYSQL的PDO不熟悉,这是我的两个文件：

我有一个连接类,用于连接到数据库：

class connection{

private $host = 'localhost';

private $dbname = 'devac';

private $username = 'root';

private $password ='';

public $con = '';

function __construct(){

$this->connect();

}

function connect(){

try{

$this->con = new PDO("mysql:host=$this->host;dbname=$this->dbname",$this->username, $this->password);

$this->con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

}catch(PDOException $e){

echo 'We\'re sorry but there was an error while trying to connect to the database';

file_put_contents('connection.errors.txt', $e->getMessage().PHP_EOL,FILE_APPEND);

}

}

}

我有一个account_info类,用于查询数据库中的数据：

class account_info{

function getAccountInfo(){

$acc_info = $this->con->prepare("SELECT * FROM account_info");

$acc_info->execute();

$results = $acc_info->fetchAll(PDO::FETCH_OBJ);

foreach ($results as $key) {

$results->owner_firstname;

}

}

}

我在index.php页面中包含这两个文件：

include_once 'classes/connection.class.php';

include_once 'classes/accountinfo.class.php';

$con = new connection();

$info = new account_info();

$info->getAccountInfo();

我只是不能让它工作我没有得到任何输出,我认为它与范围有关,但我不知道正确的解决它的原因,因为我是这个PDO和OOP的新手.

提前致谢.