Rumah > Artikel > pangkalan data > zend_db 连接MySQL( 附完整代码)实操
下面的文章主要讲述的是zend_db 连接MySQL( 附完整代码),在看这些东西之前你确保是对PDO扩展以进行了正确的加载。我们的具体做法是编辑php.ini,对其进行手动增加下面这两行(前面要没有分号;): extension=php_pdo.dll extension=php_pdo_MySQL(和PHP搭
下面的文章主要讲述的是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所在目录,如
<ol class="dp-xml"><li class="alt"><span><span class="attribute">extension_dir</span><span> = </span><span class="attribute-value">"C:\php5\ext"</span><span> </span></span></li></ol>
index.php 网站首页,也是唯一入口
PHP代码如下:
<ol class="dp-xml"> <li class="alt"><span><span class="tag"></span><span class="tag-name">php</span><span> </span></span></li> <li><span>//...省略 </span></li> <li class="alt"> <span>$</span><span class="attribute">params</span><span> = </span><span class="attribute-value">array</span><span> ('host' =</span><span class="tag">></span><span> '127.0.0.1', </span> </li> <li> <span>'username' =</span><span class="tag">></span><span> 'root', </span> </li> <li class="alt"> <span>'password' =</span><span class="tag">></span><span> '123456', </span> </li> <li> <span>'dbname' =</span><span class="tag">></span><span> 'happycms'); </span> </li> <li class="alt"> <span>$</span><span class="attribute">db</span><span> = </span><span class="attribute-value">Zend_Db</span><span>::factory('pdo</span>MySQL<span>(和PHP搭配之最佳组合)', $params); </span> </li> <li><span>Zend::register('db', $db); </span></li> <li class="alt"> <span class="tag">?></span><span> </span> </li> <li><span>lib/App/Article.php </span></li> </ol>
zend_db 连接MySQL中:PHP代码如下:
<ol class="dp-xml"> <li class="alt"><span><span class="tag"></span><span class="tag-name">php</span><span> </span></span></li> <li><span>class App_Article { </span></li> <li class="alt"><span>private $db; </span></li> <li><span>function App_Article() { </span></li> <li class="alt"> <span>$this-</span><span class="tag">></span><span class="attribute">db</span><span> = </span><span class="attribute-value">Zend</span><span>::registry('db'); </span> </li> <li><span>} </span></li> <li class="alt"><span>function listAll() { </span></li> <li> <span>$</span><span class="attribute">result</span><span> = $this-</span><span class="tag">></span><span>db-</span><span class="tag">></span><span>query('SELECT * FROM article'); </span> </li> <li class="alt"> <span>$</span><span class="attribute">rows</span><span> = $result-</span><span class="tag">></span><span>fetchAll(); </span> </li> <li><span>Zend::dump($rows); </span></li> <li class="alt"><span>} </span></li> <li><span>function listByCategory() { </span></li> <li class="alt"><span>} </span></li> <li><span>//...省略 </span></li> <li class="alt"><span>} </span></li> <li> <span class="tag">?></span><span> </span> </li> </ol>
PHP代码如下:
<ol class="dp-xml"> <li class="alt"><span><span>ArticleController.php </span></span></li> <li><span>class articleController extends Zend_Controller_Action { </span></li> <li class="alt"><span>private $view; </span></li> <li><span>private $article; </span></li> <li class="alt"><span>function __construct() { </span></li> <li> <span>$this-</span><span class="tag">></span><span class="attribute">view</span><span> = </span><span class="attribute-value">Zend</span><span>::registry('view'); </span> </li> <li class="alt"> <span>$this-</span><span class="tag">></span><span class="attribute">article</span><span> = </span><span class="attribute-value">new</span><span> App_Article(); </span> </li> <li><span>} </span></li> <li class="alt"><span>public function listAllAction() { </span></li> <li> <span>$this-</span><span class="tag">></span><span>article-</span><span class="tag">></span><span>listAll(); </span> </li> <li class="alt"> <span>$this-</span><span class="tag">></span><span>view-</span><span class="tag">></span><span class="attribute">title</span><span>=</span><span class="attribute-value">'View Articles'</span><span>; </span> </li> <li> <span>echo $this-</span><span class="tag">></span><span>view-</span><span class="tag">></span><span>render(TPL_DIR.'/tplView.php'); </span> </li> <li class="alt"><span>} </span></li> <li><span>function __call($action, $arguments) </span></li> <li class="alt"><span>{ </span></li> <li> <span>$this-</span><span class="tag">></span><span>_redirect('./'); </span> </li> <li class="alt"><span>print_r($action); </span></li> <li><span>print_r($arguments); </span></li> <li class="alt"><span>} </span></li> <li><span>} </span></li> <li class="alt"> <span class="tag">?></span><span> </span> </li> </ol>
访问 http://happycms/article/listall
得到以下输出:
<ol class="dp-xml"> <li class="alt"><span><span>array(1) { </span></span></li> <li> <span>[0] =</span><span class="tag">></span><span> array(15) { </span> </li> <li class="alt"> <span>["articleid"] =</span><span class="tag">></span><span> string(1) "1" </span> </li> <li> <span>["categoryid"] =</span><span class="tag">></span><span> string(1) "0" </span> </li> <li class="alt"> <span>["articletitle"] =</span><span class="tag">></span><span> string(4) "test\" </span> </li> <li> <span>["articlefromwhere"] =</span><span class="tag">></span><span> string(3) "sdf" </span> </li> <li class="alt"> <span>["articlekeywords"] =</span><span class="tag">></span><span> string(5) "sdfds" </span> </li> <li> <span>["articledescription"] =</span><span class="tag">></span><span> string(4) "test" </span> </li> <li class="alt"> <span>["articlebody"] =</span><span class="tag">></span><span> string(9) "sffsdfsdf" </span> </li> <li> <span>["authorname"] =</span><span class="tag">></span><span> string(8) "haohappy" </span> </li> <li class="alt"> <span>["authoremail"] =</span><span class="tag">></span><span> string(11) "s...@df.com" </span> </li> <li> <span>["issticky"] =</span><span class="tag">></span><span> string(1) "0" </span> </li> <li class="alt"> <span>["isrecommanded"] =</span><span class="tag">></span><span> string(1) "0" </span> </li> <li> <span>["includeattachment"] =</span><span class="tag">></span><span> string(1) "0" </span> </li> <li class="alt"> <span>["addtime"] =</span><span class="tag">></span><span> string(19) "0000-00-00 00:00:00" </span> </li> <li> <span>["lastedittime"] =</span><span class="tag">></span><span> string(19) "0000-00-00 00:00:00" </span> </li> <li class="alt"> <span>["checktime"] =</span><span class="tag">></span><span> string(19) "0000-00-00 00:00:00" </span> </li> <li><span>} </span></li> </ol>
以上的相关内容就是对zend_db连接MySQL(附完整代码)的介绍,望你能有所收获。