ECshop支撐對(duì)于每個(gè)新建的類目自定義Keywords、Description Meta信息，好處就不用說(shuō)了，協(xié)助SEO或許讓閱讀者了解這是啥頁(yè)面，但如果有幾百個(gè)類目的時(shí)分，人工去寫(xiě)這些類目又有點(diǎn)累人（咱不干體力勞動(dòng)的 活），花了點(diǎn)時(shí)刻，寫(xiě)了個(gè)主動(dòng)生成Keywords、Description的PHP腳本，支撐四級(jí)分類，原理是子類目包括父親類目、爺爺類目。。。到頂 級(jí)類目名作為關(guān)鍵字，然后一句描述的話，包括這些類目的稱號(hào)。我們能夠依據(jù)自個(gè)需求簡(jiǎn)略的修改。

用法，在你的后臺(tái)類目，默許是Admin里面創(chuàng)立一個(gè)新的PHP文件，文件名自定義，將下面的代碼仿制進(jìn)入就能夠了，需求生成的時(shí)分，訪問(wèn)一下這個(gè)文件就主動(dòng)生成了。

<?php

set_time_limit(600);

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

$sql_1 = "SELECT cat_id,cat_name FROM " .$ecs->table('category'). " where parent_id = 0 ORDER BY cat_id asc";

$res_1 = $db->query($sql_1);

//一級(jí)類目循環(huán)

while ($row_1 = $db->fetchRow($res_1))

{

//取得一級(jí)類目子類目

$sql_2 = "SELECT cat_id,cat_name FROM " .$ecs->table('category'). " where parent_id = ". $row_1['cat_id'] ." ORDER BY cat_id asc";

$res_2 = $db->query($sql_2);

print "*** 一級(jí)分類：" . $row_1['cat_name'] ."<br>";

//一級(jí)類目子類目循環(huán)

$keyword_1 = '';

$c2 = 0;

while ($row_2 = $db->fetchRow($res_2))

{

$c2 = $c2 + 1;

if ($c2 < 7)

{

//生成一級(jí)類目的關(guān)鍵詞和描述，取前X個(gè)

$keyword_1 = $keyword_1 . replace_cat_name($row_2['cat_name']) . ", ";

}

//=====================================================================

//取得二級(jí)類目子類目

$sql_3 = "SELECT cat_id,cat_name FROM " .$ecs->table('category'). " where parent_id = ". $row_2['cat_id'] ." ORDER BY cat_id asc";

$res_3 = $db->query($sql_3);

print "****** 二級(jí)分類：" . $row_2['cat_name'] ."<br>";

//二級(jí)類目子類目循環(huán)

$keyword_2 = '';

$c3 = 0;

while ($row_3 = $db->fetchRow($res_3))

{

$c3 = $c3 + 1;

if ($c3 < 7)

{

//生成二級(jí)類目的關(guān)鍵詞和描述

$keyword_2 = $keyword_2 . replace_cat_name($row_3['cat_name']) . ", ";

}

//=====================================================================

//取得三級(jí)類目子類目

$sql_4 = "SELECT cat_id,cat_name FROM " .$ecs->table('category'). " where parent_id = ". $row_3['cat_id'] ." ORDER BY cat_id asc";

$res_4 = $db->query($sql_4);

print "********* 三級(jí)分類：" . $row_3['cat_name'] ."<br>";

//三級(jí)類目子類目循環(huán)

$keyword_3 = '';

$c4 = 0;

while ($row_4 = $db->fetchRow($res_4))

{

$c4 = $c4 + 1;

if ($c4 < 7)

{

//生成三級(jí)類目的關(guān)鍵詞和描述

$keyword_3 = $keyword_3 . replace_cat_name($row_4['cat_name']) . ", ";

}

//直接寫(xiě)三級(jí)類目的值

print "************ 四級(jí)分類：" . $row_4['cat_name'] ."<br>";

$cat_name_4_str = replace_cat_name($row_4['cat_name']);

$keyword_4_str = $cat_name_4_str . " Products, Online Shopping, Taobao Agent, Taobao Dropship";

$desc_4_str = "Online shopping ". $cat_name_4_str ." Products from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

$db->query("UPDATE " .$ecs->table('category'). " SET keywords ='". $keyword_4_str ."', cat_desc ='". $desc_4_str ."' WHERE cat_id =". $row_4['cat_id'] ."");

}

//對(duì)三級(jí)類目字符串進(jìn)行處理更新

$cat_name_3_str = replace_cat_name($row_3['cat_name']);

if (substr($keyword_3,-2) == ', ')

{

$keyword_3 = substr($keyword_3,0,strlen($keyword_3)-2);

}

if ($keyword_3 == '')

{

$keyword_3_str = $cat_name_3_str . " Products";

$desc_3_str = "Online shopping ". $cat_name_3_str ." Products, Browse Through Our Category of ". $cat_name_3_str . " Products and more from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

}

else

{

$keyword_3_str = $cat_name_3_str . ", ". $keyword_3 . " Products";

$desc_3_str = "Online shopping ". $cat_name_3_str ." Products, Browse Through Our Categories of ". $keyword_3 . " Products and more from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

}

$db->query("UPDATE " .$ecs->table('category'). " SET keywords ='". $keyword_3_str ."', cat_desc ='". $desc_3_str ."' WHERE cat_id =". $row_3['cat_id'] ."");

}

//對(duì)二級(jí)類目字符串進(jìn)行處理更新

$cat_name_2_str = replace_cat_name($row_2['cat_name']);

if (substr($keyword_2,-2) == ', ')

{

$keyword_2 = substr($keyword_2,0,strlen($keyword_2)-2);

}

if ($keyword_2 == '')

{

$keyword_2_str = $cat_name_2_str . " Products";

$desc_2_str = "Online shopping ". $cat_name_2_str ." Products, Browse Through Our Category of ". $cat_name_2_str . " Products and more from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

}

else

{

$keyword_2_str = $cat_name_2_str . ", ". $keyword_2 . " Products";

$desc_2_str = "Online shopping ". $cat_name_2_str ." Products, Browse Through Our Categories of ". $keyword_2 . " Products and more from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

}

$db->query("UPDATE " .$ecs->table('category'). " SET keywords ='". $keyword_2_str ."', cat_desc ='". $desc_2_str ."' WHERE cat_id =". $row_2['cat_id'] ."");

//=====================================================================

}

//對(duì)一級(jí)類目字符串進(jìn)行處理更新

$cat_name_1_str = replace_cat_name($row_1['cat_name']);

if (substr($keyword_1,-2) == ', ')

{

$keyword_1 = substr($keyword_1,0,strlen($keyword_1)-2);

}

$keyword_1_str = $cat_name_1_str . ", ". $keyword_1 . " Products";

$desc_1_str = "Online shopping ". $cat_name_1_str ." Products, Browse Through Our Categories of ". $keyword_1 . " Products and more from ". $GLOBALS['_CFG']['shop_name'] .", Factory Price, Worldwide Shipping!";

$db->query("UPDATE " .$ecs->table('category'). " SET keywords ='". $keyword_1_str ."', cat_desc ='". $desc_1_str ."' WHERE cat_id =". $row_1['cat_id'] ."");

}

function replace_cat_name($cate_name)

{

$str = str_replace(' ,',',',str_replace(' ',' ',str_replace(' &',', ',str_replace('&',', ',str_replace(' /','/',str_replace('/',', ',addslashes($cate_name)))))));

return $str;

}

?>

以上就是本文章的內(nèi)容，希望對(duì)大家有所幫助