phpcms 搜索功能只支持标题和文章摘要的关键字搜索,对文章内容里关键字无法搜索到,原因。搜索功能只去查询了v9_news (这个表只有文章标题和摘要),没有搜索v9_news_data(这个表有文章的全内容)。
我们就添加这个搜索v9_news_data文章内容的功能代码 ,因为不熟悉phpcms的对数据库查询的方法,就直接用sql语句去查吧,查到关键字对应的文章id,再根据文章id去查询v9_news表里的文章标题和文章链接。
编辑 phpcms\modules\search\index.php
<?php
defined('IN_PHPCMS') or exit('No permission resources.');
pc_base::load_sys_class('form','',0);
pc_base::load_sys_class('format','',0);
class index {
function __construct() {
$this->db = pc_base::load_model('search_model');
$this->content_db = pc_base::load_model('content_model');
}
/**
* 关键词搜索
*/
public function init() {
//获取siteid
$siteid = isset($_REQUEST['siteid']) && trim($_REQUEST['siteid']) ? intval($_REQUEST['siteid']) : 1;
$SEO = seo($siteid);
//搜索配置
$search_setting = getcache('search');
$setting = $search_setting[$siteid];
$search_model = getcache('search_model_'.$siteid);
$type_module = getcache('type_module_'.$siteid);
if(isset($_GET['q'])) {
if(trim($_GET['q'])=='') {
header('Location: '.APP_PATH.'index.php?m=search');exit;
}
$typeid = empty($_GET['typeid']) ? 48 : intval($_GET['typeid']);
$time = empty($_GET['time']) || !in_array($_GET['time'],array('all','day','month','year','week')) ? 'all' : trim($_GET['time']);
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$pagesize = 10;
$q = safe_replace(trim($_GET['q']));
$q = new_html_special_chars(strip_tags($q));
$q = str_replace('%', '', $q); //过滤'%',用户全文搜索
$search_q = $q; //搜索原内容
//按时间搜索
if($time == 'day') {
$search_time = SYS_TIME - 86400;
$sql_time = ' AND adddate > '.$search_time;
} elseif($time == 'week') {
$search_time = SYS_TIME - 604800;
$sql_time = ' AND adddate > '.$search_time;
} elseif($time == 'month') {
$search_time = SYS_TIME - 2592000;
$sql_time = ' AND adddate > '.$search_time;
} elseif($time == 'year') {
$search_time = SYS_TIME - 31536000;
$sql_time = ' AND adddate > '.$search_time;
} else {
$search_time = 0;
$sql_time = '';
}
if($page==1 && !$setting['sphinxenable']) {
//精确搜索
$commend = $this->db->get_one("`typeid` = '$typeid' $sql_time AND `data` like '%$q%'");
} else {
$commend = '';
}
//如果开启sphinx
if($setting['sphinxenable']) {
$sphinx = pc_base::load_app_class('search_interface', '', 0);
$sphinx = new search_interface();
$offset = $pagesize*($page-1);
$res = $sphinx->search($q, array($siteid), array($typeid), array($search_time, SYS_TIME), $offset, $pagesize, '@weight desc');
$totalnums = $res['total'];
//如果结果不为空
if(!empty($res['matches'])) {
$result = $res['matches'];
}
} else {
pc_base::load_sys_class('segment', '', 0);
$segment = new segment();
//分词结果
$segment_q = $segment->get_keyword($segment->split_result($q));
//如果分词结果为空
if(!empty($segment_q)) {
//$sql = "`siteid`= '$siteid' AND `typeid` = '$typeid' $sql_time AND MATCH (`data`) AGAINST ('$segment_q' IN BOOLEAN MODE)";
$sql = "`siteid`= '$siteid' AND `typeid` = '$typeid' $sql_time AND `data` like '%$q%'";
} else {
$sql = "`siteid`= '$siteid' AND `typeid` = '$typeid' $sql_time AND `data` like '%$q%'";
}
$result = $this->db->listinfo($sql, 'searchid DESC', $page, 10);
}
//如果开启相关搜索功能
if($setting['relationenble']) {
//如果关键词长度在8-16之间,保存关键词作为relation search
$this->keyword_db = pc_base::load_model('search_keyword_model');
if(strlen($q) < 17 && strlen($q) > 5 && !empty($segment_q)) {
$res = $this->keyword_db->get_one(array('keyword'=>$q));
if($res) {
//关键词搜索数+1
//$this->keyword_db->update(array('searchnums'=>'+=1'), array('keyword'=>$q));
} else {
//关键词转换为拼音
pc_base::load_sys_func('iconv');
$pinyin = gbk_to_pinyin($q);
if(is_array($pinyin)) {
$pinyin = implode('', $pinyin);
}
$this->keyword_db->insert(array('keyword'=>$q, 'searchnums'=>1, 'data'=>$segment_q, 'pinyin'=>$pinyin));
}
}
//相关搜索
if(!empty($segment_q)) {
$relation_q = str_replace(' ', '%', $segment_q);
} else {
$relation_q = $q;
}
$relation = $this->keyword_db->select("MATCH (`data`) AGAINST ('%$relation_q%' IN BOOLEAN MODE)", '*', 10, 'searchnums DESC');
}
//如果结果不为空
if(!empty($result) || !empty($commend['id'])) {
//开启sphinx后文章id取法不同
if($setting['sphinxenable']) {
foreach($result as $_v) {
$sids[] = $_v['attrs']['id'];
}
} else {
foreach($result as $_v) {
$sids[] = $_v['id'];
}
}
if(!empty($commend['id'])) {
$sids[] = $commend['id'];
}
$sids = array_unique($sids);
$where = to_sqls($sids, '', 'id');
//获取模型id
$model_type_cache = getcache('type_model_'.$siteid,'search');
$model_type_cache = array_flip($model_type_cache);
$modelid = $model_type_cache[$typeid];
//是否读取其他模块接口
if($modelid) {
$this->content_db->set_model($modelid);
/**
* 如果表名为空,则为黄页模型
*/
if(empty($this->content_db->model_tablename)) {
$this->content_db = pc_base::load_model('yp_content_model');
$this->content_db->set_model($modelid);
}
if($setting['sphinxenable']) {
$data = $this->content_db->listinfo($where, 'id DESC', 1, $pagesize);
$pages = pages($totalnums, $page, $pagesize);
} else {
$data = $this->content_db->select($where, '*');
$pages = $this->db->pages;
$totalnums = $this->db->number;
}
//如果分词结果为空
if(!empty($segment_q)) {
$replace = explode(' ', $segment_q);
foreach($replace as $replace_arr_v) {
$replace_arr[] = '<font color=red>'.$replace_arr_v.'</font>';
}
foreach($data as $_k=>$_v) {
$data[$_k]['title'] = str_replace($replace, $replace_arr, $_v['title']);
$data[$_k]['description'] = str_replace($replace, $replace_arr, $_v['description']);
$data[$_k]['username'] = str_replace($replace, $replace_arr, $_v['username']);
}
} else {
foreach($data as $_k=>$_v) {
$data[$_k]['title'] = str_replace($q, '<font color=red>'.$q.'</font>', $_v['title']);
$data[$_k]['description'] = str_replace($q, '<font color=red>'.$q.'</font>', $_v['description']);
}
}
} else {
//读取专辑搜索接口
$special_api = pc_base::load_app_class('search_api', 'special');
$data = $special_api->get_search_data($sids);
$totalnums = count($data);
}
}
$execute_time = execute_time();
$pages = isset($pages) ? $pages : '';
$totalnums = isset($totalnums) ? $totalnums : 0;
$data = isset($data) ? $data : '';
//以下代码实现根据文章内容关键字模糊搜索功能202011104
$dbhost = 'localhost'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = 'root'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
//print_r($_GET['q']);
$qqq = ($_GET['q']);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
$sqlss = "SELECT * FROM v9_news_data where content like '%$qqq%' "; //根据内容关键字模糊搜索,得到文章id
mysqli_select_db( $conn, 'jxlzw' );
$retval = mysqli_query( $conn, $sqlss );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))
{
$ssid = $row['id'];
$sqlss2 = "SELECT * FROM v9_news where id=$ssid "; //根据文章id 查询文章对应的url
//mysqli_select_db( $conn, 'jxlzw' );
$retval2 = mysqli_query( $conn, $sqlss2 );
$row2=mysqli_fetch_array($retval2,MYSQLI_NUM);
//echo "<tr><td> {$row['id']}</td> ".
}
mysqli_close($conn);
//print_r($_GET['q']);
//以上代码实现根据文章内容关键字模糊搜索功能202011104
include template('search','list');
} else {
include template('search','index');
}
}
public function public_get_suggest_keyword() {
$url = $_GET['url'].'&q='.$_GET['q'];
$trust_url = array('c8430fcf851e85818b546addf5bc4dd3');
$urm_md5 = md5($url);
if (!in_array($urm_md5, $trust_url)) exit;
$res = @file_get_contents($url);
if(CHARSET != 'gbk') {
$res = iconv('gbk', CHARSET, $res);
}
echo $res;
}
/**
* 提示搜索接口
* TODO 暂时未启用,用的是google的接口
*/
public function public_suggest_search() {
//关键词转换为拼音
pc_base::load_sys_func('iconv');
$pinyin = gbk_to_pinyin($q);
if(is_array($pinyin)) {
$pinyin = implode('', $pinyin);
}
$this->keyword_db = pc_base::load_model('search_keyword_model');
$suggest = $this->keyword_db->select("pinyin like '$pinyin%'", '*', 10, 'searchnums DESC');
foreach($suggest as $v) {
echo $v['keyword']."\n";
}
}
}
?>
编辑 phpcms\templates\default\search\list.html 模板文件
{template 'search', 'header'}
<div class="clr sr_body sr_list">
<div class="sr_main">
<div class="sr_head">
<!--<div class="l" id="search">
{php $j=0}
{loop $search_model $k=>$v}
{php $j++;}
<a href="javascript:;" onclick="setmodel({$v['typeid']}, $(this),{$siteid}, '{$q}');" {if $v['typeid']==$typeid} class="on"{/if}>{$v['name']}</a>{if $j != count($search_model)} - {/if}
{/loop}
</div>-->
</div>
<div class="wrap sr_logo">
<a href="{siteurl($siteid)}" class="l"><img src="{IMG_PATH}search/se_logo.png" width="230" height="158" /></a>
<div class="l">
<div class="sr_frm_box">
<form name="search" type="get">
<div class="sr_frmipt">
<input type="hidden" name="m" value="search"/>
<input type="hidden" name="c" value="index"/>
<input type="hidden" name="a" value="init"/>
<input type="hidden" name="typeid" value="{$typeid}" id="typeid"/>
<input type="hidden" name="siteid" value="{$siteid}" id="siteid"/>
<input type="text" name="q" class="ipt" id="q" value="{$search_q}">
<div class="sp" id="aca">▼</div><input type="submit" class="ss_btn" value="搜 索"></div>
</form>
<div id="sr_infos" class="wrap sr_infoul">
</div>
</div>
<div class="jg">获得约
<?php if(empty($row2))
{
//为空
echo $totalnums.'条结果 ';
} else {
echo $totalnums+1 ;
echo '条结果 ';
//不为空
}?>
</div>
</div>
</div>
<div class="brd1s"></div>
<div class="wrap sr_lists">
<div class="l">
<div>
<span>网页结果</span>
<ul>
{loop $search_model $k=>$v}
<li><a href="?m=search&c=index&a=init&typeid={$v['typeid']}&q={urlencode($search_q)}&siteid={$siteid}&time={$time}" {if $v['typeid']==$typeid} class="ac"{/if}>{$v['name']}</a>
</li>
{/loop}
</ul>
</div>
<div>
<span>按时间搜索</span>
<ul>
<li><a href="?m=search&c=index&a=init&typeid={$typeid}&q={urlencode($search_q)}&siteid={$siteid}&time=all" {if $time=='all' || empty($time)}class="ac"{/if}>全部时间</a></li>
<li><a href="?m=search&c=index&a=init&typeid={$typeid}&q={urlencode($search_q)}&siteid={$siteid}&time=day" {if $time=='day'}class="ac"{/if}>一天内</a></li>
<li><a href="?m=search&c=index&a=init&typeid={$typeid}&q={urlencode($search_q)}&siteid={$siteid}&time=week" {if $time=='week'}class="ac"{/if}>一周内</a></li>
<li><a href="?m=search&c=index&a=init&typeid={$typeid}&q={urlencode($search_q)}&siteid={$siteid}&time=month" {if $time=='month'}class="ac"{/if}>一月内</a></li>
<li><a href="?m=search&c=index&a=init&typeid={$typeid}&q={urlencode($search_q)}&siteid={$siteid}&time=year" {if $time=='year'}class="ac"{/if}>一年内</a></li>
</ul>
</div>
<div class="bgno">
<span>搜索历史</span>
<ul id='history_ul'>
</ul>
</div>
</div>
<div class="c wrap">
<ul class="wrap">
{loop $data $i $r}
<li class="wrap">
<div>
{if $r['thumb']}<a href="{$r[url]}"><img src="{$r[thumb]}" width="60" height="60" /></a>{/if}
<h5><a href="{$r[url]}">{$r[title]}</a>{if $r['posids']}<img src="{IMG_PATH}icon/small_elite.gif">{/if}</h5>
<p>{$r[description]}</p>
</div>
<div class="adds">发布时间:{format::date($r[inputtime], 1)} </div>
</li>
{/loop}
<?php
if(empty($row2)){
echo '根据内容未找到结果';
}
else{
}
?>
</ul>
<ul class="wrap">
<li class="wrap">
<div>
<h5><a href="<?php print_r ($row2[9]);?>"><?php echo ($row2[3]);?></a><img src=""></h5>
<p><?php print_r ($row2[7]);?></p>
</div>
<div class="adds">
<?php
if(empty($row2)){
}
else{
echo '发布时间:'.date("Y-m-d H:i",($row2[15]));
}
?>
</div>
</li>
</ul>
<div id="pages" class="text-c mg_t20">{$pages}</div>
{if $setting['relationenble']}
<div class="wrap sgch"><strong>相关搜索:</strong>
{loop $relation $k $v}
<a href="?m=search&c=index&a=init&typeid={$typeid}&siteid={$siteid}&q={$v['keyword']}">{$v['keyword']}</a>
{/loop}
</div>
{/if}
</div>
</div>
</div>
<script type="text/javascript" src="{JS_PATH}search_history.js"></script>
{if $setting['suggestenable']}
<script type="text/javascript" src="{JS_PATH}jquery.suggest.js"></script>
<script type="text/javascript" src="{JS_PATH}search_suggest.js"></script>
{/if}
{template 'search', 'footer'}