zend frameword 链接数据库实例

配置apalication.ini

[mysql]

db.adapter=PDO_MYSQL

db.params.host=localhost

db.params.username=root

db.params.password=root

db.params.dbname=dbname

初始化数据库适配器

在Bootstrap.php添加构造函数

function __construct($app){

//parent::__costruct($applaction);

parent::__construct($app);

//初始化我们的数据库适配器

$url=constant("APPLICATION_PATH").DIRECTORY_SEPARATOR.'configs'.DIRECTORY_SEPARATOR."application.ini";

$dbconfig = new Zend_Config_Ini($url,"mysql");

$db = Zend_Db::factory($dbconfig->db);

$db->query('SET NAMES UTF8');

Zend_Db_Table::setDefaultAdapter($db);

}

写model

 UserManager.php

<?php

class UserManager extends Zend_Db_Table{

protected $_name = 'emp';

protected $_primary = 'id';

}

?>

在控制器调用

  $usermanager = new UserManager();

  $res = $usermanager->fetchAll()->toArray();

  $this->view->res = $res;

在view中显示

<?php 

echo "<table border='1'>";

$res = $this->res;

foreach ($res as $message){

echo "<tr>";

echo "<td>".$message['id']."</td>";

echo "<td>".$message['empname']."</td>";

echo "</tr>";

}

echo "</table>";

?>