묻고답하기

쇼핑카트소스인데요
장바구니에 담긴제품을 삭제할려구 삭제버튼을 눌러도
삭제가 안됩니다. 여러번 누르면 어쩌다 삭제가 되긴하는데;
어디가 잘못된건지 알수가없군요;
고수분들도와주세요.

<?
## DB 연결을 위한 페이지 include ########################################################
  include "../EnDefinition/ConnectINFO.inc";
  include "$ConnectINFO/BasicInfo.inc";
  include "$ConnectINFO/function.inc";
  include "$ConnectINFO/Head.inc";
  include "$ConnectINFO/ProductsBackground.inc";

  $session_id = session_id();

  $bg_color01 = "image_058.jpg"; $bg_color02 = "image_017.jpg"; $bg_color03 = "00094C"; $bg_color04 = "image_059.jpg"; $bg_color05 = "image_060.jpg"; $bg_color06 = "main_image014.jpg"; $bg_color07 = "image_019.gif"; $bg_color08 = "F5F5F5"; $logo_img = "logo_sub_011.jpg";

  if($values == 'Regist')
                {
           $isorder = "F";
           $query_max = "SELECT MAX(no)+1 FROM CART";
           $result_max = mysql_query($query_max, $connect);
           $max_no = mysql_fetch_array($result_max);

           if($max_no[0] == '')
                    $cart_no = 1;

           $cart_no = $max_no[0];

           if(!$amount)
                    $amount = 1;

           $query = "INSERT INTO CART VALUES('$cart_no', '$session_id', '$login_id', '$no', '$amount', now(), '$isorder')";
           $result = mysql_query($query);

           if($result)
                                {
                    if($type == "curr")
                                                {                //바로 구매일 경우(상태와 카테고리 번호를 넘긴다.
                             if($login_id)
                                                                {
                                      echo("<meta http-equiv='Refresh' content='0; URL=cart_info.htm?type=$type&cart_no=$cart_no&cat_no=$cat_no&subcat_no=$subcat_no'>");
                                      exit;
                             }
                                                                else
                                                                {
                                      echo("<meta http-equiv='+ '+ 'Refresh' content='0; URL=cart_login.htm?type=$type&cart_no=$cart_no&cat_no=$cat_no&subcat_no=$subcat_no'>");
                                      exit;
                             }
      }
                                                else
                                                {
                             echo("<meta http-equiv='Refresh' content='0; URL=$PHP_SELF?pcat_no=$pcat_no&cat_no=$cat_no&subcat_no=$subcat_no'>");
                             exit;
                    }
           }
                                else
                                {
      error("카트 등록중 오류가 발생했습니다.", "history.go(-1)");
           }
  }
                else if($values == 'modify')
                {
           $query = "UPDATE CART SET amount='$amount' WHERE no=$no";
           $result = mysql_query($query, $connect);

           if($result)
                                {
                    echo("<meta http-equiv='Refresh' content='0; URL=$PHP_SELF?pcat_no=$pcat_no&cat_no=$cat_no&subcat_no=$subcat_no'>");
                    exit;
           }
                                else
      error("카트 변경중 오류가 발생했습니다.", "history.go(-1)");
  }
                else if($values == 'delete')
                {
           $query = "DELETE FROM CART WHERE no=$no";
           $result = mysql_query($query, $connect);

           if($result)
                                {
                    echo("<meta http-equiv='Refresh' content='0; URL=$PHP_SELF?pcat_no=$pcat_no&cat_no=$cat_no&subcat_no=$subcat_no'>");
                    exit;
           }
                                else
      error("카트 삭제중 오류가 발생했습니다.", "history.go(-1)");
  }
                else
                {
           $query = "SELECT t1.no, t1.amount, t2.name, t2.e_name, t2.pan_price, t2.volume, t2.point, t2.point_price FROM CART t1, PRODUCT=t2 ";

           if($login_id)
                    $query = $query . " WHERE t1.product_no=t2.no AND t1.user_id='$login_id' AND t1.isorder='F' ORDER BY t1.no DESC";
                                else
                    $query = $query . " WHERE t1.product_no=t2.no AND t1.session_id='$session_id' AND t1.isorder='F' ORDER BY t1.no DESC";

    $result = mysql_query($query, $connect);
           $total = mysql_affected_rows();
  }
?>
<script language="JavaScript">
function Del_Cart(argc) {
        document.Cart_Del_Form.no.value=argc;
        document.Cart_Del_Form.submit();
}
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('<?echo $ImagesDIR;?>/bt_003_1.jpg','<?echo $ImagesDIR;?>/bt_002_1.jpg','<?echo $ImagesDIR;?>/banner_001_1.jpg','<?echo $ImagesDIR;?>/banner_002_1.jpg','<?echo $ImagesDIR;?>/banner_003_1.jpg')">
<table width="102%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="262927">
  <tr>
    <td valign="top">
                                  <table width="100%" border="0" cellpadding="0" cellspacing="0" background="<?echo $ImagesDIR;?>/<?echo $bg_color01;?>">
        <tr>
          <td width="15"> </td>
          <td width="773">
<? include "$ConnectINFO/TopMenuProducts.inc"; ?>
                                                                                </td>
          <td>
                                                                                  <table width="100%" height="237" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td align="left" valign="bottom">
                                                                                                                                  <table width="100%" height="137" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td width=100% bgcolor="#F5F5F5"> </td>
                    </tr>
                  </table>
                  <table width="100%" height="28" border="0" cellpadding="0" cellspacing="0" bgcolor="373737">
                    <tr>
                      <td width="15" class="999999"> </td>
                    </tr>
                  </table>
                                                                                                                                </td>
              </tr>
            </table>
                                                                                </td>
        </tr>
      </table>
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="16" bgcolor="00094C"> </td>
          <td width="773" valign="top">
                                                                                  <table width="100%" height="237" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="167" align="right" valign="top" bgcolor="3D3D3D">
<? include "$ConnectINFO/LeftMenuProducts.inc"; ?>
                                                                                                                                </td>
                <td align="right" valign="top">
                  <table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td></td>
                    </tr>
                  </table>
                  <table width="580" border="0" cellpadding="0" cellspacing="0" bgcolor="4B4B4B">
                    <tr>
                      <td width="25" bgcolor="4B4B4B" class="999999"><img src="<?echo $ImagesDIR;?>/icon_004.jpg"></td>
                      <td width="112" bgcolor="4B4B4B" class="999999"><img src="<?echo $ImagesDIR;?>/image_068.jpg"></td>
                      <td bgcolor="4B4B4B" class="999999"> </td>
                    </tr>
                  </table>
                  <table width="580" height="10" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td></td>
                    </tr>
                  </table>
                                <table border="0" cellpadding="0" cellspacing="0" width="615">
                                  <tr>
                                           <td width="" height="50" valign="middle">
                                                    <table align="center" border="0" cellpadding="0" cellspacing="0" width="571">
                                                      <tr>
                                                        <td width="24" height="25"><img src="<?echo $ImagesDIR;?>/cart_icon_1.gif" border="0"></td>
                                                 <td width="547" height="25" class=text01> 총 구매금액이 3만원 이상이면 배송료는
                                                          무료입니다. 3만원 미만이면 배송료 3천원이 부과됩니다.</td>
                                        </tr>
                                      </table>
                             </td>
                    </tr>
                                </table>
                <table border="0" cellpadding="0" cellspacing="0" width="" align="center">
                <tr>
                   <td width="" height="20" bgcolor="#454545">
                                <table border="0" cellpadding="0" cellspacing="1" width="" class=text01>
                                <tr>
                                    <td width="183" height="20" align="center">주문상품</td>
                                    <td width="84" height="20" align="center">가격</td>
                                    <td width="65" height="20" align="center">수량</td>
                                    <td width="76" height="20" align="center">합계</td>
                                    <td width="79" height="20" align="center">적립금</td>
                                    <td width="40" height="20" align="center">수정</td>
                                    <td width="40" height="20" align="center">삭제</td>
                                </tr>
                                </table>
                        </td>
                </tr>
                </table>        
                <table border="0" cellpadding="0" cellspacing="0" width="570" align="center">
                <tr>
                   <td width="570" height="10"></td>
                </tr>
                </table>        
                <table border="0" cellpadding="0" cellspacing="0" width="570" align="center">
                <tr>
                   <td width="570" height="25" bgcolor="#646464">
                            <table border="0" cellpadding="0" cellspacing="1" width="570" class=text01>
                        <?
                                
                                if($total == 0) {
                                        echo("
                                                <tr bgcolor='#646464'>
                                                        <td height='70' align='center' valign='middle'><b>장바구니가 비어 있습니다.</b></td>
                                                </tr>
                                                ");
                                }
                                
                                for($i=0 ; $i<$total ; $i++) {
                                
                                        mysql_data_seek($result, $i);
                                        $row = mysql_fetch_array($result);
                                        
                                        $pan_price = number_format($row[pan_price]);
                                        $hap_price = number_format($row[pan_price]*$row[amount]);
                                        $point = $row[point_price];
                                        $hap_point = $row[point_price]*$row[amount];
                                        $total_price = $total_price + ($row[pan_price]*$row[amount]);

                                        echo ("
                                                <form name='Modify' method='post' action='$PHP_SELF'>
                                                <input type='hidden' name='no' value='$row[no]'>
                                                <input type='hidden' name='values' value='modify'>
                                                <input type='hidden' name='pcat_no' value='$pcat_no'>
                                                <input type='hidden' name='cat_no' value='$cat_no'>
                                                <input type='hidden' name='subcat_no' value='$subcat_no'>

                                                <tr class=text01>
                                                        <td width='183' height='25' align='left'> $row[name]($row[e_name]) - $row[volume]</td>
                                                        <td width='84' align='center'>$pan_price 원</td>
                                                        <td width='65' align='center'+ '>
                                                                <select name='amount'+ ' size='1'>
                                                ");

                                        for ($j=1 ; $j<101 ; $j++) {

                                                echo ("<option value='$j'");
                                                                        
                                                if ($j == $row[amount]) {
                                                        echo (" selected");
                                                }
                                                
                                                echo (">$j EA</option>");
                                        }
                                                        
                                        echo ("                
                                                                </select>
                                                        </td>
                                                        <td width='76' align='center'>$hap_price 원</td>
                                                        <td width='79' align='center'>$hap_point ($row[point]%)</td>
                                                        <td width='40' align='center'><input type=submit value="수정" style="cursor:hand;border:1px solid #cccccc; background-color:#545454; color:#ffffff; font-size:11px;"><!--<input type='image' src='$ImagesDIR/cart_icon_2.gif' border='0'>--></td>
                                                        <td width='40' align='center'><input type=submit value="삭제" style="cursor:hand;border:1px solid #cccccc; background-color:#545454; color:#ffffff; font-size:11px;" onclick="JavaScript:Del_Cart('$row[no]');"><!--<a href="JavaScript:Del_Cart('$row[no]'+ ');"><img src='$ImagesDIR/cart_icon_2.gif' border='0'></a>--></td>
                                                </tr>
                                                </form>n
                                                ");

      if($i < $total - 1)
                                                  echo "<tr><td colspan=7 height=1 bgcolor=#000000></td></tr>n";
                                }
                        ?>
                        </table>
                        </td>
                </tr>
                </table>                
                <table border="0" cellpadding="0" cellspacing="0" width="570" align="center">
                <tr>
                   <td width="570" height="5"></td>
                </tr>
                </table>        
                <table border="0" cellpadding="0" cellspacing="0" width="570" align="center">
                <tr>
                   <td width="570" height="25" bgcolor="#545454">
                                <table border="0" cellpadding="0" cellspacing="1" width="570">
                                <tr>
                                    <td width="568" height="25" align="right" class=text01> <b><font color="#ffcc00">총 주문합계(배송료 제외)는 <?=number_format($total_price)?>원입니다.</font></b> </td>
                                </tr>
                                </table>
                        </td>
                </tr>
                </table>
                <table border="0" cellpadding="0" cellspacing="0" width="570" align="center">
                <tr>
                   <td width="570" height="45" align="center">
<?
                if($total_price)
                {
                                if($login_id)
                                                echo ("<a href='$MembersDIR/cart_info.htm?cat_no=$cat_no'>");
                                else
                                                echo ("<a href='$MembersDIR/cart_login.htm?cat_no=$cat_no'>");
                }
?>
                           <img src="<?echo $ImagesDIR;?>/order_icon_1.gif" border="0"></a>    
                           <a href="<?echo $HomeURL;?>"><img src="<?echo $ImagesDIR;?>/shopping_icon.gif" border="0"></a>
                   </td>
                </tr>
                </table>
<form name='Cart_Del_Form' method='post' action='<?=$PHP_SELF?>'>
        <input type='hidden' name='no' value=''>
        <input type='hidden' name='values' value='delete'>
        <input type="hidden" name="pcat_no" value="<?=$pcat_no?>">
        <input type="hidden" name="cat_no" value="<?=$cat_no?>">
        <input type="hidden" name="subcat_no" value="<?=$subcat_no?>">
</form>
                  <table width="100%" height="27" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td bgcolor="262927"> </td>
                    </tr>
                  </table>
                                                                                                                                </td>
              </tr>
            </table></td>
          <td> </td>
          <td> </td>
        </tr>
      </table>
<? include "$ConnectINFO/Bottom.inc"; ?>
    </td>
  </tr>
</table>
</body>
</html>
글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
최선희 메일폼을 만들고 싶어요~~ [1] 2007.08.10
클린아이 PHP 제로보드 코멘트 함수?  
검객 글자 크기 조절 스크립트의 수정에 관한 질문 [3] 2007.08.10
Marxi 외부로그인으로 새창을 띄울 경우. [1] 2007.08.10
shk905 좋은 ftp좀 추천해주세요~ [3] 2007.08.10
뽀뽀 노프레임에서 게시판에러에 대해서 질문이요..  
up 나모웹에디터 메뉴표시줄  
LEiTi 이건 어떻게 만든걸 까요? [2] 2007.08.10
박계균 이 소스에서 잘못된것이 뭔지 알려주세요!  
임종훈 제 컴을 서버로 쓰는데 올린 파일이 다운이 안되요..  
고펑 /usr/local/mysql/data 디렉토리 안에 [1] 2011.04.07
고펑 /usr/local 용량부족.. [1] 2007.08.10
어린왕자 펼침 목록을 사용하면서 이런것이 어떻게 하면 될지요...  
나그네인생 nfo를 웹에서 구현하는 소스를 찾았습니다만 도움을 요청합니다~  
박계균 저 밑에 질문올린사람입니다.  
백종욱 css를 사용하지 않고 하이퍼링크 밑줄 없애기? [5] 2007.08.10
데빌스텔스 드림위버에서 표나 셀에 테두리 어케 넣죠? [1] 2007.08.10
염우철 레이아웃 어떻게 올리는 거예여? [2] 2007.08.10
김진영 레이아웃에뜨는 링크걸기 [2] 2007.08.10
옥재우 드림위버MX2004 / JavaScript  
김동원 그림에 마우스 커서 댓을때 레이어로 다른 그림 보여주기  
강진영 Iframe 링크 관련 질문 입니다.. [1] 2007.08.10
이거 좀 가르쳐주세요~ [6] 2007.08.10
하서진 이폰트좀 제발 알려주세요^^;;;;;;;;부탁드려요 [1] 2007.08.10
사랑하나 마우스 오른쪽 클릭하기가 잘 안되네요 [2] 2007.08.10
장현재 포샵에서 이런게 가능할까요? [5] 2007.08.10
아발론 [급]제로보드를 이용하여 동영상을 올렸는데 안보이네요.. [2] 2007.08.10
한덕현 제로보드를 처음사용하는 유저인데요...문제점이. [3] 2007.08.10
꼭 답변좀 부탁드려요..ㅎㅎ [1] 2007.08.10
초롱이 일러스트 작업한 걸 포토샵에서 불러오면 [5] 2007.08.10