下面的文章主要讲述的是zend_db 连接mysql( 附完整代码），在看这些东西之前你确保是对pdo扩展以进行了正确的加载。我们的具体做法是编辑php.ini，对其进行手动增加下面这两行（前面要没有分号;）：
extension=php_pdo.dll
extension=php_pdo_mysql(和php搭配之最佳组合).dll
然后要把extension_dir
指向php_pdo.dll及php_pdo_mysql(和php搭配之最佳组合).dll所在目录，如
extension_dir = c:\php5\ext
index.php 网站首页，也是唯一入口
php代码如下:
php //...省略 $params = array ('host' => '127.0.0.1', 'username' => 'root', 'password' => '123456', 'dbname' => 'happycms'); $db = zend_db::factory('pdomysql(和php搭配之最佳组合)', $params); zend::register('db', $db); ?> lib/app/article.php
zend_db 连接mysql中：php代码如下:
php class app_article { private $db; function app_article() { $this->db = zend::registry('db'); } function listall() { $result = $this->db->query('select * from article'); $rows = $result->fetchall(); zend::dump($rows); } function listbycategory() { } //...省略 } ?>
php代码如下:
articlecontroller.php class articlecontroller extends zend_controller_action { private $view; private $article; function __construct() { $this->view = zend::registry('view'); $this->article = new app_article(); } public function listallaction() { $this->article->listall(); $this->view->title='view articles'; echo $this->view->render(tpl_dir.'/tplview.php'); } function __call($action, $arguments) { $this->_redirect('./'); print_r($action); print_r($arguments); } } ?>
访问 http://happycms/article/listall
得到以下输出：
array(1) { [0] => array(15) { [articleid] => string(1) 1 [categoryid] => string(1) 0 [articletitle] => string(4) test\ [articlefromwhere] => string(3) sdf [articlekeywords] => string(5) sdfds [articledescription] => string(4) test [articlebody] => string(9) sffsdfsdf [authorname] => string(8) haohappy [authoremail] => string(11) s...@df.com [issticky] => string(1) 0 [isrecommanded] => string(1) 0 [includeattachment] => string(1) 0 [addtime] => string(19) 0000-00-00 00:00:00 [lastedittime] => string(19) 0000-00-00 00:00:00 [checktime] => string(19) 0000-00-00 00:00:00 }
以上的相关内容就是对zend_db连接mysql(附完整代码）的介绍，望你能有所收获。