Exemplo n.º 1
0
$keyboard = $keyboardone == 1 ? SearchDoKeyboardVar($keyboard) : '';
$andsql = addslashes($allwhere);
if (strlen($newsearchclass) > 250 || strlen($classid) > 200 || strlen($andsql) > 3000 || strlen($keyboard) > 100 || strlen($ztid) > 200) {
    Header("Location:result/?searchid=0" . $dogetvar);
    exit;
}
//验证码
$checkpass = md5($allwhere . $tbname);
$query = "select count(*) as total from {$dbtbpre}ecms_" . $tbname . " where checked=1" . $allwhere;
$search_r = $empire->fetch1("select searchid from {$dbtbpre}enewssearch where checkpass='******' limit 1");
$searchid = $search_r[searchid];
//排序
$orderby = RepPostVar($_POST['orderby']);
$myorder = (int) $_POST['myorder'];
if ($orderby) {
    $orderr = ReturnDoOrderF($tempr[modid], $orderby, $myorder);
    $orderby = $orderr['returnf'];
} else {
    $orderby = 'newstime';
}
//是否有历史记录
if ($searchid) {
    $search_num = $empire->gettotal($query);
    $sql = $empire->query("update {$dbtbpre}enewssearch set searchtime='{$searchtime}',result_num='{$search_num}',onclick=onclick+1,orderby='{$orderby}',myorder='{$myorder}',tempid='{$s_tempid}' where searchid='{$searchid}'");
    if (empty($search_num)) {
        $searchid = 0;
    }
} else {
    $search_num = $empire->gettotal($query);
    if (empty($search_num)) {
        $searchid = 0;
Exemplo n.º 2
0
                $listandf .= $doandor . $andr[$i] . "='" . $andval . "'";
            } else {
                $listandf .= $doandor . $andr[$i] . " like '%" . $andval . "%'";
            }
            $search .= "&" . $andr[$i] . "={$andval}";
        }
    }
    if ($listandf) {
        $add .= ' and (' . $listandf . ')';
    }
}
//排序
$orderby = RepPostVar($_GET['orderby']);
$myorder = (int) $_GET['myorder'];
if ($orderby) {
    $orderr = ReturnDoOrderF($mid, $orderby, $myorder);
    $addorder = $orderr['returnorder'];
}
$search .= '&orderby=' . $orderby . '&myorder=' . $myorder;
$page = (int) $_GET['page'];
$start = 0;
$page_line = 16;
//每页显示链接数
$offset = $page * $line;
//总偏移量
//系统模型
$ret_r = ReturnReplaceListF($mid);
//优化
$yhadd = '';
if ($yhid) {
    $yhadd = ReturnYhSql($yhid, $yhvar);