Devlog
Published 2022. 1. 6. 01:32
[2018-2] 웹프로그래밍II 프로젝트 - 장바구니 구현하기 학교

여태까지 수행한 과제랑 프로젝트 정리하면서 작성하는 글...

그 당시 프로젝트를 하면서 제일 힘들었던 부분이 장바구니 구현이였는데 이 부분만 따로 작성하고자 한다

 

 
장바구니 구현 (basket.php)
<?php
header('Content-type:text/html; charset=utf-8');
session_start();
include "../db/dbcon.php";

$customer_name = $_SESSION['name'];
$custom_id = $_SESSION['userid'];
$new = $_POST['new'];
// -----------------------------------------------------------------------------------------
//추가할 상품이 있는 경우(장바구니 버튼을 클릭했을 때) // 출력 폼 추가
// -----------------------------------------------------------------------------------------

?>
<!DOCTYPE html>
<html>
 <head>
  <meta charset="utf-8">
  <title>새벽서점</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.3.1.min.js"></script>
    <script>
    $(function(){
        //전체선택 체크박스 클릭
        $("#check_all").click(function(){
            //전체선택 체크박스가 체크된상태일경우
            if($("#check_all").prop("checked")) {
                //input type 이 checkbox인 경우 전부 선택
                $("input[type=checkbox]").prop("checked",true);
            } else {
                //input type 이 checkbox인 경우 전부 해제
                $("input[type=checkbox]").prop("checked",false);
            }
        })
    })
 </script>
 <script>
function check01(){
 document.checkbox01.action = "../db/basket_delete.php";
 document.checkbox01.submit();
}
function qty01(){
 document.checkbox01.action = "basket.php";
 document.checkbox01.submit();
}
</script>
    <link href="/css/full.css" rel="stylesheet">
      <link href="/css/basket.css" rel="stylesheet">
    </head>
<body>
   <? include "../lib/top_menu.php";?>
<div id="main">
  <div id="join_top">
  <div id="join_title">
   장바구니
  </div>  
    <!--상품 출력폼-->
  <span id="join_left"><span id="red_color1">01 장바구니 > </span>02 주문서작성/결제 > 03 주문완료</span>
 </div>

  <table>
    <tr>
      <th class="notice_check"><input type="checkbox" id="check_all"></th>
      <th class="notice_title">상품/옵션 정보</th>
      <th class="notice">수량</th>
      <th class="notice">상품금액</th>
      <th class="notice">할인/적립</th>
      <th class="notice">합계금액</th>
      <th class="notice">배송일정</th>
    </tr>
 <form  method="post" name="checkbox01">
<?php 


//장바구니 총합계 구하는 함수
function sum_price($cart){
    $price = 0;
 include "../db/dbcon.php";
    if(is_array($cart)){
        foreach($cart as $isbn =>$qty){
            $sql = "select price from books where isbn =$isbn";
   $result = mysql_query($sql,$connect);
            if($result){
                $item=mysql_fetch_object($result);
    $item_price=$item->price;
                $price +=$item_price*$qty;
    
            }
        }
    }
    return $price;
}

//장바구니 총수량을 구하는 함수
function sum_items($cart){
    $items = 0;
    if(is_array($cart)){
        foreach($cart as $isbn =>$qty){
            $items +=$qty;
        }
    }
    return $items;
}

if(isset($_POST['new'])){ 
 $new = $_POST['new'];
    if($new){
        if(!isset($_SESSION['cart'])){
            //등록된 세션 변수가 없으면 세션변수를 등록
            $_SESSION['cart']= array(); //상품갯수
            $_SESSION['items'] = 0;
            $_SESSION['total_price']=0;

        }
        
        //장바구니에 똑같은 상품이 있는 경우
        if(isset($_SESSION['cart'][$new])){
            $_SESSION['cart'][$new]++;
        }else{ //장바구니에 새롭게 추가된 상품인 경우
            $_SESSION['cart'][$new] = 1;
        }
        //전체 상품 수량 합계 구하기
        $_SESSION['items'] = sum_items($_SESSION['cart']);
//echo  $_SESSION['items'];
//exit;
        // 장바구니 총합계 구하기        
        $_SESSION['total_price'] = sum_price($_SESSION['cart']);
        
    } // End if($new){

}//End if(isset($_GET['new'])){ 
//삭제했을때
$_SESSION['items'] = sum_items($_SESSION['cart']);
$_SESSION['total_price'] = sum_price($_SESSION['cart']);
// -----------------------------------------------------------------------------------------
//  현재 장바구니 페이지에서 refresh 버튼을 클릭했을 때 수량 및 총합계를 재계산
// -----------------------------------------------------------------------------------------
if(isset($_POST['refresh'])){
 $isbn = $_POST['isbn'];
    //foreach($_SESSION['cart'] as $isbn => $qty){
        if($_POST['refresh'] =='0'){
            unset($_SESSION['cart'][$isbn]);
        }else{
            $_SESSION['cart'][$isbn] = $_POST['refresh'];
        }
    //} // End of foreach문    
    
    // 총수량 재계산-----------------------   
      $_SESSION['items'] = sum_items($_SESSION['cart']);
    // 총합계 재계산-----------------------
     $_SESSION['total_price'] = sum_price($_SESSION['cart']); 
  }
///echo $_SESSION['items'];
//exit;

  //장바구니 버튼을 클릭했을 때 장바구니에 추가된 상품이 있는 경우에는 화면에 상품을 출력
  if(isset($_SESSION['cart']) && (array_count_values($_SESSION['cart']))){
foreach($_SESSION['cart'] as $isbn => $qty){
   $sql2="select * from books where isbn=$isbn";
   $result2=mysql_query($sql2,$connect);
   if($result2){
    $row=mysql_fetch_array($result2);
    
    $image_name = $row[file_name_0];
    $image_copied = $row[file_copied_0];
    $img_name = $image_copied;
    $img_name = "../data/".$img_name;

    $title = $row[title];
    $subtitle = $row[subtitle];
    $price = $row[price];
    $point = $row[point];
   }
   //echo print_r($_SESSION['cart']);
   ?>
 <tr>
    <td class="notice_check">
   
   <input type="checkbox" name="check[]" value="<?=$isbn?>">
   
   </td>
   <td class="notice_title"><a href="../side/sub06.php?isbn=<?=$isbn;?>"><img src="<?=$img_name; ?>" id="basket_img"></a>
   <div id="basket_img_name"><div id="deduction">소득공제</div><?=$title;?></div></td>
   <td class="notice">
   <input type="hidden" name="isbn" value="<?=$isbn;?>">
   <input type="text" name= "refresh" id="basket_input" style="margin-right:5px;" value="<?=$_SESSION['cart'][$isbn];?>"><button onclick="qty()">확인</button>
   </td>
   <td class="notice"><?=number_format($price);?></td>
   <td class="notice"><?=number_format($point*$qty);?></td>
   <td class="notice"><?=number_format($price*$qty);?>원</td>
   <td class="notice"><?=date("m월 d일",strtotime("+1 day"));?></td>
 </tr>
  <?php 
}
 }
 ?></form>
  </table>
  <?php
 
 if($_SESSION['items']==0){
    echo("<div id='NoProduct'>상품이 없습니다.</div>");
 }
  ?>
  <div id="result">
    총 <span id="red_color1"><?=$_SESSION['items'];?></span>개의 상품금액 <b><?=number_format($_SESSION['total_price']);?></b>원 <img src="/img/basket/pluse.JPG" id="result_img"> 배송비 <b>0</b>원 <img src="/img/basket/result.JPG" id="result_img"><span id="red_color1"><?=number_format($_SESSION['total_price']);?>원</span>
 </div>
  <button id="basket_delete" onclick="check01()">
  선택 상품 삭제
  </button>
  <div id="basket_buy">
 <? if($custom_id){?>
 <a href="ord.php">
 <?}else{?>
    <a href="../login/no_id.php">
  <?}?>
    <div id="basket_select_buy">
      선택 상품 주문
    </div>
  </a>
   <?php/*
    if(!$userid)
    echo "<a href='../login/no_id.php'>";
    else
    echo "<a href='ord.php'>";*/
   ?>
  <? if($custom_id){?>
 <a href="ord.php">
 <?}else{?>
    <a href="../login/no_id.php">
  <?}?>
    <div id="basket_full_buy">
      전체 상품 주문
    </div>
  </a>
    <div id="red_color">※ 주문서 작성단계에서 할인 및 적립금 적용을 하실 수 있습니다</div>
  </div>
</div>
    <? include "../lib/footer.php";?>
</body>
</html>

 

 

주문 페이지 구현 (order.php)

<?php
session_start();
header('Content-type:text/html; charset=utf-8');

$custom_id = $_SESSION['userid'];
include "../db/dbcon.php";

$sql="select * from customers where custom_id='{$custom_id}'";
$result = mysql_query($sql,$connect);
$row = mysql_fetch_array($result);

$name = $row[name];
$phone = $row[phone];
$email = $row[email];
$zipcode = $row[zipcode];
$address = explode(" ", $row[address]);
$address1 = $address[0];
$address2 = $address[1];
?>
<!DOCTYPE html>
<html>
 <head>
  <meta charset="utf-8">
  <title>새벽서점</title>
  <link href="/css/full.css" rel="stylesheet">
  <link href="/css/basket.css" rel="stylesheet">
  <link href="/css/ord.css" rel="stylesheet">
    <script src="https://ssl.daumcdn.net/dmaps/map_js_init/postcode.v2.js"></script>
    <script src="http://dmaps.daum.net/map_js_init/postcode.v2.js"></script>
    <script src="../join/daum.js"></script>
</head>
<body>
   <? include "../lib/top_menu.php";?>
<div id="main">
  <div id="join_main_top_basket">
  <div id="ord_title">
   주문상품확인
  </div>
  <span id="join_left">01 장바구니 > <span id="red_color1">02 주문서작성/결제 > </span>03 주문완료</span>
 </div>
    <table>
    <tr>
      <th class="notice_title">상품/옵션 정보</th>
      <th class="notice">수량</th>
      <th class="notice">상품금액</th>
      <th class="notice">할인/적립</th>
      <th class="notice">합계금액</th>
      <th class="notice">배송일정</th>
    </tr>
<?php
if(isset($_SESSION['cart']) && array_count_values($_SESSION['cart'])){
 foreach($_SESSION['cart'] as $isbn => $qty){
  $sql2="select * from books where isbn=$isbn";
  $result2=mysql_query($sql2,$connect);
   if($result2){
    $row=mysql_fetch_array($result2);
    
    $image_name = $row[file_name_0];
    $image_copied = $row[file_copied_0];
    $img_name = $image_copied;
    $img_name = "../data/".$img_name;

    $title = $row[title];
    $subtitle = $row[subtitle];
    $price = $row[price];
    $point = $row[point];
   }
   ?>

    <tr>
      <td class="notice_title"><a href="sub06.php?isbn=<?=$isbn;?>"><img src="<?=$img_name; ?>" id="basket_img"></a><div id="basket_img_name"><div id="deduction">소득공제</div>
<?=$title;?></div></td>
      <td class="notice"><?=$_SESSION['cart'][$isbn];?></td>
      <td class="notice"><?=number_format($price);?></td>
      <td class="notice"><?=number_format($point*$qty);?></td>
      <td class="notice"><?=number_format($price*$qty);?>원</td>
      <td class="notice"><?=date("m월 d일",strtotime("+1 day"));?></td>
    </tr>
  
  <?php
 }
}?>         
</table>
<?php
if($_SESSION['items']==0){
    echo("<div id='NoProduct'>주문하실 상품이 없습니다.</div>");
}
?>
<form method="post" action="../db/ord_insert.php">
 <!-구매정보-->
 <div id="OrdBox">
 <div id="join_top_basket">
  <div id="ord_title">
   구매자정보
  </div>
 </div>
  <div id="join_box">
  <div id="join_box_mini">
   이름
  </div>
  <div id="join_box_mini">
   <input type="text" id="join_input" name="name" value="<?=$name?>">
  </div>
 </div>
 <div id="join_box">
  <div id="join_box_mini">
   연락처
  </div>
  <div id="join_box_mini">
   <input type="text" id="join_input" placeholder="-없이 입력해 주세요" name="phone_number" value="<?=$phone?>">
  </div>
 </div>
  <div id="join_box">
  <div id="join_box_mini">
   이메일
  </div>
  <div id="join_box_mini">
   <input type="text" id="join_input" name="email" value="<?=$email?>">
  </div>
 </div>
 <div id="join_box">
  <div id="join_box_mini">
   주문비밀번호
  </div>
  <div id="join_box_mini">
   <input type="password" id="join_input" name="custome_password">
  </div>
 </div>
 </div>
 <div id="OrdBox">
 <div id="join_top_basket">
  <div id="ord_title">
   배송지 정보 지정
  </div>
 </div>
 <div id="join_box">
  <div id="join_box_mini">
   이름
  </div>
  <div id="join_box_mini">
   <input type="text" id="join_input" name="ship_name" value="<?=$name?>">
  </div>
 </div>
 <div id="join_box">
  <div id="join_box_mini">
   연락처
  </div>
  <div id="join_box_mini">
   <input type="text" id="join_input" placeholder="-없이 입력해 주세요" name="ship_number" value="<?=$phone?>">
  </div>
 </div>
 <div id="join_box">
  <div id="join_box_mini">
   주소
 </div>
 <div id="ord_box_mini">
   <input type="text" id="address" name="zipcode" placeholder="우편번호" value="<?=$zipcode?>">
      &nbsp;<input type="button" id="address_button" value="우편번호 검색" onclick="sample4_execDaumPostcode()" name="ship_address1"><br><br>
      <input type="text" id="address_input" name="ship_address2"  id="sample4_roadAddress" placeholder="도로명주소" value="<?=$address1?>">
      <input type="text" id="address_input" name="ship_address3"  id="sample6_address2"  placeholder="상세주소" value="<?=$address2?>">
 </div>
 </div>
 </div>
  <div id="result">
    총 <span id="red_color1"><?=$_SESSION['items'];?></span>개의 상품금액 <b><?=number_format($_SESSION['total_price']);?></b>원 <img src="/img/basket/pluse.JPG" id="result_img"> 배송비 <b>0</b>원 <img src="/img/basket/result.JPG" id="result_img"><span id="red_color1"><?=number_format($_SESSION['total_price']);?>원</span>
  </div>
  <div id="basket_buy">
    <button type="submit" id="basket_select_buy">
      결제하기
    </button>
  <a href="basket.php">
    <div id="basket_full_buy">
      이전페이지
    </div>
  </a>
  </div> 
  </form>
</div>
    <? include "../lib/footer.php";?>
 </body>
</html>

 

 

주문 완료 페이지 구현 (order_insert.php)

<?php
 session_start();
 header('Content-type:text/html; charset=utf-8');
 include "dbcon.php";

 $custom_id = $_SESSION['userid'];
 $name = $_POST['name'];
 $phone_number = $_POST['phone_number'];
 $email = $_POST['email'];
 $custom_password = $_POST['custom_password'];
 $ship_name = $_POST['ship_name'];
 $ship_number = $_POST['ship_number'];
 $address1 = $_POST['ship_address1'];
 $address2 = $_POST['ship_address2'];
 $address3 = $_POST['ship_address3'];
 
 $address = $address1." ".$address2." ".$address3;
 $order_id = date("YmdHis");
 $date=date("Y.m.d");
 $amount = $_SESSION['items'];
 $price = $_SESSION['total_price'];
 //$sql="select * form customers where id ='{$custom_id}'"; //왜 썼지?
 //echo $sql;
 //exit;
 //$result=mysql_query($sql,$connect);
 foreach($_SESSION['cart'] as $isbn => $qty){
  $sql2="select * from books where isbn=$isbn";
  $result2=mysql_query($sql2,$connect);
  $row = mysql_fetch_array($result2);
  $title = $row[title];
 }
 
 $sql="insert into orders(order_id,custom_id, custom_phone, email, amount, date, customer_name, ship_name, ship_address, ship_number,total_price,title)";
 $sql.="values('$order_id','$custom_id', '$phone_number','$email','$amount', '$date', '$name', '$ship_name', '$address', '$ship_number','$price','$title')";
  //echo $sql;
  //exit;
 mysql_query($sql,$connect);

 mysql_close();
 unset($_SESSION['cart']);
 unset($_SESSION['total_price']);
 unset($_SESSION['items']);
 echo ("
  <script>
      window.alert('주문번호:{$order_id}')
   location.href='/index.php';
  </script>
 ");
?>

 

 

너무 오래되서... 코드만 덜렁 있는게 좀... 머쓱

프로젝트 전체 코드는 제 깃허브에 있습니당

'학교' 카테고리의 다른 글

[2021-2] 운영체제 프로젝트  (0) 2022.01.13
[2019-2] 프로그래밍실습II 빙고게임 과제  (0) 2022.01.06
[2019-2] 프로그래밍실습II 로또번호 생성 프로그램 과제  (0) 2022.01.06
[2019-2] 디지털신호처리 새 소리 만들기 과제  (0) 2022.01.06
[2019-2] 디지털신호처리 첩 신호 만들기 과제  (0) 2022.01.06
profile

Devlog

@덩이

포스팅이 좋았다면 "좋아요❤️" 또는 "구독👍🏻" 해주세요!

검색 태그

티스토리툴바