您现在的位置是:首页 > 教程 > ecshop商城教程ecshop商城教程
ecshop商品关键词模糊分词搜索插件,商品列表关键字加红功能
之桃2024-04-20 18:27:08ecshop商城教程已有人查阅
导读ECSHOP商品关键词模糊分词搜索商品列表关键字加红功能。最近给客户做一个ECSHOP商城,发现ECSHOP的模糊搜索要求太高,需要加入and、空格、加号等,客户搜索的时候不可能这样操作。
ECSHOP商品关键词模糊分词搜索商品列表关键字加红功能。最近给客户做一个ECSHOP商城,发现ECSHOP的模糊搜索要求太高,需要加入and、空格、加号等,客户搜索的时候不可能这样操作。
考虑到工期的问题,采用了织梦的分词算法,搜索效果虽然不是特别理想,但是这么短的时间也只能这样了。
在此分享给没钱又着急的朋友,需要用到的文件在文章末尾提供下载,大家下载后也可以直接覆盖使用。
一、ECSHOP联想下拉框
1、修改page_header.lbi模版文件,将搜索文本框修改为:
<scripttype="text/javascript"src="/js/suggest.js"></script>
嵌入css文件
<linkhref="/themes/default/images/css.css"rel="stylesheet"type="text/css">
2、根目录添加php文件search_suggest.php文件
二、分词搜索
ECSHOP教程根目录增加织梦分词算法函数和词库:lib_splitword_full.php和dededic.csv
1、修改search.php文件 96行
/*检查关键字中是否有空格,如果存在就是并*/$arr=explode(' ',$_REQUEST['keywords']);$operator= " AND ";
改为:
/*调用织梦分词功能-start*/require("lib_splitword_full.php");$sp=newSplitWord();$fenci=$sp->SplitRMM($_REQUEST['keywords']);$sp->Clear();/*织梦分词后是使用空格进行划分,所以仍可使用ecshop的按照空格拆分为数组功能:检查关键字中是否有空格,如果存在就是并*/$arr=explode(' ',$fenci);$arr=array_reverse($arr);//将数组倒序排列,并插入完整关键字到数组末尾$arr[count($arr)]=$_REQUEST['keywords'];$arr=array_reverse($arr);//再次将数组倒序,使完整关键字可以 个被检索array_pop($arr);//删除织梦分词产生的数组最后一个元素为空格$operator= " and ";//sql检索语句使用union联合检索$ hong=$arr;//$arr数组在飘红的时候已经被产品列表占用了,所以另外赋值给一个数组备用。/*调用织梦分词功能-end*/
2、修改search.php文件第382行到403行
/*sun04zh3-20130905-调用织梦分词功能-更改ecshop的sql语句采用union方式-start*//*因为后面要用union生成数据集表,所以先根据拆分出的关键词,生成union所需的所有sql语句,*/$select= "(";foreach($arrAS$se=>$t) {$select.= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type FROM(select click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type from".$ecs->table('goods')." where goods_name like '%$t%' order by click_count desc) AS P$se";// 个关键词是完整关键词if($se==0)//插入一个当所有拆分关键词在商品名称中为and时的sql语句{$select.= " UNION SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type FROM(select click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type from".$ecs->table('goods')." where 1$keywordsorder by click_count desc) AS Pa"; }if($se<count($arr)-1)//在每条select语句后增加union,最后一个不加,所以$se小于元素数量-1{$select.=" UNION "; } }$select.=")";if($select=="()")//当关键词为空时,没有拆分关键词,所以用于union的$select为空,仍需要调用goods表{$sql= "SELECT COUNT(*) FROM ".$ecs->table("goods")." AS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }else{/*获得符合条件的商品总数*/$sql= "SELECT COUNT(*) FROM$selectAS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }$count=$db->getOne($sql);$max_page= ($count> 0) ?ceil($count/$size) : 1;if($page>$max_page) {$page=$max_page; }if($select=="()")//当关键词为空时,没有拆分关键词,所以用于union的$select为空,仍需要调用goods表{/*查询商品*/$sql= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type ". "FROM ".$ecs->table("goods")." AS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }else{/*查询商品*/$sql= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type ". "FROM$selectAS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }
三、搜索出的产品列表产品关键词飘红功能:
1、修改search.php文件第473行到480行
if($display== 'grid') {$arr[$row['goods_id']]['goods_name'] =$GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'],$GLOBALS['_CFG']['goods_name_length']) :$row['goods_name']; }else{$arr[$row['goods_id']]['goods_name'] =$row['goods_name']; }
修改为:
/*根据分词对产品名称进行替换-start*/$tihuan=$row["goods_name"];foreach($ hongAS$ph_count=>$ph) {$tihuan=str_replace($ph,"<b style='color:#d90000'>$ph</b>",$tihuan); }$arr[$row['goods_id']]['goods_name'] =$row['goods_name'];//因为前台用到没有替换的商品名称,所以保留goods_name值$arr[$row['goods_id']]['tihuan'] =$tihuan;/*根据分词对产品名称进行替换-end*/
2、修改search.dwt模板文件
将显示商品名称的地方替换为:
<p><a href="{$goods.url}" title="{$goods.name|escape:html}">{$goods.tihuan}</a></p>
四、文中所有涉及的修改和要用到的文件
下载地址:www.ebingou.cn/moban-311.html
考虑到工期的问题,采用了织梦的分词算法,搜索效果虽然不是特别理想,但是这么短的时间也只能这样了。
在此分享给没钱又着急的朋友,需要用到的文件在文章末尾提供下载,大家下载后也可以直接覆盖使用。
一、ECSHOP联想下拉框
1、修改page_header.lbi模版文件,将搜索文本框修改为:
<inputname="keywords"type="text"id="keyword"value="<!--{if ($search_keywords neq "")}{$search_keywords|escape}--><!--{else}-->ecshop<!--{/if}-->" class="search-input" onfocus="if(this.value=='ecshop'){this.value='';this.style.color='#000';}" onblur="closediv();if(this.value==''){this.value='ecshop';this.style.color='#999';}" style="color:#999;" onkeyup="keyupdeal(event,this.value);" onkeydown="keydowndeal(event);" onclick="keyupdeal(event,this.value);" autocomplete="off" /><divid="search_suggest"style="display:none;"onmouseover='javascript:_over();'onmouseout='javascript:_out();'></div>
嵌入js文件<scripttype="text/javascript"src="/js/suggest.js"></script>
嵌入css文件
<linkhref="/themes/default/images/css.css"rel="stylesheet"type="text/css">
2、根目录添加php文件search_suggest.php文件
二、分词搜索
ECSHOP教程根目录增加织梦分词算法函数和词库:lib_splitword_full.php和dededic.csv
1、修改search.php文件 96行
/*检查关键字中是否有空格,如果存在就是并*/$arr=explode(' ',$_REQUEST['keywords']);$operator= " AND ";
改为:
/*调用织梦分词功能-start*/require("lib_splitword_full.php");$sp=newSplitWord();$fenci=$sp->SplitRMM($_REQUEST['keywords']);$sp->Clear();/*织梦分词后是使用空格进行划分,所以仍可使用ecshop的按照空格拆分为数组功能:检查关键字中是否有空格,如果存在就是并*/$arr=explode(' ',$fenci);$arr=array_reverse($arr);//将数组倒序排列,并插入完整关键字到数组末尾$arr[count($arr)]=$_REQUEST['keywords'];$arr=array_reverse($arr);//再次将数组倒序,使完整关键字可以 个被检索array_pop($arr);//删除织梦分词产生的数组最后一个元素为空格$operator= " and ";//sql检索语句使用union联合检索$ hong=$arr;//$arr数组在飘红的时候已经被产品列表占用了,所以另外赋值给一个数组备用。/*调用织梦分词功能-end*/
2、修改search.php文件第382行到403行
/*获得符合条件的商品总数*/$sql= "SELECT COUNT(*) FROM " .$ecs->table('goods'). " AS g ". "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1$attr_in". "AND (( 1 " .$categories.$keywords.$brand.$min_price.$max_price.$intro.$outstock." ) ".$tag_where." )";$count=$db->getOne($sql);$max_page= ($count> 0) ?ceil($count/$size) : 1;if($page>$max_page) {$page=$max_page; }/*查询商品*/$sql= "SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ". "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ". "g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type ". "FROM " .$ecs->table('goods'). " AS g ". "LEFT JOIN " .$GLOBALS['ecs']->table('member_price') . " AS mp ". "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ". "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1$attr_in". "AND (( 1 " .$categories.$keywords.$brand.$min_price.$max_price.$intro.$outstock. " ) ".$tag_where." ) " . "ORDER BY$sort$order";
打开 /includes/lib_goods.php 文件(建议使用editplus)找到下面代码(大概在287行左右)/*sun04zh3-20130905-调用织梦分词功能-更改ecshop的sql语句采用union方式-start*//*因为后面要用union生成数据集表,所以先根据拆分出的关键词,生成union所需的所有sql语句,*/$select= "(";foreach($arrAS$se=>$t) {$select.= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type FROM(select click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type from".$ecs->table('goods')." where goods_name like '%$t%' order by click_count desc) AS P$se";// 个关键词是完整关键词if($se==0)//插入一个当所有拆分关键词在商品名称中为and时的sql语句{$select.= " UNION SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type FROM(select click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type from".$ecs->table('goods')." where 1$keywordsorder by click_count desc) AS Pa"; }if($se<count($arr)-1)//在每条select语句后增加union,最后一个不加,所以$se小于元素数量-1{$select.=" UNION "; } }$select.=")";if($select=="()")//当关键词为空时,没有拆分关键词,所以用于union的$select为空,仍需要调用goods表{$sql= "SELECT COUNT(*) FROM ".$ecs->table("goods")." AS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }else{/*获得符合条件的商品总数*/$sql= "SELECT COUNT(*) FROM$selectAS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }$count=$db->getOne($sql);$max_page= ($count> 0) ?ceil($count/$size) : 1;if($page>$max_page) {$page=$max_page; }if($select=="()")//当关键词为空时,没有拆分关键词,所以用于union的$select为空,仍需要调用goods表{/*查询商品*/$sql= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type ". "FROM ".$ecs->table("goods")." AS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }else{/*查询商品*/$sql= "SELECT click_count,goods_sn,is_alone_sale,is_on_sale,is_delete,goods_id, goods_name, market_price, is_new, is_best, is_hot, shop_price AS org_price, shop_price ,promote_price, promote_start_date, promote_end_date, goods_thumb, goods_img, goods_brief, goods_type ". "FROM$selectAS P " . "WHERE is_delete = 0 AND is_on_sale = 1 AND is_alone_sale = 1 "; }
三、搜索出的产品列表产品关键词飘红功能:
1、修改search.php文件第473行到480行
if($display== 'grid') {$arr[$row['goods_id']]['goods_name'] =$GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'],$GLOBALS['_CFG']['goods_name_length']) :$row['goods_name']; }else{$arr[$row['goods_id']]['goods_name'] =$row['goods_name']; }
修改为:
/*根据分词对产品名称进行替换-start*/$tihuan=$row["goods_name"];foreach($ hongAS$ph_count=>$ph) {$tihuan=str_replace($ph,"<b style='color:#d90000'>$ph</b>",$tihuan); }$arr[$row['goods_id']]['goods_name'] =$row['goods_name'];//因为前台用到没有替换的商品名称,所以保留goods_name值$arr[$row['goods_id']]['tihuan'] =$tihuan;/*根据分词对产品名称进行替换-end*/
2、修改search.dwt模板文件
将显示商品名称的地方替换为:
<p><a href="{$goods.url}" title="{$goods.name|escape:html}">{$goods.tihuan}</a></p>
四、文中所有涉及的修改和要用到的文件
下载地址:www.ebingou.cn/moban-311.html
本文标签:
很赞哦! ()
相关文章
- ecshop商品列表页面和商品页面自定义url网址前缀的实现方法
- ecshop商品页显示商品收藏数量怎么修改
- ecshop商品批发多属性多规格多库存怎么批量购买
- ecshop水印ecshop商品添加水印的实现方法
- ecshop商品价格将属性价格改为直接价非加价修改的方法
- ecshop商品页商品详细描述内容调用商品相册图片代码的方法
- ecshop商品图片模糊修改图片上传压缩质量的方法
- ecshop商品相册显示顺序为正序的修改方法
- ecshop商品售完商品库存为0显示商品售完已售罄的实现方法
- ecshop商品详情页相关属性商品由新到旧排序的方法
- ecshop商品页商品浏览次数怎样修改按倍数增加
- ecshop商品页面定制属性附件上传文件上传图片
随机图文
-
ecshop后台模板设置中将非可编辑区改为可编辑区
以ECSHOP官方默认模板为例1.我们打开后台,选择模板设置》首页模板发现很多都是非可编辑区,我们以品牌专区为例来进行修改 -
ecshop添加订单订单管理教程
添加订单 从后台订单管理->添加订单 进入。除了用户在前台定购商品的时候添加订单,管理员也可以在后台直接添加订单。 -
ecshop首页商品或商品列表页显示商品描述
ECSHOP后台商品编辑的地方有一个录入“商品简单描述”的框框,但是录入的“商品简单描述”没有很好的在前台显示出来,而只是在商品详细页的 description 里,供搜索引擎读取。 -
ecshop邮件服务器设置发送邮件会员注册发送邮箱验证码
很新QQ邮箱设置教程,很好是注册QQ企业邮箱,这样给用户发送验证码很少几率进垃圾箱下面介绍普通QQ邮箱设置教程一、首先开启QQ邮箱的SMTP服务首先,要开
留言与评论 (共有 条评论) |