묻고답하기

쇼핑몰에서요........

총 주문한금액이 9만원미만일경우 배송료 5,000원을 추가로 받고 싶은데요.

9만원이상은 무료배송이구요.........

그런데 배송료 5,000원 추가로 더 받게할려는 소스좀 알려주세요~ 파일은 product_basket.php 이구요.

밑에 소스 시작됩니다.

-------------------------------------------------------------------------------

<?
    include "../include/common_inc.php";

                // 장바구니 코드 생성하기 -----------------------------------------
                if (strlen($HTTP_COOKIE_VARS["tempid"])==0) {
                        $tempid = md5(uniqid(rand()));
                        SetCookie("tempid","$tempid",0);
                }else{
                        $tempid = $HTTP_COOKIE_VARS["tempid"];
                }


      // 새로 장바구니에 상품 추가
                $basket_id =  "tempid = '$tempid' and";

                $qry_search = "SELECT * FROM fine_product_basket where $basket_id product_menuid = '$product_menuid'+ '+ ' and product_seqno = '$product_seqno' and product_ordernum = '+ 'X' order by seq_no desc";
                $rst_search = mysql_query($qry_search);
                $row_search = mysql_fetch_array($rst_search);
//                echo "$qry_search <BR><BR>";


                // $mode에 따른 작업처리 ----------------------------------------
                switch($mode) {

                        case "update":
                                // 수량만 변경한(상품특성이 변하지 않은) 경우
                                $sql = "UPDATE fine_product_basket SET product_amount = $product_amount WHERE $basket_id seq_no='$product_seqno' AND product_ordernum = 'X'";
                                mysql_query($sql);
//                        echo "$sql <BR><BR>";
                        break;

                        case "del":
                        $sql = "DELETE FROM fine_product_basket WHERE $basket_id seq_no='$product_seqno' AND product_ordernum = 'X'";
                        mysql_query($sql);
//                                        echo "$sql <BR><BR>";
                        break;

                        default :
                                if ($row_search){
                                        // 상품 수량 추가
                                        $amount_new = $row_search[product_amount] + $product_amount;
                                        $sql = "update fine_product_basket set product_amount = $amount_new where $basket_id product_menuid = '$product_menuid' and product_seqno = '$product_seqno' and product_ordernum = 'X'";
                                        mysql_query($sql);
//                                echo "$sql <BR><BR>";
                                } else {
                                        // 상품 추가
                                        $vdate = date("Ymd");
                                        $sql = "INSERT INTO fine_product_basket
                                                                (seq_no, tempid, product_menuid, product_seqno, product_name, product_price, product_amount, product_ordernum, date)
                                                                VALUES ('', '$tempid', '$product_menuid', '$product_seqno', '$product_name', $product_price, '1', 'X', $vdate)";
                                        mysql_query($sql);
        //                                echo "$sql <BR><BR>";
                                }        
                        break;
                }
                
                $qry = "SELECT * FROM fine_product_basket where $basket_id product_ordernum = 'X' order by seq_no desc";
                $rst = mysql_query($qry);
//                echo "$qry <BR><BR>";

        function basket()
        {
        global $tempid,$rst,$product_menuid,$product_seqno,$form_num,$totalprice,$basket_menu_id;
                
                $totalprice = 0;
                $form_num = 0;
                                while($row = mysql_fetch_array($rst)){
                                $sumprice = $row[product_price] * $row[product_amount];
                                $form_num = $form_num+1;
                                echo "
                                                        <form name='form$form_num' action='$PHP_SELF' method='post'>
                                                        <input type=hidden name=product_seqno value="".$row[seq_no]."">
                                                        <input type=hidden name=product_menuid value="".$row[product_menuid]."">
                                                        <input type=hidden name=mode>
                                                        <TR align=center>
                                                                <TD><A HREF='product_detail.php?menu_id=$row[product_menuid]&seq_no=$row[product_seqno]'>$row[product_name]</A></TD>
                                                                <TD>".number_format($row[product_price])."</TD>
                                                                <TD>
                                                                        <table cellpadding=0 cellspacing=0 border=0>
                                                                        <tr>
                                                                                <td rowspan=2><input class='box' readonly name=product_amount size=2 value="".$row[product_amount]."" onChange="send(document.form$form_num,'update')" ></td>
                                                                                <td width=20 align=center><a href=".javascriptfrm_up_qty(document.form$form_num,'update');"><img src="./images/up_icon.gif" width=15 height=13 border=0></a></td>
                                                                        </tr>
                                                                        <tr>
                                                                                <td width=20 align=center><a href=".javascriptfrm_down_qty(document.form$form_num,'update');"><img src="./images/down_icon.gif" width=15 height=12 border=0></a></td>
                                                                        </tr>
                                                                        </table>
                                                                </TD>
                                                                <TD>".number_format($sumprice)."</TD>
                                                                <TD><a href=".javascriptsend(document.form$form_num,'del')"><FONT COLOR='red'><B>X</B></FONT></A></TD>
                                                        </TR>
                                                        </form>
                                ";
                                 $totalprice += $sumprice;
                                 $basket_menu_id = $row[product_menuid];
                                }

                                if ($totalprice > 0) {
                                echo "
                                                        <TR height=30  bgcolor='D4E1EC'>
                                                                <TD colspan=3 align=right>Total :  </TD>
                                                                <TD colspan=2 align=center>".number_format($totalprice)." 원</TD>
                                                        </TR>
                                ";
                                }else{

                                echo "
                                                        <TR height=25>
                                                                <TD colspan=5 align=center>쇼핑하신 상품이 없습니다.</TD>
                                                        </TR>
                                ";
                                }
        }

        $_INC_FILE = _BASE_DIR."/product_display/html/product_basket.html";
        // 무조건 모든 파일에서 _MAIN_SKIN을 include 한다.
        include _MAIN_SKIN;
?>
글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
곰형님 홈페이지 하단 변경방법 [1] file 2013.12.09 by 아싸로또1등맞고싶어
rallablue 특정 게시판에서 쪽지기능이 안되요  
월넛 댓글을 달면 자꾸 이메일로 통보가 옵니다 [2] 2013.12.09 by 애니즌
애니즌 애드온 제작할 때 사용되는 add 있잖아요..!  
포쿠쿠 모바일 버전을 PC버전에서도 계속 사용하게 하려면 [1] 2013.12.09 by 벨몽이
곰형님 xe1.4.2.3 과 1.4.4.1 core 두개 버젼 core 어디서구하나요 [2] 2013.12.09 by Real
참치찌개 닉네임 앞 특수문자 출력  
띠로리로리 레이아웃 백그라운드가 안먹혀요T_T [1] 2013.12.09 by 때린데 또때려
DavidBeckham GoDaddy 호스팅 질문입니다. [1] 2013.12.09 by 때린데 또때려
seanwiz 1.7.3.6 새로 설치 후, 404 Not Found 페이지가 뜹니다. [2] 2013.12.09 by 구름나무바위
만나나나 Elkha - Gray Style 배너 삽입방법 file  
클로여 [급] 게시판에 글이 안써집니다ㅜㅜ  
캠핑메이트 답글이 달린 게시글 삭제 수정 금지 코드 어디에 넣어줘야 할지.. 자세히 알려주실분.. [1] 2013.12.08 by 마야^
겨레사랑 네이버 지도 오픈 API '잘못된 요청입니다.'에러가 나요 [1] file 2013.12.08 by KrteamENT
xe아메바 쪽지함의 새쪽지 삭제 오류  
빅드림 XE 가 죽었어요.. 이럴수가 있나요?? [2] file 2013.12.08 by explode
처리낭군 로그인 정보 보기에서 '작성 댓글 보기' 눌렀을때... file  
펭구 구문 오류로 홈페이지가 열리지 않습니다. [1] 2013.12.07 by 투씨
enzoy 보드 패키지를 tgz 파일로 받으려면 어디에서? [2] 2013.12.07 by 퍼니엑스이
TakeUrban 댓글 입력창 크기 file  
지미김 'UPDATE' 명령은 다음 사용자에게 거부되었습니다  
TakeUrban sketchbook5 유투브 갤러리 게시판 스킨 썸네일 이미지 표시 [3] 2013.12.07 by 파워XE
노리넷[썰코] 절약모드를 어떤식으로 만들수있을까요?  
rallablue 포인트랭킹 리스트 30까지 했는데 왜 20까지만 뜨죠? [1] file 2013.12.07 by KrteamENT
microwave 홈페이지에 글이 안올라가집니다. ㅠㅠ [1] file 2013.12.07 by Ruatic™
흐르는가람 글쓰기 중 첨부파일과 같이 올릴 때 부하? 현상 아시는 분 있나요? [2] 2013.12.07 by KrteamENT
벳텐 [Xe 1.7] 댓글알림 기능생성 & 모바일 메뉴 생성법 [1] file 2013.12.07 by KrteamENT
nado0124 컨텐츠 확장 위젯에서 확장변수 출력되게 할 때 줄바꿈 되게 하는 법  
애니즌 파일 업로드시 선택 창 [2] file 2013.12.07 by explode
닉네임뭐에요 비회원도 추천기능 쓸수있게 어떻게해요?