Example of using the join () linked list as the queryer of the zend framework
Copy codeThe Code is as follows:
<? Php
// Introduce the Loader class (automatic loading class)
Require_once ("Zend/Loader. php ");
// Use the Loader class to introduce a Db class
Zend_Loader: loadClass ("Zend_Db ");
// Introduce the Zend_Db status Server
Zend_Loader: loadClass ("Zend_Db_Statement_Pdo ");
// Configure database connection information
$ Config = array ('host' => '2017. 0.0.1 ',
'Username' => 'root ',
'Password' => '123 ',
'Dbname' => 'test ',
'Filer' => "true"
);
// Inform Zend_Db of the database and database configuration information operated by the class
$ Db = Zend_Db: factory ('pdo _ mysql', $ Config );
// Execute the encoding statement
$ 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 = '000000' style = 'text-align: Center'> ";
Foreach ($ Reslut as $ key => $ value)
{
Echo "<tr> ";
Foreach ($ value as $ key2 => $ value2)
{
Echo "<td>". $ value2. "</td> ";
}
Echo "</tr> ";
}
Echo "</table> ";
?>