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

系统管理员 2022-12-20 08:52 234阅读 0赞

phpcms 搜索功能只支持标题和文章摘要的关键字搜索，对文章内容里关键字无法搜索到，原因。搜索功能只去查询了v9\_news (这个表只有文章标题和摘要)，没有搜索v9\_news\_data（这个表有文章的全内容）。

我们就添加这个搜索v9\_news\_data文章内容的功能代码 ，因为不熟悉phpcms的对数据库查询的方法，就直接用sql语句去查吧，查到关键字对应的文章id，再根据文章id去查询v9\_news表里的文章标题和文章链接。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 1][]

## 编辑   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";
    		}
    
    		
    	}
    }
    ?>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 2][]

# 编辑   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>
    
                <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'}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70]: /images/20221120/a0d2b36db56f4a40b20d6ddfa39d1cdd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 1]: /images/20221120/027ab501dc134385a815bcbc47152db0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201111173104533.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201112083404810.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p4eWsyMDA3,size_16,color_FFFFFF,t_70