How to Implement a PHP Shopping Cart with MySQL using Session Variables to Store the Cart Items Using the Package Simple PHP Shopping Cart: Manage a shopping cart stored in database

Recommend this page to a friend!

Download .zip

Info

Example

Screenshots

View files (7)

Download .zip

Reputation

Support forum

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2024-06-22 (Yesterday)		Not yet rated by the users				Total: Not yet counted		Not yet ranked

Version		License		PHP version		Categories
`simple-php-shopping-` 1.0		The PHP License		5		PHP 5, Databases, E-Commerce, Global

Description

Author

Adeleye Ayodeji

This package can manage a shopping cart stored in a database.

It provides a PHP script that implements operations to manage the items of a shopping cart using PHP sessions to store the shopping cart items and a MySQL database to store the list of available products.

Currently, it can:

- Add an item with a given quantity of products to the shopping cart

- Remove items from the shopping cart

- Empty the shopping cart

- List the products in the shopping cart

- List the products available for sale

Adeleye Ayodeji

Performance

Level

Name:	Adeleye Ayodeji `<contact>`
Classes:	20 packages by Adeleye Ayodeji
Country:	Nigeria

Level 1

Innovation award

Nominee: 13x

Example


<?php


session_start();


require_once("dbcontroller.php");


$db_handle = new DBController();


if(!empty($_GET["action"])) {


switch($_GET["action"]) {


    case "add":


        if(!empty($_POST["quantity"])) {


            $productByCode = $db_handle->runQuery("SELECT * FROM tblproduct WHERE code='" . $_GET["code"] . "'");


            $itemArray = array($productByCode[0]["code"]=>array('name'=>$productByCode[0]["name"], 'code'=>$productByCode[0]["code"], 'quantity'=>$_POST["quantity"], 'price'=>$productByCode[0]["price"], 'image'=>$productByCode[0]["image"]));


            


            if(!empty($_SESSION["cart_item"])) {


                if(in_array($productByCode[0]["code"],array_keys($_SESSION["cart_item"]))) {


                    foreach($_SESSION["cart_item"] as $k => $v) {


                            if($productByCode[0]["code"] == $k) {


                                if(empty($_SESSION["cart_item"][$k]["quantity"])) {


                                    $_SESSION["cart_item"][$k]["quantity"] = 0;


                                }


                                $_SESSION["cart_item"][$k]["quantity"] += $_POST["quantity"];


                            }


                    }


                } else {


                    $_SESSION["cart_item"] = array_merge($_SESSION["cart_item"],$itemArray);


                }


            } else {


                $_SESSION["cart_item"] = $itemArray;


            }


        }


    break;


    case "remove":


        if(!empty($_SESSION["cart_item"])) {


            foreach($_SESSION["cart_item"] as $k => $v) {


                    if($_GET["code"] == $k)


                        unset($_SESSION["cart_item"][$k]);                


                    if(empty($_SESSION["cart_item"]))


                        unset($_SESSION["cart_item"]);


            }


        }


    break;


    case "empty":


        unset($_SESSION["cart_item"]);


    break;    


}


}


?>


<HTML>


<HEAD>


<TITLE>Simple PHP Shopping Cart</TITLE>


<link href="style.css" type="text/css" rel="stylesheet" />


</HEAD>


<BODY>


<div id="shopping-cart">


<div class="txt-heading">Shopping Cart</div>





<a id="btnEmpty" href="index.php?action=empty">Empty Cart</a>


<?php


if(isset($_SESSION["cart_item"])){


    $total_quantity = 0;


    $total_price = 0;


?>    


<table class="tbl-cart" cellpadding="10" cellspacing="1">


<tbody>


<tr>


<th style="text-align:left;">Name</th>


<th style="text-align:left;">Code</th>


<th style="text-align:right;" width="5%">Quantity</th>


<th style="text-align:right;" width="10%">Unit Price</th>


<th style="text-align:right;" width="10%">Price</th>


<th style="text-align:center;" width="5%">Remove</th>


</tr>    


<?php        


    foreach ($_SESSION["cart_item"] as $item){


        $item_price = $item["quantity"]*$item["price"];


        ?>


                <tr>


                <td><img src="<?php echo $item["image"]; ?>" class="cart-item-image" /><?php echo $item["name"]; ?></td>


                <td><?php echo $item["code"]; ?></td>


                <td style="text-align:right;"><?php echo $item["quantity"]; ?></td>


                <td  style="text-align:right;"><?php echo "$ ".$item["price"]; ?></td>


                <td  style="text-align:right;"><?php echo "$ ". number_format($item_price,2); ?></td>


                <td style="text-align:center;"><a href="index.php?action=remove&code=<?php echo $item["code"]; ?>" class="btnRemoveAction"><img src="icon-delete.png" alt="Remove Item" /></a></td>


                </tr>


                <?php


                $total_quantity += $item["quantity"];


                $total_price += ($item["price"]*$item["quantity"]);


        }


        ?>





<tr>


<td colspan="2" align="right">Total:</td>


<td align="right"><?php echo $total_quantity; ?></td>


<td align="right" colspan="2"><strong><?php echo "$ ".number_format($total_price, 2); ?></strong></td>


<td></td>


</tr>


</tbody>


</table>        


  <?php


} else {


?>


<div class="no-records">Your Cart is Empty</div>


<?php 


}


?>


</div>





<div id="product-grid">


    <div class="txt-heading">Products</div>


    <?php


    $product_array = $db_handle->runQuery("SELECT * FROM tblproduct ORDER BY id ASC");


    if (!empty($product_array)) { 


        foreach($product_array as $key=>$value){


    ?>


        <div class="product-item">


            <form method="post" action="index.php?action=add&code=<?php echo $product_array[$key]["code"]; ?>">


            <div class="product-image"><img src="<?php echo $product_array[$key]["image"]; ?>"></div>


            <div class="product-tile-footer">


            <div class="product-title"><?php echo $product_array[$key]["name"]; ?></div>


            <div class="product-price"><?php echo "$".$product_array[$key]["price"]; ?></div>


            <div class="cart-action"><input type="text" class="product-quantity" name="quantity" value="1" size="2" /><input type="submit" value="Add to Cart" class="btnAddAction" /></div>


            </div>


            </form>


        </div>


    <?php


        }


    }


    ?>


</div>


</BODY>


</HTML>

Details

simple-php-shopping-cart

Simple PHP Shopping Cart

Screenshots

Files

File	Role	Description
`dbcontroller.php`	Class	Class source
`icon-delete.png`	Icon	Icon image
`index.php`	Example	Example script
`LICENSE`	Lic.	License text
`README.md`	Doc.	Documentation
`style.css`	Data	Auxiliary data
`tblproduct.sql`	Data	Auxiliary data