zend 数据库连接

发布于 2025-01-04 23:43:45 字数 287 浏览 0 评论 0原文

在我们的一个项目中，application.ini 中指定的数据库连接是

resources.db.adapter = Mysqli
resources.db.params.host = localhost
resources.db.params.username = root
resources.db.params.password = ''
resources.db.params.dbname = zf_tutorial

但我需要从另一个文件调用主机、用户名、密码和数据库名。怎么办？

原文

In one of our project the database connection specified in application.ini is

resources.db.adapter = Mysqli
resources.db.params.host = localhost
resources.db.params.username = root
resources.db.params.password = ''
resources.db.params.dbname = zf_tutorial

But I required to call the host, username, password and dbname from another file. how to do this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

煞人兵器 2025-01-11 23:43:45

通常，在 application.ini 中设置数据库后，调用默认适配器就很简单了

$db = Zend_Db_Table::getDefaultAdapter();
将 resources.db.isDefaultTableAdapter = true 添加到 application.ini 可确保您调用正确的适配器。
在很多情况下，这可能无法正常工作，其中大多数涉及引导。

回复收藏 0 原文

晨曦慕雪 2025-01-11 23:43:45

通常，与数据库的连接在index.php中设置：

// TODO: $adapter and $params from custom place, not hardcoded
$adapter = 'pdo_mysql';
$params = array(
    'host' => 'localhost',
    'username' => 'root',
    'password' => '',
    'dbname' => 'mydb'
);
$db = Zend_Db::factory($adapter, $params);
Zend_Db_Table_Abstract::setDefaultAdapter($db);

在此代码中$adapter和$params是硬编码的。您可以从自定义文件中获取 $adapter 和 $params。

Usually, connection to the DB sets up in index.php:

// TODO: $adapter and $params from custom place, not hardcoded
$adapter = 'pdo_mysql';
$params = array(
    'host' => 'localhost',
    'username' => 'root',
    'password' => '',
    'dbname' => 'mydb'
);
$db = Zend_Db::factory($adapter, $params);
Zend_Db_Table_Abstract::setDefaultAdapter($db);

In this code $adapter and $params are hardcoded. You can get $adapter and $params from your custom file.

回复收藏 0 原文

情话墙 2025-01-11 23:43:45

这里接受的答案不是获取 db 对象的好方法，它应该像您最初所做的那样在 application.ini 中设置。

如果您想获取 db 对象的另一个实例，您有多种选择；您可以按照@RockyFord的建议进行操作，或者您可以从任何控制器获取数据库对象，如下所示：-

$db = $this->getInvokeArg('bootstrap')->getResource('db');

如果您想更进一步并有权访问连接详细信息（我无法想象为什么你会再次需要它们）您可以像这样从 db 对象获取它们：-

$dbConfig = $db->getConfig();

或者确实：-

$dbConfig = $this->getInvokeArg('bootstrap')->getResource('db')->getConfig();

这将为您提供一个包含连接数据的数组，您可以尝试这样做并执行 var_dump($dbConfig); 来查看细节。

如果需要的话，这是一种更可靠的访问数据库对象的方法，尽管如果您需要在多个地方执行此操作，特别是在访问连接详细信息时，我会仔细研究您的整体代码设计如此处所述。

The accepted answer here is not a good way to get the db object, it should be set up in application.ini as you were doing originally.

If you want to get another instance of the db object you have several options; you can do as @RockyFord suggests, or you can get the db object from any controller like this:-

$db = $this->getInvokeArg('bootstrap')->getResource('db');

If you want to go further and have access to the connection details (I can't imagine why you would need them again) then you can get them from the db object like this:-

$dbConfig = $db->getConfig();

or indeed:-

$dbConfig = $this->getInvokeArg('bootstrap')->getResource('db')->getConfig();

Which will give you an array containing the connection data, you can try this and do a var_dump($dbConfig); to see the details.

This is a much more robust way of accessing the db object if you need to, although I would take a long hard look at your overall code design if you need to do this in more than one place, especially if you are accessing the connection details as described here.

回复收藏 0 原文

~没有更多了~