私信发送成功
Watch Star Fork

aming / ebookappPHP

基于bootstrap的php小说采集系统 http://getlove.xyz
克隆/下载
一键复制 编辑 原始数据 按行查看 历史
search.php 1.52 KB aming 提交于 2014-07-23 09:40 . 重新修改适应原抓取网站的变化
<?php
include_once "init.php";
include_once "smarty_inc.php";
include_once WEB_ROOT."util/mysql_class.php";
include_once WEB_ROOT."util/util.php";
include_once WEB_ROOT."admin/funcs/app_util_func.php";
include_once WEB_ROOT."util/Model_class.php";
function getTopNovel(){
$model = new Model();
if(@$_GET["id"]){
$id = verify_id($_GET["id"]);
$category_id = " and c.id=".$id;
}else{
$category_id ="";
}
$sql_select="select a.*,c.category_name from t_article a,t_seeds b,t_category c where a.seed_id = b.id and b.category_id=c.id ".$category_id." order by a.click_times desc limit 0,30";
$model->query($sql_select);
return $model->fetch_all();
}
if(@$_POST["search_text"]){
$title = trim($_POST["search_text"]);
//$title = str_check($title);
//mysql_real_escape_string($value)
//echo $title;
$db = new mysql();
$sql_select="select a.*,c.category_name from t_article a,t_seeds b,t_category c where a.title like '%".$title."%' and a.seed_id = b.id and b.category_id=c.id";
$query = $db->query($sql_select);
while($row=$db->fetch_row_array($query)){
$arr[] = $row;
}
$links = getLinks();
$advert = getadvert();
$tops = getTopNovel();
$smarty->assign("click_artile",$tops);
$smarty->assign("links",$links);
$smarty->assign("advert",$advert);
$smarty->assign("artile",$arr);
$smarty->display("common_header.htm");
$smarty->display("index_bootstrap.htm");
$smarty->display("right-nav.htm");
$smarty->display("common_footer.htm");
}else{
echo "±";
}
?>

评论 (0)

你可以在登录后,对此项目发表评论

3_float_left_people 3_float_left_close