マイクロエンジンPHPマルチ条件検索
11048 ワード
$condition ='where 1=1';
if($_GPC['authorizer_nickname']){
$gname = trim($_GPC['authorizer_nickname']);
$condition .=" and authorizer_nickname like '%{$gname}%'";
}
if(!empty($_GPC['type'])){
$type = trim($_GPC['type']);
$condition.=" and type like '%{$type}%'";
}
if(!empty($_GPC['channel'])){
$channel = trim($_GPC['channel']);
$condition.=" and channel like '%{$channel}%'";
}
if(!empty($_GPC['is_time'])){
$handover_time = ($_GPC['handover_time']);
$starttime = $handover_time['start'] ;
$endtime = $handover_time['end'] ;
$ss = strtotime($starttime);
$ee = strtotime($endtime);
$condition.=" and unix_timestamp(search_date) between $ss and $ee";
}
$pageindex = max(intval($_GPC['page']), 1); //
$pagesize = 20; //
$where = " WHERE uniacid = '{$_W['uniacid']}' ";
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('xiaoshuo_custom') .$condition );
$sql = "SELECT * FROM " . tablename("xiaoshuo_custom") . $condition ." order by id desc limit " . ($pageindex - 1) * $pagesize . "," . $pagesize;
$optionsList = pdo_fetchall($sql);
$pager = pagination($total, $pageindex, $pagesize);