PHP - Book Help. Want To Make A Shopping Cart With All The Trimmings Any Suggestions

I know there are many open source shopping carts available, but I wanted to write my own to gain a better understanding of the coding practices involved. Below is my almost finished shopping cart class for an e-commerce website I am building. I want to be able to handle all purchasing capability from the Cart class as you can see from what I have below. I was wondering if anyone can see any areas for improvement before I go implementing it into my website. Any help is appreciated and thank you in advance.

Code: [Select]
<?php

/**
 * Cart class handles all shopping cart activity.
 * 
 * This class also handles saving order information for each purchase.
 * 
 * After each order is complete be sure to call the Product::inventoryCheck() 
 * to notify administrator of low quantities.
 */
 
class Cart
{
public $db;
private $_cartName;

/**
 * Creates a new shopping cart if one does not exist already.
 * Initiates the database connection for future use.
 */
public function __construct($cartName = 'cart') {
$this->_cartName = $cartName;
if (!isset($_SESSION[$this->_cartName])) {
$_SESSION[$this->_cartName];
}
$this->db = Database::getInstance();
}

/**
 * Returns all items in the shopping cart and their information.
 * I want to be able to return the quantity as well.
 * I will take this information and use it to display the shopping cart to the customer.
 */
public function getCartItems() {
try {
foreach ($_SESSION[$this->_cartName][$id] as $productId => $quantity) {
$stmt = $this->db->prepare(
"SELECT 
product_id, 
product_name, 
product_thumb, 
product_price, 
product_discount
FROM product 
WHERE product_id = ?");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute(array($productId));
return array($stmt->fetchAll(), $quantity);
}
} catch (Exception $e) {
return FALSE;
}
}

/**
 * Adds an item to the shopping cart.
 * Also used to change quantities of items already in shopping cart.
 * @param $id - integer
 * @param $quantity - integer ($quantity comes from a drop down menu populated by the database)
 */
public function addItem($id, $quantity) {
try {
$_SESSION[$this->_cartName][$id] = $quantity;
} catch (Exception $e) {
return FALSE;
}
}

/**
 * Deletes an item from the shopping cart.
 * @param $id - integer
 */
public function deleteItem($id) {
try {
unset($_SESSION[$this->_cartName][$id]);
} catch (Exception $e) {
return FALSE;
}
}
 
  /**
 * Empties all contents out of the shopping cart.
 * Call this function when all purchase activity is complete so the user has a new cart to start with.
 */
public function clearCart() {
try {
unset($_SESSION[$this->_cartName]);
} catch (Exception $e) {
return FALSE;
}
}

/**
 * Saves a purchase after it is successful.
 * @param $subTotal - integer
 * @param $tax - integer
 * @param $discount - integer
 * @param $total - integer
 */
public function savePurchase($subTotal, $tax, $discount, $total) {
try {
$stmt = $this->db->prepare(
"INSERT INTO purchase
(purchase_customer_id, 
purchase_timestamp, 
purchase_ip, 
purchase_subtotal, 
purchase_tax, 
purchase_discount, 
purchase_total, 
purchase_status)
VALUES 
(?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($_SESSION['customer_id'], NOW(), $_SERVER['REMOTE_ADDR'], $subTotal, 
$tax, $discount, $total));
return $purchaseId;
} catch (Exception $e) {
return FALSE;
}
}

/**
 * Saves each item from a purchase.
 * Updates product quantities in product table.
 * @param $purchaseId - integer
 */
public function saveCartItems($purchaseId) {
try {
foreach ($_SESSION[$this->_cartName][$id] as $productId => $quantity) {
$stmt = $this->db->prepare(
"INSERT INTO purchase_item
(purchase_item_product_id, 
purchase_item_purchase_id, 
purchase_item_quantity)
VALUES 
(?, ?)");
$stmt->execute(array($productId, $purchaseId, $quantity));
$update = $this->db->prepare(
"UPDATE product
SET product_quantity = product_quantity - $quantity
WHERE product_id = ?");
$update->execute(array($productId));
}
} catch (Exception $e) {
return FALSE;
}
}

/**
 * Calculates shipping cost and applies it to the shopping cart.
 */
public function shipping() {
// need to find out pricing structure
}

/**
 * Applies a coupon discount if coupon parameters are met
 * Checks for coupon code validity from the coupon table
 * @param $couponCode - varchar
 */
public function useCoupon($couponCode, $cartPrice) {
try {
$stmt = $this->db->prepare(
"SELECT coupon_amount, coupon_minimum_price
FROM coupon
WHERE coupon_code = ? AND coupon_active = 'Yes'");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute(array($couponCode));
$stmt->fetch();
// make sure there is a coupon available that matches customer input
if (count($stmt) != 1) {
return FALSE;
}
// chcek if the current cart price (minus taxes and shipping) is greater than coupon minimum price
if ($cartPrice < $stmt['coupon_minimum_price']) {
return FALSE;
}
// this will go in the coupon field in the cart view
return $stmt['coupon_amount'];
} catch (Exception $e) {
return FALSE;
}
}

}

Hey again,

Still on the same project but now doing the cart page.  I've been bringing my skills up to date a lot doing this project, however, having said that I now can't figure out why my cart is not adding the items to the cart, i've checked the post data and the quantity is set to 1.  Would really appreciate someone having a look at it and hopefully can see what i'm missing.

you can see what it should look like (well so far lol) at here in my sandbox site.

thanks again.

(p.s. The parts are all over the place on the page, so thought better put whole page, sorry if shouldn't have done that)

<?php
// Initialize the session
session_start();

// Include config file

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 products WHERE product_code='" . $_GET["product_code"] . "'");
			$itemArray = array($productByCode[0]["product_code"]=>array('product_name'=>$productByCode[0]["product_name"], 'product_code'=>$productByCode[0]["product_code"], 'quantity'=>$_POST["quantity"], 'price'=>$productByCode[0]["price"], 'image'=>$productByCode[0]["img1"]));

			if(!empty($_SESSION["cart_item"])) {
				if(in_array($productByCode[0]["product_code"],array_keys($_SESSION["cart_item"]))) {
					foreach($_SESSION["cart_item"] as $k => $v) {
							if($productByCode[0]["product_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["product_code"] == $k)
						unset($_SESSION["cart_item"][$k]);
					if(empty($_SESSION["cart_item"]))
						unset($_SESSION["cart_item"]);
			}
		}
	break;
	case "empty":
		unset($_SESSION["cart_item"]);
	break;
}
}

?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>LeaversHoodies.ie</title>
    <!-- Bootstrap -->
    <link href="css/bootstrap-4.4.1.css" rel="stylesheet">
    <link href="css/accordian.css" rel="stylesheet">

  </head>
  <body>
    <?php include 'header_student.php'; ?>
<br />

<?php
$school_page = "ravenswell";

$sql = "SELECT * FROM schools WHERE school_page = '$school_page'";
if($result = mysqli_query($conn, $sql))
while($row = mysqli_fetch_array($result))

{
?>
     <h3 class="text-center">Student Ordering Page For</h3>
     <h2 class="text-center" style="text-transform:uppercase;"><?php echo $row['school_name']; ?></h2>

    <hr style="width: 50%; text-align:center; border: 2px solid #00aeef; border-radius: 5px; margin: 0 auto;">
<br />
    <div class="container">
      <div class="row">
        <div class="col">
        <?php $path = "images/schools/";
        $file = $row["logo"];

        if(!empty($row['logo'])) {
            echo '<img src="'.$path.$file.'" style="width:95%; height:auto; margin-top:-130px;"><br /><br />';
            } else {
            echo '<img src="images/schools/140x140.gif" style="width:95%; height:auto; margin-top:-130px;"><br /><br />';
        } ?></div>
        <div class="col-6">
<h5>These are the garments your school has choosen :</h5><br />
        <?php $school_id = $row["school_id"];
}
var_dump($_SESSION);
var_dump($_POST);
$product_array = $db_handle->runQuery("SELECT * FROM choices INNER JOIN products USING (product_code) INNER JOIN colours USING (colour_id) WHERE school_id = '$school_id'");
	if (!empty($product_array)) {
		foreach($product_array as $key=>$value){

      ?>
          <div class="container">
          <div class="row">
          <div class="col-5" style="text-align:left;">
              <img src="images/products/<?php echo $product_array[$key]["img1"]; ?>" alt="<?php echo $product_array[$key]["product_code"]; ?>" style="position:relative; top:0; width:200px; display:block;">
          </div>
          <div class="col-7">
            <h5><?php echo $product_array[$key]["product_name"]; ?></h5><p> in <?php echo $product_array[$key]["colour_name"]; ?></p>
            <p style="font-size:12px;"><?php echo $product_array[$key]["description"]; ?></p>

            <?php $comment = $product_array[$key]["comment"];
            if (empty($comment)) {
             echo "";
            } else { ?>
            <p style="font-size:12px;"><b>A note from your teacher:</b> <br />
            <?php echo $product_array[$key]["comment"]; ?></p>
            <?php }; ?>
                <form action="student_order.php?schoolname=<?php echo $school_page; ?>?action=add&product_code=<?php echo $product_array[$key]["product_code"]; ?>" method="post">
                <?php $product = $product_array[$key]["product_code"];  ?>
                    Please select your size :
                    <select id="size" name="size">
                      <?php
                      $sql1 = "SELECT DISTINCT * FROM sizes WHERE product_code = '$product'";
                      if($result1 = mysqli_query($conn, $sql1))
                      while($row3 = mysqli_fetch_array($result1)){
                            echo "<option value='" . $row3['size'] . "'>" . $row3['size'] . "</option>";
                        } else { echo "nothing to see here"; }
                      ?>
                    </select>
<br /><br />
                   <div class="number">How many do you want:
<input type="number" style="font-size:12px;" id="quantity" name="quantity" value="1" min="1" max="5"><br />
Price : <?php echo "€".$product_array[$key]["price"]; ?>
</div>
<input type="hidden" id="product_code" value="<?php echo $product; ?>"><br />
<input type="submit" style="font-size:12px;" value="Add to Order" class="btnAddAction">
                </form>

          </div>
          </div>
<br /><hr style="width: 90%; text-align:center; border: 1px solid #00aeef; border-radius: 5px; margin: 0 auto;"><br />
          </div>

<?php

          }
        } else {
          echo "No Schools by that name registered.";
        }

        ?>





</div>

<div class="col-3">
    <div style="border: 1px solid #d3d3d3; padding: 10px; border-radius: 5px; margin-top:30px;">
      Your Order:


    </div>

</div>
      </div>



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

<a id="btnEmpty" href="student_order.php?schoolname=<?php echo $school_page; ?>?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="images/products/<?php echo $item["img1"]; ?>" class="cart-item-image" /><?php echo $item["product_name"]; ?></td>
				<td><?php echo $item["product_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="student_order.php?schoolname=<?php echo $school_page; ?>?action=remove&product_code=<?php echo $item["product_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>


    <br /><br />

    <?php include 'footer_student.php'; ?>
    <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="js/jquery-3.4.1.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="js/popper.min.js"></script>
    <script src="js/bootstrap-4.4.1.js"></script>

  </body>
</html>

 

I'm not a programmer but can get buy a little with PHP. My need is a "Shopping Cart" and this is what I would like to see.   I have a MotoCMS web site and would like to but a shopping cart in one page all I need is a "Buy Now" button that can hold the "Item Name" "Price" and "Quantity" and Maybe a selectable option? And a "Cart" for my PayPal that I can put anywhere on the page. If I have to use a database that is OK. I can put the product pictures and info on the page and then a Buy Now link button would be great.   Does anyone know of a shopping cart that I can use to do this? Lon
Edited by Lon, 28 September 2014 - 09:07 PM.

I have followed a shopping cart tutorial from this website.

http://v3.thewatchmakerproject.com/journal/276/

1. When you refresh the page it adds another item to the cart.

2. I would like to add an image of the products from a folder and the link of the images in the database.

Can some one please help. Urgently!

Thanks.

Need some help on developing the steps below

I am working on a website money collection system that consist of stores affiliating to the website and sales their products in the website as independent stores. But I am not sure how to collect the percentage I will deduct per transaction for the stores. I have elaborated two plans but I don't know is those a good ideas in terms of bringing more store in to the website and have them comfortable by the way the website hold business with their stores owners.

1- I was thinking of collecting all the money of transactions into a single paypal account and then try to pay them weekly or in a monthly basis.
(I am not sure about this first option because I don't know whether the store owners will be thinking to much into it at the time of making a decision to register and to sell their products in the website. I guess they might think whether the website administrator will delivery the money every week, or if the website administrators are going to steal them etc. So this option I don't know if with some changes can be implemented.

2- The second option was to let each store administer each transaction with their credit/debit machine they have at the store and make the transaction right there and then on a monthly or weekly basis the website administrator charge them for the amount of transaction done during that time period in the website.


3- Third option is create a paypal account for each store and at the moment of the transaction to transfer the money to each store account and have the website paypal account deduct its percentage from the transaction and have the store owner paypal account deduct its part.

For healthy business purpose and website grow in terms of acquiring more stores into the website which of those three options would be the best option to choose or if there is another idea even better for business grow and comfortability among stores owner that you guys might have in mind share it.

Is selecting an option relevant to the grow of the website or it is?

co.ador