代码如下:
<?php //搜索 $StarLevel = $_GET["starlevel"]; $StartDate=$_GET["StartDate"]; $EndDate=$_GET["EndDate"]; $Key = $_GET["k"]; if($_GET["page"] == ""){ $Page = 1; } else { $Page = $_GET["page"]; } $querySel="select *,ho.ID as hoID,ro.ID as roID from roomsy rsy left join room ro on rsy.RoomID=ro.ID left join hotel ho on rsy.HotelID=ho.ID where to_days(EndDate)-to_days(now())>=0"; if($StartDate) $querySel = $querySel . " and to_days(EndDate)-to_days('".$StartDate."')>=0"; if($EndDate) $querySel = $querySel . " and to_days(EndDate)-to_days('".$EndDate."')<=0"; if($StarLevel) $querySel = $querySel . " and StarLevel = '". $StarLevel ."'"; if($Key) $querySel = $querySel . " and ro.RName like '%". $Key ."%'"; $querySel = $querySel . " order by SOrder,rsy.ID desc"; $result = mysql_query($querySel) or die(mysql_error()); $total_records = mysql_num_rows($result); //取得总记录数 $page_size = 12; //每页显示的条数 $nums = $total_records; //总条目数 $sub_pages = 5; //每次显示的页数 $pageCurrent = $_GET["page"]; //得到当前是第几页 if(!$pageCurrent) $pageCurrent = 1; //$begin_record = 0; //显示记录的首行序号 $begin_record = ($pageCurrent - 1) * $page_size; if($total_records> 0) { //利用LIMIT关键字获取本页所要显示的记录,注意limit两边要"空格"; $querySel = $querySel. " limit ".$begin_record. ", ".$page_size; $result = mysql_query($querySel) or die(mysql_error()); $current_records = mysql_num_rows($result); //取得本页的记录总数 //将查询结果放在$result_show 数组 $result_show = array(); } ?>