《PHP教程：Zend Framework连接Mysql数据库实例分析》要点：
本文介绍了PHP教程：Zend Framework连接Mysql数据库实例分析，希望对您有用。如果有疑问，可以联系我们。
PHP实战本文实例讲述了Zend Framework连接Mysql数据库的办法.分享给大家供大家参考,具体如下：
PHP实战在看这些之前请确保你正确加载了PDO扩展.做法是编辑php.ini .
手动增加这两行(前面要没有分号;)：
PHP实战
extension=php_pdo.dll
extension=php_pdo_mysql.dll
PHP实战然后要把extension_dir
PHP实战指向php_pdo.dll及php_pdo_mysql.dll所在目录,如
PHP实战
extension_dir = "C:/php5/ext"
PHP实战OK,let's go..
PHP实战index.php 网站首页,也是唯一入口
PHP实战
<?php
//...省略
$params = array ('host' => '127.0.0.1',
'username' => 'root',
'password' => '123456',
'dbname' => 'happycms');
$db = Zend_Db::factory('pdoMysql', $params);
Zend::register('db', $db);
?>
PHP实战lib/App/Article.php
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
PHP实战
class articleController extends Zend_Controller_Action {
private $view;
private $article;
function __c****truct() {
$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);
}
}
?>
PHP实战拜访 http://happycms/article/listall
PHP实战得到以下输出：
PHP实战
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"
}
PHP实战更多关于zend相关内容感兴趣的读者可查看本站专题：《Zend FrameWork框架入门教程》、《php优秀开发框架总结》、《Yii框架入门及常用技巧总结》、《ThinkPHP入门教程》、《php面向对象程序设计入门教程》、《php+mysql数据库操作入门教程》及《php常见数据库操作技巧汇总》
PHP实战希望本文所述对大家基于Zend Framework框架的PHP程序设计有所赞助.
《PHP教程：Zend Framework连接Mysql数据库实例分析》是否对您有启发，欢迎查看更多与《PHP教程：Zend Framework连接Mysql数据库实例分析》相关教程，学精学透。维易PHP学院为您提供精彩教程。
转载请注明本页网址：
http://www.vephp.com/jiaocheng/7295.html
