以下的文章主要描述的是在实际操作中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"
- OK,let's go..
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
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() {
- }
省略
- }
- ?>
zend_db连接MySQL(附完整代码)的实际操作中我们要用到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(附完整代码)的介绍,望你能有所收获。
【编辑推荐】