广州传奇网络

地址:广州市天河区东圃大马路富华楼C座

电话:13808825895

邮箱:gz020wbs@163.com

QQ:1564443073

网址:http://www.020wbs.com/

首页 > 二次开发Ecshop二次开发 > ecshop首页增加文章搜索框功能方法

二次开发Ecshop二次开发

二次开发Ecshop二次开发

ecshop首页增加文章搜索框功能方法

 

ecshop首页增加文章搜索框功能方法:

怎么样让ecshop商城首页有商品搜索框,同时又可以搜索文章?

 

1.首页lbi库文件需要显示地方:

 

增加:

 

<form action="{$search_url}" name="search_form" method="post" class="article_search">
<input name="keywords" type="text" id="requirement" value="{$search_value}" class="inputBg" />
<input name="id" type="hidden" value="{$cat_id}" />
<input name="cur_url" id="cur_url" type="hidden" value="" />
<input type="submit" value="{$lang.button_search}" class="bnt_blue_1" />
</form>

 

 

2.在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 . '%\' .
' 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');
-------------------------------------------------------------------