【原创】phpcms v9 根据文章内容关键字搜索 ,phpcms 搜索功能只支持标题和文章摘要的关键字搜索

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'}

  • 2
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

三块钱0794

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值