作业练习 zend framework ?php/*查询器的使用方法*/isset($_get['page']) ? $page = $_get['page'] : $page = 1;//引入loader类(自动加载类)require_once(zend/loader.php);//使用loader类引入一个db类zend_loader::loadclass(zend_db);//引入zend_db的状
作业练习 zend framework '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);//-----------------------------------------------//使用fetchone()方法得出表的总条数$total = $db -> fetchone(select count(*) from gongsi);//定义每页显示条数$b = 50;//得出总页数$a = ceil($total/$b);//-----接下来为一系列的查询表、取结果集、分页等操作$select = $db ->select();$select -> from('sanguo',array('s_sheng as 省份','sum(s_gongzi) as 总工资','min(s_gongzi) as 最低工资','max(s_gongzi) as 最高工资','avg(s_gongzi) as 平均工资'));// $select -> where('s_gongzi>=3000');// $select -> where(s_sheng='河北');// $select -> order('s_sheng asc');// $select -> order('s_gongzi desc');$select -> group('s_sheng'); //分组//$select -> having('最高工资>10000'); //附加条件$select -> order('最高工资 desc'); //排序$select -> limit(0,0); //截取$select -> limitpage($page, $b); //分页/*sql语句相当于：select s_sheng as 省份,sum(s_gongzi) as 最高工资 from sanguo group by s_sheng having 最高工资>10000 order by 最高工资 desc limit 0,10;*/$result = $db->fetchall($select);echo ;echo 省份总工资最低工资最高工资平均工资
;foreach ($result as $key => $value) { echo ; foreach ($value as $key2 => $value2) { echo . $value2 . ; } echo
;}echo ;echo ;echo 首页 ;if ($page>1) { echo 上页 ;}for ($i=1; $i <=15 ; $i++) { echo .$i. ;}if ($page