共有 筆搜尋結果
-
query($sqlb);
Page4($page,$perpage,$resultb,$site,$search,rawurlencode($key_word),$during,$date_to,$date_from);
?>
require_once './Admin/include/ver_script.php'; //require_once './include/cls_mysql.php'; //require_once './include/lib_common.php'; require_once './Admin/include/MySQL.php'; require_once './Admin/include/Session.php'; require_once './Admin/include/Page.php'; $table = "posts"; if($_GET["q"]){ $key_word = catch_word($_GET["q"]); }else{ $key_word = catch_word($_GET["key"]); } $sql = "select * from $table where keyword like '%".$key_word."%' and publish = 1 and post_date <= '".date("Y-m-d H:i:s")."' order by id desc"; $result = $mysql->query($sql); $aNum = $result->size(); $page = intval($_GET["page"]); $perpage = 9; if($page >0){ $page = intval($page); $start = ($page-1)*$perpage; $sql = "select * from $table where keyword like '%".$key_word."%' and publish = 1 and post_date <= '".date("Y-m-d H:i:s")."'"; $result = $mysql->query($sql); if($start > $result->size()){ $start = 0; } }else{ $start = 0; } $site = 'search.php'; $num=$start+1; ?>