时间:2021-07-01 10:21:17 帮助过:4人阅读
  显示某一页的数据  
 每页30行,从数据库取得数据然后用一个template显示  
 
 ' selected');$auclist=C::t('auction_inauctions')->fetch_all_by_sql('status=1 AND uid='.$_G['uid'].' AND ovtime>'.strtotime(date("Y-m-d H:i:s")),'ORDER BY inputtime desc',$start,$perpage);//C是discuz数据库操作的静态类,t方法指定操作的表  fetch_all_by_sql加查询条件得到结果集$count=C::t('auction_inauctions')->fetch_all_by_sql('status=1 AND uid='.$_G['uid'].' AND ovtime<'.strtotime(date("Y-m-d H:i:s")),'','','',1);$multipage = multi($count, $perpage, $page, $mpurl);//multi是discuz的分页函数include template('home/auction_inauctions');//将结果分配到模板展现?>     if(!defined('IN_DISCUZ')) {  
 exit('Access Denied');  
 }   //如果未定义'IN_DISCUZ' 直接退出;  
 $page=$_GET['page']?$_GET['page']:0;  //如果页面传过来的值存在,值就等于传过来的值,如果没有值就为0;  
 $perpage = 30;   // 赋值就不必说了吧- -  
  
 $start = ($page-1)*$perpage;   //同上;  
  
 $mpurl= 'home.php?mod=auction&ac=inauction'; //url地址么;  
 $perpages = array($perpage => ' selected');    
 $auclist=C::t('auction_inauctions')->fetch_all_by_sql('status=1 AND uid='.$_G['uid'].' AND ovtime>'.strtotime(date("Y-m-d H:i:s")),'ORDER BY inputtime desc',$start,$perpage); //查询出来数据放在$auclist里边;  
  
 $count=C::t('auction_inauctions')->fetch_all_by_sql('status=1 AND uid='.$_G['uid'].' AND ovtime<'.strtotime(date("Y-m-d H:i:s")),'','','',1); //同上;  
 $multipage = multi($count, $perpage, $page, $mpurl); //多页? multi这玩意是个函数吧  
 include template('home/auction_inauctions'); //显示页面么;  
 ?>