关于Ecshop文章搜索增加全文模糊搜索功能
2016-09-11 20:38 来源:www.chinab4c.com 作者:ecshop专家
1.在inculudes/lib_article.php 中
找出下列语句,并修改。【约42行】
//增加搜索条件,如果有搜索内容就进行搜索
if ($requirement != '')
{
$sql = 'SELECT article_id, title, author, add_time, file_url, open_type' .
' FROM ' .$GLOBALS['ecs']->table('article') .
' WHERE is_open = 1 AND ' . $cat_str . ' AND title like \\'%' . $requirement . '%\\' .//本行为要修改语句 Edited by Lingfeng
' ORDER BY article_type DESC, article_id DESC';
}
所修改句子为:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
' WHERE is_open = 1 AND ' . $cat_str . ' AND (title like \\'%' . $requirement . '%\\' or content like \\'%' . $requirement . '%\\' )' .
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.再找出:
function get_article_count($cat_id ,$requirement='')
{
global $db, $ecs;
if ($requirement != '')
{
$count = $db->getOne('SELECT COUNT(*) FROM ' . $ecs->table('article') . ' WHERE ' . get_article_children($cat_id) . ' AND title like \\'%' . $requirement . '%\\' and is_open = 1');
}
所修改后句子为:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
$count = $db->getOne('SELECT COUNT(*) FROM ' . $ecs->table('article') . ' WHERE ' . get_article_children($cat_id) . ' AND ( title like \\'%' . $requirement . '%\\' or content like \\'%' . $requirement . '%\\') AND is_open = 1');
-------------------------------------------------------------------
最近更新
常用插件
- ecshop二次开发商品购买增
图片1香...
- ecshop2.7.1邮件发送插件
ecshop2.7.1邮件发送插件:该插件主要的开发思想是源于ecshop短信发送系统...
- ecshop最小购买数量控制插
ecshop最小购买数量控制插件,这个插件主要是为我们提供一个十分方便...
- ecshop2.7.2生成虚拟订单2.
以前我们开发过ecshop下的虚拟订单,就是客户在访问的时候,会自动生...
- ecshop没登陆情况下订单查
ecshop没登陆情况下订单查询插件,主要是针对ecshop在没有登陆的情况下...