我是Zend框架的新手。我已经尝试在控制器的每个特定页面的action方法中进行数据库连接,它运行良好。
我正在使用WAMP服务器,但现在我想要学习如何在一个页面上创建数据库连接类,并在不同的action方法中使用它。我想在index页面上建立连接,并在整个项目的所有页面中使用。
以下是我在控制器中的action方法:
public function userAction()
{
$db = Zend_Db_Table::getDefaultAdapter();
$data = array(
'first_name' => 'xyz',
'last_name' => 'xyz',
'user_name' => 'xyz',
'password' => 'xyz'
);
$rows_affected = $db->insert('user', $data);
$last_insert_id = $db->lastInsertId();
}
以下是应用程序配置文件 application.ini,我只在文件中添加了数据库适配器设置。
[production]
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 0
resources.db.adapter = "PDO_MYSQL"//adapter
resources.db.params.host ="localhost" //server name here or host
resources.db.params.username = "root"///username here
resources.db.params.password = "" //database password
resources.db.params.dbname = "zend"//database name
resources.db.isDefaultTableAdapter = true
[staging : production]
[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1