묻고답하기

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

총 주문한금액이 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 남기남
승훈 아이피에 관련된것 알려주세요! [2] 2007.08.10
김형민 홈페이지 메인에 게시판 최신목록 들어가는거 모르겠어요!! [1] 2007.08.10
승훈 아이피 차단 소스!!!! 팁 알려주세요. [2] 2007.08.10
남승미 가족 홈페이지를 만들려고 하는데....게시판을 어떻게 달아야 하는지...초보입니다.. [3] 2007.08.10
난자상학 팝업창 띄우기 좀 알려주세요.  
Daylight 서기님 강좌중에 시게만드는거..  
박소현 제발 이거좀 해결해주세요..이거같고 4시간째 매달리고 있는중. [4] 2007.08.10
유성목 홈페이지 버튼 수정하는 방법좀 알려주세요~~~!! [8] file 2007.08.10
Darkside 접속할때마다 다른 플래시파일 띄우는법  
tammy 다운로드창을 뜨게 하는 방법(php) [1] 2007.08.10
정지현 테이블위에 이것(; echo)안보이게할려면 [2] 2007.08.10
오석정 이런건 이미지레디로 어떻게 만드는지요? [1] file 2007.08.10
박기현 레드헷 리눅스 9.0에 APM을 설치하였는데... [3] 2007.08.10
쓸쓸한달빛 가정집에서 서버를 돌릴때 질문 사항들입니다. [4] 2007.08.10
정윤 PHP관련 질문이요 ㅜㅠ [1] 2007.08.10
언약 매일 새로운 메세지가(성경구절이나 격언) 나타나게 하고 싶은데..  
유진 자바로 된 메뉴가 안보일 경우  
승훈 자신의 홈페이지에 방문한 사람 IP를 운영자에게만 출력하는 방법알려주세요!  
강지훈 이 네비게이션메뉴가 안되는 이유가 뭘까요... [1] 2007.08.10
조승우 글쓰기가 않됩니다.  
patou mysql_fetch_array() 에러 [2] 2007.08.10
이현석 본인이 방문한 url 을 저장할 수 있는 방법.  
ufo220 두개의 스크립트가 충돌이 납니다  
정대환 또 다른 질문이요. [3] 2007.08.10
moonsoo 일본어 질문입니다. [2] 2007.08.10
박정근 PHP질문입니다 ㅠㅠ  
HoYS 아이프레임으로 게시판을 넣으면 메뉴 하이퍼링크가 사라져요 ㅠ ㅠ  
정형재 쿼리문 한번 봐주세요!!! [3] 2007.08.10
이상훈 아이 프레임을 사용했는데 , 내용이 전부 왼쪽으로 쏠리네요. [1] 2007.08.10
박세진 제 게시판에 cgi 프로그램을 이용하여 자동적으로 글을 등록 할 수 있을 가요?