{"id":198998,"date":"2025-05-03T09:08:59","date_gmt":"2025-05-03T01:08:59","guid":{"rendered":"https:\/\/server.hk\/cnblog\/198998\/"},"modified":"2025-05-03T09:08:59","modified_gmt":"2025-05-03T01:08:59","slug":"%e7%bb%99ecshop%e5%95%86%e5%93%81%e8%af%a6%e6%83%85%e9%a1%b5%e5%a2%9e%e5%8a%a0%e8%87%aa%e5%ae%9a%e4%b9%89title%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/198998\/","title":{"rendered":"\u7ed9\u201cECSHOP\u5546\u54c1\u8be6\u60c5\u9875\u201d\u589e\u52a0\u81ea\u5b9a\u4e49TITLE\u7684\u65b9\u6cd5"},"content":{"rendered":"

\u6211\u60f3\u5728ECSHOP\u540e\u53f0\u81ea\u5b9a\u4e49\u6bcf\u4e2a\u5546\u54c1\u8be6\u60c5\u9875\u7684TITLE, \u8be5\u5982\u4f55\u6765\u5b9e\u73b0\u5462\uff1f\uff1f\uff08\u542c\u8bf4\u8fd9\u6837\u4f1a\u5bf9SEO\u66f4\u6709\u5229\uff09
<\/strong>
\u4e0b\u9762\u5c31\u6765\u8bb2\u4e00\u8bb2\u5177\u4f53\u7684\u4fee\u6539\u65b9\u6cd5\uff1a
\u6ce8\uff1a\u4ee5\u4e0b\u6559\u7a0b\u662f\u5728\u201c\u672a\u8fdb\u884c\u8fc7\u4efb\u4f55\u4fee\u6539\u7684 ecshop2.7.2 \u4ee3\u7801 +  \u5b98\u65b9\u9ed8\u8ba4\u6a21\u677f\u201d \u57fa\u7840\u4e0a\u8bb2\u89e3\u7684\u3002 <\/p>\n

\u7b2c1\u6b65\uff1a \u4fee\u6539\u6570\u636e\u5e93\u7ed3\u6784\uff0c\u5176\u5b9e\u5c31\u662f\u589e\u52a0\u4e2a\u5b57\u6bb5<\/p>\n

\u8fdb\u5165 \u540e\u53f0 \u300b\u6570\u636e\u5e93\u7ba1\u7406 \u300bSQL\u67e5\u8be2   \uff0c
\u5728\u8f93\u5165\u6846\u91cc\u8f93\u5165\u4e0b\u9762SQL\u8bed\u53e5\uff0c\u5e76\u70b9\u51fb\u201c\u63d0\u4ea4\u67e5\u8be2\u201d <\/p>\n\n\n\n
ALTER<\/span> TABLE<\/span> `ecs_goods`<\/span> ADD<\/span> `goods_title`<\/span> VARCHAR<\/span>(<\/span> 150<\/span> )<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ”<\/span> AFTER<\/span> `goods_name`<\/span> <\/font><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7b2c2\u6b65\uff1a
\n
\u4fee\u6539\u540e\u53f0\u6a21\u677f\u6587\u4ef6  \/admin\/templates\/goods_info.htm
\n
\u627e\u5230 <\/p>\n\n\n\n
<table width=”90%” id=”general-table” align=”center”><\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5728\u5b83\u4e0b\u9762\u589e\u52a0\u4e00\u884c\u4ee3\u7801
\n <\/p>\n\n\n\n
<tr><td class=”label”>\u81ea\u5b9a\u4e49\u5546\u54c1\u9875\u9762TITLE<\/td><td><input type=”text” name=”goods_title” value=”{$goods.goods_title|escape}” size=”50″ \/><\/td><\/tr><\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 \u7b2c3\u6b65\uff1a
\n
\u4fee\u6539\u540e\u53f0\u7a0b\u5e8f\u6587\u4ef6 \/admin\/goods.php
\n
\u627e\u5230
\n <\/p>\n\n\n\n
$sql = “INSERT INTO ” . $ecs->table(‘goods’) . ” (goods_name, goods_name_style, goods_sn, ” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4fee\u6539\u4e3a\uff08
\n\u6ce8\u610f\u4e00\u5171\u80fd\u641c\u5230\u4e24\u5904\uff0c\u6bcf\u5904\u90fd\u8981\u4fee\u6539<\/span>\uff09
\n <\/p>\n\n\n\n
$sql = “INSERT INTO ” . $ecs->table(‘goods’) . ” (goods_name, goods_title, goods_name_style, goods_sn, ” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7ee7\u7eed\u627e\u5230 <\/p>\n\n\n\n
“VALUES (‘$_POST[goods_name]’, ‘$goods_name_style’, ‘$goods_sn’, ‘$catgory_id’, ” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4fee\u6539\u4e3a\uff08
\n\u6ce8\u610f\u4e00\u5171\u80fd\u641c\u5230\u4e24\u5904\uff0c\u6bcf\u5904\u90fd\u8981\u4fee\u6539<\/span>\uff09 <\/p>\n\n\n\n
“VALUES (‘$_POST[goods_name]’,’$_POST[goods_title]’, ‘$goods_name_style’, ‘$goods_sn’, ‘$catgory_id’, ” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7ee7\u7eed\u641c\u7d22\u627e\u5230\u4e0b\u9762\u4ee3\u7801
\n <\/p>\n\n\n\n
“goods_name = ‘$_POST[goods_name]’, ” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5c06\u5b83\u4fee\u6539\u4e3a
\n <\/p>\n\n\n\n
“goods_name = ‘$_POST[goods_name]’, goods_title=’$_POST[goods_title]’,” .<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7b2c4\u6b65\uff1a<\/p>\n

\u4fee\u6539ECSHOP\u524d\u53f0\u5546\u54c1\u7a0b\u5e8f\u6587\u4ef6\uff0c
\n
\u6253\u5f00  \/goods.php  \u6587\u4ef6
\n
\u627e\u5230
\n <\/p>\n\n\n\n
$smarty->assign(‘page_title’,          $position[‘title’]);                    \/\/ \u9875\u9762\u6807\u9898<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4fee\u6539\u4e3a
\n <\/p>\n\n\n\n
$page_title=!empty($goods[‘goods_title’]) ? $goods[‘goods_title’] : $position[‘title’];
  $smarty->assign(‘page_title’,          $page_title);                    \/\/ \u9875\u9762\u6807\u9898<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 \u6700\u540e\uff0c\u522b\u5fd8\u4e86\u5230\u540e\u53f0\u6e05\u9664\u7f13\u5b58\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6211\u60f3\u5728ECSHOP\u540e\u53f0\u81ea\u5b9a\u4e49\u6bcf\u4e2a...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-198998","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/198998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=198998"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/198998\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=198998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=198998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=198998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}