search.php
资源名称:BBWPS.rar [点击查看]
上传用户:yttaitong
上传日期:2009-05-10
资源大小:128k
文件大小:4k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
PHP
- <?php
- /*
- [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
- This is NOT a freeware, use is subject to license terms
- 时间:2007年12月
- 描述:搜索
- */
- error_reporting(0);
- require("../../config.php");
- require("../../class/mysql_class.php");
- require("../../class/template_class.php");
- require_once("../../function/checkModuleSession.php");
- $bbwps_admin=isLogin("../../$sessionPath/");
- $db= new DB($hostname,$username,$password,$database);
- $p=new template("template");
- $cid = $_GET["cid"];
- $search = $_GET['search']? $_GET['search']:$_POST['search'];
- $sort = $_GET['sort']? $_GET['sort']:$_POST['sort'];
- $setting = $db->query("select list_num from ".$prefix."setting",1);
- $pagesize = $db->fetch_array($setting);
- $pagesize = $pagesize["list_num"];
- require("../../function/fenye.php");
- if($sort||$search){
- $query = "sort=".$sort."&search=".$search;
- $array=array("".$prefix."message.username","".$prefix."message.title","".$prefix."message.content","".$prefix."message.nprice","".$prefix."message.etime");
- $numbers="select count(mid) from ".$prefix."message where ".$prefix."message.etime > '".time()."' and ".$array[$sort-1]." like '%$search%'";
- $number=$db->query($numbers,1);
- $num=$db->fetch_array($number);
- $total=$num["count(mid)"];
- $sql="select ".$prefix."message.mid,".$prefix."message.title,".$prefix."message.btime,".$prefix."message.etime,".$prefix."message.picture,".$prefix."message.hits,".$prefix."sort.sname,".$prefix."city.cname,
- count(".$prefix."revert.mid) from ".$prefix."message left join ".$prefix."sort on ".$prefix."message.sid=".$prefix."sort.sid left join ".$prefix."city on ".$prefix."message.cid=".$prefix."city.cid left join ".$prefix."revert on ".$prefix."revert.mid=".$prefix."message.mid
- where ".$prefix."message.etime > '".time()."' and ".$array[$sort-1]." like '%$search%' group by ".$prefix."message.mid order by ".$prefix."message.btime desc limit $start,$pagesize";
- }
- if($cid){
- $query = "cid=".$cid;
- $numbers="select count(mid) from ".$prefix."message where ".$prefix."message.etime > '".time()."' and ".$prefix."message.cid='".$cid."'";
- $number=$db->query($numbers,1);
- $num=$db->fetch_array($number);
- $total=$num["count(mid)"];
- $sql="select ".$prefix."message.mid,".$prefix."message.title,".$prefix."message.btime,".$prefix."message.etime,".$prefix."message.picture,".$prefix."message.hits,".$prefix."sort.sname,".$prefix."city.cname,
- count(".$prefix."revert.mid) from ".$prefix."message left join ".$prefix."sort on ".$prefix."message.sid=".$prefix."sort.sid left join ".$prefix."city on ".$prefix."message.cid=".$prefix."city.cid left join ".$prefix."revert on ".$prefix."revert.mid=".$prefix."message.mid
- where ".$prefix."message.etime > '".time()."' and ".$prefix."message.cid='".$cid."' group by ".$prefix."message.mid order by ".$prefix."message.btime desc limit $start,$pagesize";
- }
- $result=$db->query($sql,1);
- $p->set_file("handle","search.html");
- $p->set_block("handle","op","a");
- while($row=$db->fetch_array($result)){
- $p->set_var("mid",$row["mid"]);
- $p->set_var("title",$row["title"]);
- $p->set_var("sort",$row["sname"]);
- $p->set_var("city",$row["cname"]);
- $p->set_var("hit",$row["hits"]);
- $p->set_var("btime",date("Y-m-j",$row["btime"]));
- $p->set_var("etime",date("Y-m-j",$row["etime"]));
- $p->set_var("num",$row["count(".$prefix."revert.mid)"]);
- $p->parse("a","op",true);
- }
- $p->set_var("fenye",showpage($total,$pagesize,$page,$query));
- $p->set_var(array("content"=> $search,"id"=> $sort,"cid"=> $cid));
- $p->parse("search","handle",true);
- $p->p("search");
- $db->close();
- ?>