Question

当我想将 zend 框架中的数据库与 zend_Db 连接到 zend_Db 中时, 在每个控制器或模型中必须写入此代码 :

$params = array(
 host            =>  127.0.0.1 ,
 username        =>  webuser ,
 password        =>  xxxxxxxx ,
 dbname          =>  test ,
 charset         =>  utf8 
);

但当使用“理论”时,只需在应用中写入此代码即可。 ini

doctrine.dsn = "mysql://user:pass@localhost/dbase"

我如何使用 zend_ Db 在每个文件中设置连接设置?

Answer 1

打开

application/configs/application.ini

添加以下条目

resources.db.adapter = PDO_MYSQL
resources.db.isDefaultAdapter = true
resources.db.params.host = localhost
resources.db.params.username = root
resources.db.params.password = 
resources.db.params.dbname = foo

然后在你的布斯陷阱.php内

do do do 做

public function _initSetup()
{
$this->bootstrap( db );
}

然后,无论何时或何时,只要您需要 db 示例 do do 做

$db = Zend_Db_Table::getDefaultAdapter();

Answer 2

there are two ways one by using your configuration.ini file by this code :

resources.db.adapter = PDO_MYSQL
resources.db.params.host = localhost
resources.db.params.username = root
resources.db.params.password =   
resources.db.params.dbname = dbname
resources.db.params.driver_options.1002 = "SET NAMES utf8;"

或使用 hte 适配器类

$db = new Zend_Db_Adapter_Pdo_Mysql(array(
     host      =>  127.0.0.1 ,
     username  =>  webuser ,
     password  =>  xxxxxxxx ,
     dbname    =>  test 
));

并且不将任何函数放入您的靴套.php 文件

友情链接