Simple PHP Mysql Shopping Cart

-
<?php  
 session_start(); 
 $connect = mysqli_connect("localhost", "root", "root", "test"); 
 if(isset($_POST["add_to_cart"])) 
 { 
      if(isset($_SESSION["shopping_cart"])) 
      { 
           $item_array_id = array_column($_SESSION["shopping_cart"], "item_id"); 
           if(!in_array($_GET["id"], $item_array_id)) 
           { 
                $count = count($_SESSION["shopping_cart"]); 
                $item_array = array( 
                     'item_id'               =>     $_GET["id"], 
                     'item_name'               =>     $_POST["hidden_name"], 
                     'item_price'          =>     $_POST["hidden_price"], 
                     'item_quantity'          =>     $_POST["quantity"] 
                ); 
                $_SESSION["shopping_cart"][$count] = $item_array; 
           } 
           else 
           { 
                echo '<script>alert("Item Already Added")</script>'; 
                echo '<script>window.location="cart.php"</script>'; 
           } 
      } 
      else 
      { 
           $item_array = array( 
                'item_id'               =>     $_GET["id"], 
                'item_name'               =>     $_POST["hidden_name"], 
                'item_price'          =>     $_POST["hidden_price"], 
                'item_quantity'          =>     $_POST["quantity"] 
           ); 
           $_SESSION["shopping_cart"][0] = $item_array; 
      } 
 } 
 if(isset($_GET["action"])) 
 { 
      if($_GET["action"] == "delete") 
      { 
           foreach($_SESSION["shopping_cart"] as $keys => $values) 
           { 
                if($values["item_id"] == $_GET["id"]) 
                { 
                     unset($_SESSION["shopping_cart"][$keys]); 
                     echo '<script>alert("Item Removed")</script>'; 
                     echo '<script>window.location="cart.php"</script>'; 
                } 
           } 
      } 
 } 
 ?> 
 <!DOCTYPE html> 
 <html> 
      <head> 
           <title>Webslesson Tutorial | Simple PHP Mysql Shopping Cart</title> 
           <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script> 
           <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" /> 
           <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script> 
      </head> 
      <body> 
           <br /> 
           <div class="container" style="width:700px;"> 
                <h3 align="center">Simple PHP Mysql Shopping Cart</h3><br /> 
                <?php 
                $query = "SELECT * FROM tbl_product ORDER BY id ASC"; 
                $result = mysqli_query($connect, $query); 
                if(mysqli_num_rows($result) > 0) 
                { 
                     while($row = mysqli_fetch_array($result)) 
                     { 
                ?> 
                <div class="col-md-4"> 
                     <form method="post" action="cart.php?action=add&id=<?php echo $row["id"]; ?>"> 
                          <div style="border:1px solid #333; background-color:#f1f1f1; border-radius:5px; padding:16px;" align="center"> 
                               <img src="<?php echo $row["image"]; ?>" class="img-responsive" /><br /> 
                               <h4 class="text-info"><?php echo $row["name"]; ?></h4> 
                               <h4 class="text-danger">$ <?php echo $row["price"]; ?></h4> 
                               <input type="text" name="quantity" class="form-control" value="1" /> 
                               <input type="hidden" name="hidden_name" value="<?php echo $row["name"]; ?>" /> 
                               <input type="hidden" name="hidden_price" value="<?php echo $row["price"]; ?>" /> 
                               <input type="submit" name="add_to_cart" style="margin-top:5px;" class="btn btn-success" value="Add to Cart" /> 
                          </div> 
                     </form> 
                </div> 
                <?php 
                     } 
                } 
                ?> 
                <div style="clear:both"></div> 
                <br /> 
                <h3>Order Details</h3> 
                <div class="table-responsive"> 
                     <table class="table table-bordered"> 
                          <tr> 
                               <th width="40%">Item Name</th> 
                               <th width="10%">Quantity</th> 
                               <th width="20%">Price</th> 
                               <th width="15%">Total</th> 
                               <th width="5%">Action</th> 
                          </tr> 
                          <?php  
                          if(!empty($_SESSION["shopping_cart"])) 
                          { 
                               $total = 0; 
                               foreach($_SESSION["shopping_cart"] as $keys => $values) 
                               { 
                          ?> 
                          <tr> 
                               <td><?php echo $values["item_name"]; ?></td> 
                               <td><?php echo $values["item_quantity"]; ?></td> 
                               <td>$ <?php echo $values["item_price"]; ?></td> 
                               <td>$ <?php echo number_format($values["item_quantity"] * $values["item_price"], 2); ?></td> 
                               <td><a href="index.php?action=delete&id=<?php echo $values["item_id"]; ?>"><span class="text-danger">Remove</span></a></td> 
                          </tr> 
                          <?php 
                                    $total = $total + ($values["item_quantity"] * $values["item_price"]); 
                               } 
                          ?> 
                          <tr> 
                               <td colspan="3" align="right">Total</td> 
                               <td align="right">$ <?php echo number_format($total, 2); ?></td> 
                               <td></td> 
                          </tr> 
                          <?php 
                          } 
                          ?> 
                     </table> 
                </div> 
           </div> 
           <br /> 
      </body> 
 </html>
  

Comments

  1. watsoon2 June 2020 at 04:17

    Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.
    HYIP Script

    ReplyDelete
  2. Akhil C20 September 2021 at 06:29

    I like your suggestions they are really helpful. Thank you so much for sharing this post.
    Offshore PHP Development in India

    ReplyDelete

Post a Comment

Popular posts from this blog

How to seperate character from string in php

-
?   1 2 3 4 5 6 7 8 9 $string = "abcdef" ; $result =[]; $strlen = strlen ( $string ); for ( $i =0; $i < $strlen ; $i ++) {      $result [ $i ]= $string [ $i ];   } print_r( $result );     $string = "abcdef"; $result=[]; $strlen = strlen($string); for($i=0;$i<$strlen;$i++) { $result[$i]=$string[$i]; } print_r($result);
Read more

How to Delete record using PHP Ajax

-
index.php ?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 <!DOCTYPE html> <html> <head>      <title></title> </head> <body>   <?php        $connection = mysqli_connect( "localhost" , "root" , "" , "db_2018" ) or die (mysqli_error());        $ReadSql = "SELECT * FROM `crud`" ;      $res = mysqli_query( $connection , $ReadSql );   ?>     <table>      <tr>          <th>name</th>          <th>Last Name</th>          <th>email id</th>          <th>gender</th>          <th>age</th>          <th>Action</th>      </tr>        <?php while ( $fetch = mysqli_fetch_array( $res )) {            extract( $fetch );         ?>
Read more

Uploads Only 10 files in month step by step

-
?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 <?php        $con = mysqli_connect( "localhost" , "root" , "" , "demo" );   date_default_timezone_set( 'Asia/Kolkata' );        $date = Date ( "Y-m-d" );                  if (isset( $_POST [ 'submit' ]))      {          extract( $_POST );            $name1 = $_FILES [ 'photo' ][ 'name' ];    $type = $_FILES [ 'photo' ][ 'type' ];    $size = $_FILES [ 'photo' ][ 'size' ];    $temp = $_FILES [ 'photo' ][ 'tmp_name' ];    if ( $name1 ){   $upload = "posts/" ;              $imgExt = strtolower ( pathinfo ( $name1 , PATHINFO_EXTENSION));              $valid_ext = array ( 'jpg' , 'png' , 'jpeg' );
Read more