zend framework配置操作数据库实例分析

时间:2022-08-25 20:51:43

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啦,浏览器显示:

zend framework配置操作数据库实例分析