Home >php教程 >PHP源码 >ZF框架Db类select查询器join链表简单用法

ZF框架Db类select查询器join链表简单用法

PHP中文网
PHP中文网Original
2016-05-25 16:59:441120browse

<?php
/*查询器的join()链表使用方法*/

//引入Loader类(自动加载类)
require_once("Zend/Loader.php");
//使用Loader类引入一个Db类
Zend_Loader::loadClass("Zend_Db");
//引入Zend_Db的状态器
Zend_Loader::loadClass("Zend_Db_Statement_Pdo");
//配置数据库连接信息
$Config = array(&#39;host&#39; => &#39;127.0.0.1&#39; ,
				&#39;username&#39; => &#39;root&#39; , 
				&#39;password&#39; => &#39;111&#39; , 
				&#39;dbname&#39; => &#39;test&#39;,
				&#39;profiler&#39; => "true"
				);
//告诉Zend_Db类所操作的数据库和数据库配置信息
$Db = Zend_Db::factory(&#39;PDO_Mysql&#39; , $Config); 
//执行编码语句 
$Db -> query("set names utf8");
//-----------------------------------------------
$Select = $Db ->select();
$Select -> from(&#39;sanguo&#39;,&#39;*&#39;);
$Select -> join(&#39;dengji&#39;,&#39;sanguo.s_dengji = dengji.d_id&#39;);
$Select -> order(&#39;s_dengji asc&#39;);
$Reslut = $Db -> fetchAll($Select);
echo "<table border=&#39;1&#39; width=&#39;600&#39; style=&#39;text-align:center&#39;>";
foreach ($Reslut as $key => $value) 
{
	echo "<tr>";
	foreach ($value as $key2 => $value2) 
	{
		echo "<td>" . $value2 . "</td>";
	}
	echo "</tr>";
}
echo "</table>";
?>

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn