ZF框架Db类select查询器join链表简单用法
<?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('host' => '127.0.0.1' , 'username' => 'root' , 'password' => '111' , 'dbname' => 'test', 'profiler' => "true" ); //告诉Zend_Db类所操作的数据库和数据库配置信息 $Db = Zend_Db::factory('PDO_Mysql' , $Config); //执行编码语句 $Db -> query("set names utf8"); //----------------------------------------------- $Select = $Db ->select(); $Select -> from('sanguo','*'); $Select -> join('dengji','sanguo.s_dengji = dengji.d_id'); $Select -> order('s_dengji asc'); $Reslut = $Db -> fetchAll($Select); echo "<table border='1' width='600' style='text-align:center'>"; foreach ($Reslut as $key => $value) { echo "<tr>"; foreach ($value as $key2 => $value2) { echo "<td>" . $value2 . "</td>"; } echo "</tr>"; } echo "</table>"; ?>
Copy after login
Statement of this Website
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

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Seashell Riddle Solution
2 weeks ago
By DDD
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics
CakePHP Tutorial
1375
52

