Welcome 微信登录

首页 / 网页编程 / PHP / 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啦,浏览器显示:
zend framework配置操作数据库