Yourphp,thinkphp修改分页代码
发布时间:2016-01-15, 17:10:17 分类:PHP | 编辑 off 网址 | 辅助
图集1/3
正文 1060字数 921,969阅读
内容页面分页://dump($page->nowPage);
$xl_nowPage=$p;
$xl_totalPages=$pagenumber;
$xl_rollPage_x=($xl_nowPage+1)>$xl_totalPages?$xl_totalPages:($xl_nowPage+1);
$xl_rollPage_s=($xl_nowPage-1)<1?1:($xl_nowPage-1);
$new_page_htm='<a href="'.$xl_rollPage_s.'.html">上一页</a><a href="'.$xl_rollPage_x.'.html">下一页</a>';
$this->assign ('pages',$new_page_htm);
Run code
Cut to clipboard
列表页面分页:
//dump($page->nowPage);
$xl_nowPage=$page->nowPage;
$xl_totalPages=$page->totalPages;
$xl_rollPage_x=($xl_nowPage+1)>$xl_totalPages?$xl_totalPages:($xl_nowPage+1);
$xl_rollPage_s=($xl_nowPage-1)<1?1:($xl_nowPage-1);
$new_page_htm='<a class="a1">'.$page->totalRows.'条</a><a href="'.$xl_rollPage_s.'.html">上一页</a><a href="'.$xl_rollPage_x.'.html">下一页</a>';
$this->assign('pages',$new_page_htm);
Run code
Cut to clipboard
获取对象里面的值:
$page->nowPage
$this->value
Run code
Cut to clipboard
(支付宝)给作者钱财以资鼓励 (微信)→
有过 4 条评论 »
TP添加第三方sdk,文件放在ThinkPHP/Library/Org文件夹下可独立创建文件夹
放在lib/ORG下 比如 A.class.php 放在lib/ORG/Util下 那么引用 import('@.ORG.Util.A');
/GZphp/Lib/Action/Admin/
public function doUpdateurl() { //echo getlang();exit; $llllggg=1; if(getlang()=='en') $llllggg=3; $where=' lang= '.$llllggg; //修复后台多语言 $this->assign ( 'waitSecond', 0); $moduleid = intval($_GET['moduleid']); extract($_GET,EXTR_SKIP); if($moduleid<=0 && $catids[0] <= 0){ if($this->module && !$_SESSION['moduleids']){ foreach($this->module as $moduleid=>$r){ $tablename=C('DB_PREFIX').$this->module[$moduleid]['name']; $db=D(''); $db = DB::getInstance(); $tables = $db->getTables(); $Fields=$db->getFields($tablename); foreach ( $Fields as $key =>$r){ if($key=='url') $_SESSION['moduleids'][] = $moduleid; } } } $doid = $doid ? intval($doid) : 0; if(!isset($_SESSION['moduleids'][$doid])){ unset($_SESSION['moduleids']); $forward = U("Createhtml/updateurl"); $this->assign ( 'jumpUrl', $forward); $this->success(L('create_update_success')); }else{ $moduleid = $_SESSION['moduleids'][$doid]; $module=$this->module[$moduleid]['name']; $dao = M($module); $p = max(intval($p), 1); $start = $pagesize*($p-1); if(!isset($count)){ $count = $dao->where($where)->count(); } $pages = ceil($count/$pagesize); if($count){ $list = $dao->field('id,catid,url')->where($where)->limit($start . ',' . $pagesize)->select(); foreach($list as $r) { if($r['islink']) continue; $url = geturl($this->categorys[$r['catid']],$r,$this->Urlrule); unset($r['catid']); $r['url'] = $url['0']; if($url) $dao->save($r); } } if($pages > $p) { $p++; $creatednum = $start + count($list); $percent = round($creatednum/$count, 2)*100; $urlarray=array( 'doid' => $doid, 'dosubmit' => 1, 'count' => $count, 'pages' => $pages, 'p' => $p, 'pagesize' => $pagesize, ); $message = L('updating').$this->module[$moduleid]['title'].L('create_update_count').$count.L('create_update_num').$creatednum.L('items').$percent.L('items1'); $forward = U("Createhtml/".ACTION_NAME,$urlarray); $this->assign ( 'jumpUrl', $forward); $this->success($message); } else { $doid++; $urlarray=array( 'doid' => $doid, 'dosubmit' => 1, 'p' => 1, 'pagesize' => $pagesize, ); $message = L('start_updating').$this->module[$moduleid]['title']." ..."; $forward = U("Createhtml/".ACTION_NAME,$urlarray); $this->assign ( 'jumpUrl', $forward); $this->success($message); } } }elseif($moduleid){ $module=$this->module[$moduleid]['name']; $dao = M($module); $p = max(intval($p), 1); $start = $pagesize*($p-1); if(is_array($catids) && $catids[0] > 0){ $cids = implode(',',$catids); $where = $where." catid IN($cids) "; $_SESSION['catids'] = $catids; } if(!$catids && $_SESSION['catids'] && $_SESSION['catids'][0] > 0){ $catids = implode(',',$_SESSION['catids']);; $where = $where." catid IN($catids) "; } if(!isset($count)){ $count = $dao->where($where)->count(); } $pages = ceil($count/$pagesize); if($count){ $list = $dao->field('id,catid,url')->where($where)->limit($start . ',' . $pagesize)->select(); foreach($list as $r) { if($r['islink']) continue; $url = geturl($this->categorys[$r['catid']],$r,$this->Urlrule); unset($r['catid']); $r['url'] = $url['0']; if($url) $dao->save($r); } } if($pages > $p) { $p++; $creatednum = $start + count($list); $percent = round($creatednum/$count, 2)*100; $urlarray=array( 'moduleid' => $moduleid, 'dosubmit' => 1, 'count' => $count, 'pages' => $pages, 'p' => $p, 'pagesize' => $pagesize, ); $message = L('create_update_count').$count.L('create_update_num').$creatednum.L('items').$percent.L('items1'); $forward = U("Createhtml/updateurl",$urlarray); $this->assign ( 'jumpUrl', $forward); $this->success($message); } else { unset($_SESSION['catids']); $forward = U("Createhtml/updateurl"); $this->assign ( 'jumpUrl', $forward); $this->success(L('create_update_success')); } }else{ //按照栏目更新url extract($_GET,EXTR_SKIP); $doid = $doid ? intval($doid) : 0; if(empty($_SESSION['catids']) && $catids){ if($catids[0] == 0) { foreach($this->categorys as $id=>$cat) { if($cat['child'] || $cat['type']!=0 || $cat['module']=='Page') continue; $catids[] = $id; } } $_SESSION['catids'] = $catids; }else{ $catids =$_SESSION['catids']; } if(!isset($catids[$doid])){ unset($_SESSION['catids']); $forward = U("Createhtml/updateurl"); $this->assign ( 'jumpUrl', $forward); $this->success(L('create_update_success')); }elseif($catids[$doid]<=0){ $forward = U("Createhtml/updateurl"); $this->assign ( 'jumpUrl', $forward); $this->success(L('create_update_success')); }else{ $id = $catids[$doid]; $module=$this->categorys[$id]['module']; $dao = M($module); $where = $where."catid=$id"; $p = max(intval($p), 1); $start = $pagesize*($p-1); if(!isset($count)){ $count = $dao->where($where)->count(); } $pages = ceil($count/$pagesize); if($count){ $list = $dao->field('id,catid,url')->where($where)->limit($start . ',' . $pagesize)->select(); foreach($list as $r) { if($r['islink']) continue; $url = geturl($this->categorys[$r['catid']],$r,$this->Urlrule); unset($r['catid']); $r['url'] = $url['0']; if($url) $dao->save($r); } } if($pages > $p) { $p++; $creatednum = $start + count($list); $percent = round($creatednum/$count, 2)*100; $urlarray=array( 'doid' => $doid, 'dosubmit' => 1, 'count' => $count, 'pages' => $pages, 'p' => $p, 'pagesize' => $pagesize, ); $message = L('updating').$this->categorys[$id]['catname'].L('create_update_count').$count.L('create_update_num').$creatednum.L('items').$percent.L('items1'); $forward = U("Createhtml/".ACTION_NAME,$urlarray); $this->assign ( 'jumpUrl', $forward); $this->success($message); } else { $doid++; $urlarray=array( 'doid' => $doid, 'dosubmit' => 1, 'p' => 1, 'pagesize' => $pagesize, ); $message = L('start_updating').$this->categorys[$id]['catname']." ..."; $forward = U("Createhtml/".ACTION_NAME,$urlarray); $this->assign ( 'jumpUrl', $forward); $this->success($message); } } } }
/GZphp/Common/
function geturl($cat,$data='',$Urlrule=''){ //$Urlrule =F('Urlrule'); $id=$data['id']; $URL_MODEL =C('URL_M'); if(APP_LANG)$lang = getlang(); $parentdir = $cat['parentdir']; $catdir = $cat['catdir']; if(!$catdir){ return false; //修复后台多语言 } $year = date('Y',$data['createtime']); $month = date('m',$data['createtime']); $day = date('d',$data['createtime']); $module = $cat['module']; $moduleid =$cat['moduleid']; $catid=$cat['id']; if($cat['ishtml']){ if($cat['urlruleid'] && $Urlrule){ $showurlrule = $Urlrule[$cat['urlruleid']]['showurlrule']; $listurlrule = $Urlrule[$cat['urlruleid']]['listurlrule']; }else{ echo 'This cat has not urlruleid or no Urlrule.';exit; } }else{ if($URL_MODEL==0){ $langurl = $lang ? '&l='.LANG_NAME : ''; if($id){ $url[] = U("Home/$cat[module]/show?id=$id".$langurl); $url[] = U("Home/$cat[module]/show?id=".$id.$langurl.'&'.C('VAR_PAGE').'={$page}'); }else{ $url[] = U("Home/$cat[module]/index?id=$cat[id]".$langurl); $url[] = U("Home/$cat[module]/index?id=$cat[id]$langurl&".C('VAR_PAGE').'={$page}'); } $urls = str_replace('g=Admin&','',$url); $urls = str_replace('g=Home&','',$url); }else{ $urlrule = explode(':::',C('URL_URLRULE')); $showurlrule = $urlrule[0]; $listurlrule = $urlrule[1]; } } if(empty($urls)){ $index = $URL_MODEL==1 ? __ROOT__.'/index.php/' : __ROOT__.'/'; $langurl = $lang ? $lang.'/' : ''; if($id){ $urls = str_replace(array('{$parentdir}','{$module}','{$moduleid}','{$catdir}','{$year}','{$month}','{$day}','{$catid}','{$id}'),array($parentdir,$module,$moduleid,$catdir,$year,$month,$day,$catid,$id),$showurlrule); }else{ $urls = str_replace(array('{$parentdir}','{$module}','{$moduleid}','{$catdir}','{$year}','{$month}','{$day}','{$catid}','{$id}'),array($parentdir,$module,$moduleid,$catdir,$year,$month,$day,$catid,$id),$listurlrule); } $urls = explode('|',$urls); $urls[0]=$index.$langurl.$urls[0]; $urls[1]=$index.$langurl.$urls[1]; } return $urls; }
define('APP_DEBUG','false');
Thinkphp中如何表达MYSQL中的某字段不为空is not null
$where['door_open_api_key'] = array('exp',' is not null AND door_open_api_key != ""');