zend framework项目建立后,看了下zend framework配置操
来源:自学PHP网
时间:2014-09-18 13:10 作者:
阅读:次
[导读] zend framework项目建立后,看了下zend framework配置操作数据库,本文将详细介绍,需要了解的朋友可以参考下...
zendframework项目环境搭建后,看了下zend framework配置操作数据库,php教程如下: 在application/configs的文件下建立一个config.ini文件 配置信息如下: [general] db.adapter=PDO_MYSQL db.config.host=localhost/IParess db.config.username=username db.config.password=password db.config.dbname=databasename 2、 在pulibc 目录的index.php页面中 /** Zend_Application */ require_once 'Zend/Application.php'; 的下面插入 //set the datase config require_once 'Zend/Config/Ini.php'; require_once 'Zend/Registry.php'; require_once 'Zend/Db.php'; require_once 'Zend/Db/Table.php'; $config=new Zend_Config_Ini('./../application/configs/config.ini',null, true); Zend_Registry::set('config',$config); $dbAdapter=Zend_Db::factory($config->general->db->adapter,$config->general->db->config->toArray()); $dbAdapter->query('SET NAMES UTF8'); Zend_Db_Table::setDefaultAdapter($dbAdapter); Zend_Registry::set('dbAdapter',$dbAdapter); 就此,我就用我的本地wordpress数据库来测试下,就用wp_posts表来测试吧: 首先模型models建立Wp_posts.php
复制代码 代码如下: <?php class Wp_posts extends Zend_Db_Table{ protected $_name = 'Wp_posts'; protected $_primary = 'ID'; } ?>
控制器controller下面建立IndexController.php
复制代码 代码如下: <?php require_once APPLICATION_PATH.'/models/Wp_posts.php'; class IndexController extends Zend_Controller_Action { public function init() { /* Initialize action controller here */ } public function indexAction() { $con = new Wp_posts(); $res = $con->fetchAll()->toArray(); $this->view->res = $res; $this->render("index"); } }
在views/scripts/index/ 建立视图:index.phtml
复制代码 代码如下: <html> <head> <title>this is for test</title> </head> <body> <table> <?php foreach ($this->res as $news){?> <tr> <td><?php echo $news['id']?></td> <td><?php echo $news['post_title']?></td> <td><?php echo $news['post_date']?> </td> </tr> <?php }?> </table> </body> </html>
ok啦,浏览器显示:
|
|