マイクロエンジン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);