{"id":199571,"date":"2025-05-03T12:17:49","date_gmt":"2025-05-03T04:17:49","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199571\/"},"modified":"2025-05-03T12:17:49","modified_gmt":"2025-05-03T04:17:49","slug":"ecshop%e9%80%80%e5%87%ba%e7%bd%91%e9%a1%b5%e5%90%8e%e4%b8%8d%e8%83%bd%e4%bf%9d%e7%95%99%e4%b8%8a%e4%b8%80%e6%ac%a1%e5%b7%b2%e6%b7%bb%e5%8a%a0%e5%88%b0%e8%b4%ad%e7%89%a9%e8%bd%a6%e4%b8%ad%e7%9a%84","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199571\/","title":{"rendered":"ecshop\u9000\u51fa\u7f51\u9875\u540e\u4e0d\u80fd\u4fdd\u7559\u4e0a\u4e00\u6b21\u5df2\u6dfb\u52a0\u5230\u8d2d\u7269\u8f66\u4e2d\u7684\u5546\u54c1"},"content":{"rendered":"

\u7ecf\u5e38\u6709\u4e0d\u540c\u7528\u6237\u7559\u8a00\uff0cecshop\u5076\u5f88\u7325\u7410\u6084\u7136\u65e0\u58f0\u7684\u5c06\u6d4f\u89c8\u5668\u7a97\u53e3\u5173\u95ed\u4e86\uff0c\u4ffa\u591a\u5e74\u79ef\u7d2f\u5230\u5230\u8d2d\u7269\u8f66\u7684\u5546\u54c1\u77ac\u95f4\u7070\u98de\u70df\u706d\uff0c\u6b64\u523b\u4f60\u53eb\u6211\u600e\u4e48\u6de1\u5b9a\uff0c\u6bd4\u706b\u7403\u8fd8\u706b\u7684\u6012\u706b\u5c31\u5728\u8fd9\u4e00\u523b\u7206\u53d1\u4e86\uff0c\u4eb2\u7231\u7684\u7ba1\u7406\u5458\uff0c\u5ba2\u6237\u6084\u7136\u6d41\u5931\uff0c\u8ba2\u5355\u4e00\u5929\u6bd4\u4e00\u5929\u5c11\uff0c\u4f60\u8fd8\u5982\u6b64\u6de1\u5b9a\u5417\uff1f\u60f3\u633d\u56de\u8fd9\u4e00\u5207\u635f\u5931\u5417\uff1f\u8d76\u7d27\u8ddf\u7740\u6211\u6765\u4e00\u6b65\u4e00\u6b65\u5f80\u4e0b\u505a\u5427\uff0c\u5ba2\u6237\u4e0d\u65ad\uff0c\u638c\u58f0\u54cd\u8d77\uff0c\u95f2\u6765\u86cb\u75bc\uff0c\u5148\u95ed\u5634\uff0c\u5e9f\u8bdd\u5c11\u8bf4\uff0c\u8fdb\u5165\u4e3b\u9898\uff0c\u5f00\u59cb\u4fee\u6539\u4e86\u55bd<\/p>\n

\u627e\u5230includes\/cls_session.php\u5927\u7ea6\u5728268\u884c\u67e5\u627e\u4e0b\u9762\u4ee3\u7801\uff1a<\/p>\n

\u590d\u5236\u5185\u5bb9\u5230\u526a\u8d34\u677f<\/span>
\n\u6298\u53e0<\/span>
\nPHP \u4ee3\u7801<\/span> <\/p>\n

    \n
  1. if<\/span> (!<\/span>empty<\/span>empty<\/span>(<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]))  <\/span><\/span><\/li>\n
  2. {  <\/span><\/li>\n
  3.     $this<\/span>->db->query(<\/span>‘DELETE FROM ‘<\/span> . <\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>) . <\/span>” WHERE session_id = ‘$this->session_id'”<\/span>);  <\/span><\/span><\/li>\n
  4. }  <\/span><\/li>\n<\/ol>\n

    \u66ff\u6362\u4e3a\uff1a<\/p>\n

    \u590d\u5236\u5185\u5bb9\u5230\u526a\u8d34\u677f<\/span>
    \n\u6298\u53e0<\/span>
    \nXML\/HTML \u4ee3\u7801<\/span> <\/p>\n

      \n
    1. if (!empty($GLOBALS[‘ecs’]))  <\/span><\/li>\n
    2. {  <\/span><\/li>\n
    3.     $this-><\/span>db-<\/span>><\/span>query(‘DELETE FROM ‘ . $GLOBALS[‘ecs’]-<\/span>><\/span>table(‘cart’) . ” WHERE <\/span>session_id<\/span> = <\/span>‘$this->session_id’<\/span> and <\/span>user_id<\/span> =<\/span>”<\/span>“);  <\/span><\/span><\/li>\n
    4. }  <\/span><\/li>\n<\/ol>\n

      \u63a5\u4e0b\u6765\uff0c\u5728\u540c\u76ee\u5f55\u4e0b\u627e\u5230lib_main.php\u5b9a\u4f4d\u5230\u9875\u9762\u7684\u6700\u540e\uff0c\u65b0\u589e\u52a0\u4e00\u6bb5\u4ee3\u7801\u4ee5\u5b8c\u6210\u8d2d\u7269\u8f66\u4e0d\u518d\u88ab\u6e05\u7a7a\u7684\u70e6\u607c\u3002<\/p>\n

      \u590d\u5236\u5185\u5bb9\u5230\u526a\u8d34\u677f<\/span>
      \n\u6298\u53e0<\/span>
      \nPHP \u4ee3\u7801<\/span> <\/p>\n

        \n
      1. \/* \u66f4\u65b0\u7528\u6237\u8d2d\u7269\u8f66\u9000\u51fa\u4e0d\u6e05\u7a7a\u8d2d\u7269\u8f66*\/<\/span>   <\/span><\/span><\/li>\n
      2. $sql<\/span> = <\/span>“update “<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>).<\/span>” set user_id =”<\/span>.<\/span>$_SESSION<\/span>[<\/span>‘user_id’<\/span>].<\/span>” where session_id = ‘”<\/span>.SESS_ID.<\/span>“‘”<\/span>;  <\/span><\/span><\/li>\n
      3.  $GLOBALS<\/span>[<\/span>‘db’<\/span>] -> query(<\/span>$sql<\/span>);  <\/span><\/span><\/li>\n
      4. l1 = “update “<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>).<\/span>” set session_id ='”<\/span>.SESS_ID.<\/span>“‘ where user_id = ‘”<\/span>.<\/span>$_SESSION<\/span>[‘user_id<\/span>‘].”‘<\/span>“;  <\/span><\/span><\/li>\n
      5.  $GLOBALS<\/span>[<\/span>‘db’<\/span>] -> query(<\/span>$sql1<\/span>);  <\/span><\/span><\/li>\n
      6.  $re<\/span> = <\/span>$GLOBALS<\/span>[<\/span>‘db’<\/span>] -> getAll(<\/span>“select *,sum(goods_number) as goods_number from “<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>).<\/span>” where user_id = ‘{$_SESSION[‘user_id’]}’ and session_id = ‘”<\/span>.SESS_ID.<\/span>“‘ group by goods_id”<\/span>);  <\/span><\/span><\/li>\n
      7.   <\/span><\/li>\n
      8.  if<\/span>(<\/span>$re<\/span>){  <\/span><\/span><\/li>\n
      9.    foreach<\/span> (<\/span>$re<\/span> <\/span>as<\/span> <\/span>$k<\/span> => <\/span>$v<\/span>){  <\/span><\/span><\/li>\n
      10.   $sql<\/span> = <\/span>“update “<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>). <\/span>” set goods_number = “<\/span>.<\/span>$v<\/span>[<\/span>‘goods_number’<\/span>].<\/span>” where rec_id = “<\/span>.<\/span>$v<\/span>[<\/span>‘rec_id’<\/span>];  <\/span><\/span><\/li>\n
      11.   $GLOBALS<\/span>[<\/span>‘db’<\/span>] -> query(<\/span>$sql<\/span>);   <\/span><\/span><\/li>\n
      12.   $sql<\/span> = <\/span>“delete from “<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘cart’<\/span>).<\/span>” where rec_id <> {$v[‘rec_id’]} and user_id = ‘{$_SESSION[‘user_id’]}’ and session_id = ‘”<\/span>.SESS_ID.<\/span>“‘ and goods_id = “<\/span>.<\/span>$v<\/span>[<\/span>‘goods_id’<\/span>];  <\/span><\/span><\/li>\n
      13.    $GLOBALS<\/span>[<\/span>‘db’<\/span>] -> query(<\/span>$sql<\/span>);  <\/span><\/span><\/li>\n
      14.   }  <\/span><\/li>\n
      15. }  <\/span><\/li>\n<\/ol>\n

        \u5230\u8fd9\u91cc\u4e00\u5207\u641e\u5b9a\uff0c\u8bb0\u4f4f\u540e\u53f0\u66f4\u65b0\u7f13\u5b58\u540e\u6d4b\u8bd5\u4e0b\uff0c\u662f\u4e0d\u662f\u771f\u7684\u641e\u5b9a\u4e86\uff0c\u5982\u679c\u6709\u8fd8\u95ee\u9898\uff0c\u60a8\u53ef\u4ee5\u8054\u7cfb\u4e00\u5546\u8bbe\u8ba1\u4e8c\u6b21\u5f00\u53d1\u7684\u54e6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

        \u7ecf\u5e38\u6709\u4e0d\u540c\u7528\u6237\u7559\u8a00\uff0cecshop...<\/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-199571","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199571","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=199571"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199571\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}