pdo 连接mysql 不选数据库,使用PDO选择多个数据库

I have a functions.php file that has one PDO Connection i use to access the database and all that good stuff it's this one:

$host = "localhost";

$db = "maindatabase";

$adminuser = "admin";

$adminpw = "123456";

global $connection;

$connection = new Connection($host,$adminuser,$adminpw,$db);

And i require this script on every file that needs to access to the database, the thing is in some cases i want to change from $db = "maindatabase"; to $db = "anotherdb"; and i know i can do it with just a setter

$connection->setDatabase("anotherdb");

But since i require the functions.php file into every other file i don't know if it will overwrite itself back to default, does anybody knows how can i change it and make it stay ?

EDIT

I have changed require to require_once in my code and since the PHP Documentation says if the file has already been required it will not add it again, do you think this will solve the issue ?

解决方案

This is the classic problem with global variables. Your program state is unpredictable. You can't know which database you're referring to.

Your solution is proper dependency injection.

Implement a factory class to generate the correct database connection on demand, and don't use global variables. That's the correct solution.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值