This article mainly introduces the examples of using the Db-type select querytojoin linked list in the zf framework. For more information, see the examples of using the join () linked list in the zend Framework.
The code is as follows:
// 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"
";Foreach ($ Reslut as $ key => $ value){Echo"
";Foreach ($ value as $ key2 => $ value2){Echo"
". $ Value2 ." | ";}Echo"
";}Echo"
";
?>