Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
文件
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
search.php 1.52 KB
Copy Edit Raw Blame History
<?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 "±";
}
?>
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化