My Little Scripts - item-shopping-cart.php

Scripts.com - Get the best scripts NOW!
HotScripts.com - Over 10 web rings.
more links...

ITEM-SHOPPING-CART.PHP

Item shopping cart is a database driven PayPal cart. It was written to be easily modified and integrated into an existing e-commerce site. It allows people to shop on your web site, and allows you to keep track of the details of their purchases.

<?
include("db.php");

mysql_connect($db_host, $db_user, $db_password);

mysql_select_db($db_name);

$transaction_id = $HTTP_POST_VARS["transaction_id"];

if($transaction_id == "0")
  {
  $insert = "insert into transactions (date) values (CURDATE())";
  mysql_query($insert);

  $transaction_id = mysql_insert_id();
  $onload = "onload=\"document.cart.submit();\"";
  }

$select = "select id from items order by ordre";
$ids = mysql_query($select);
while(($id = mysql_fetch_assoc($ids)) && $transaction_id != "")
     {
     $item_id = $HTTP_POST_VARS["item_id_" . $id["id"]];

     if($item_id == 'on')
       {
       $order_quantity = $HTTP_POST_VARS["order_quantity_" . $id["id"]];
       if($order_quantity == "")
          $order_quantity = 1;

       //Forces a change in the row, otherwise mysql_affected_rows() will
       //return a 0, when no changes are made.
       $update = "update orders set " .
                 " quantity = 0" .
                 " where item_id = " . $id["id"] . " and transaction_id = " . $transaction_id;
       mysql_query($update);

       $update = "update orders set " .
                 " quantity = " . $order_quantity .
                 " where item_id = " . $id["id"] . " and transaction_id = " . $transaction_id;
       mysql_query($update);

       if(mysql_affected_rows() == 0)
         {
         $insert = "insert into orders (item_id, transaction_id, quantity) values (" .
                   $id["id"] . ", " . $transaction_id . ", " . $order_quantity . ")";
         mysql_query($insert);
         }
       }
     else
       {
       $delete = "delete from orders " .
                 "where item_id = " . $id["id"] . " and transaction_id = " . $transaction_id;
       mysql_query($delete);
       }
     }
?>
<html>

<head>
<title>item shopping cart</title>

<script>
function transact()
         {
         transaction_id = '<?= $transaction_id ?>';

         if(transaction_id == '')
            transaction_id = '0';

         document.cart.transaction_id.value = transaction_id;
         }
</script>
</head>

<body <?= $onload ?>>
<form method="post" name="cart">

<input type="hidden" name="transaction_id" value="<?= $transaction_id ?>" />

<table align="center">

<?
$select = "select items.id, name, price, summary, thumbnail, quantity " .
          "from (items left outer join orders on items.id = orders.item_id and transaction_id = ";

if($transaction_id == "")
   $select .= 0;
else
   $select .= $transaction_id;

$select .= ") order by ordre";

$items = mysql_query($select);

while($item = mysql_fetch_assoc($items)) {

$item_id = $item["id"];
$item_name = $item["name"];
$item_price = $item["price"];
$item_summary = $item["summary"];
$item_thumbnail = $item["thumbnail"];
$item_ordre = $item["ordre"];
$order_quantity = $item["quantity"];

if(is_dir("images/") == false)
   mkdir("images/", 0755);

$thumbnail_file = "images/item_" . $item_id . "_thumbnail.jpg";
if($item_thumbnail != "")
  {
  $thumbnail_file_handle = fopen("./" . $thumbnail_file, "wb");
  fwrite($thumbnail_file_handle, $item_thumbnail, strlen($item_thumbnail));
  chmod("./" . $thumbnail_file, 0644);
  }

$image_file = "images/item_" . $item_id . "_image.jpg";
if($item_image != "")
  {
  $image_file_handle = fopen("./" . $image_file, "wb");
  fwrite($image_file_handle, $item_image, strlen($item_image));
  chmod("./" . $image_file, 0644);
  }
?>



<tr>
<td valign="top">
    <table>
    <tr>
    <td><b><?= $item_name ?></b></td>
    </tr>

    <tr>
    <td><?= $item_price ?></td>
    </tr>

    <tr>
    <td><?= $item_summary  ?></td>
    </tr>

    <tr>
    <td>order: <input type="checkbox" name="item_id_<?= $item_id ?>"
                      <? if($order_quantity != "") { ?>checked<? } ?>
                      onchange="transact();" /></td>
    </tr>

    <tr>
    <td>quantity: <input type="text" name="order_quantity_<?= $item_id ?>" size="3"
                         value="<?= $order_quantity ?>"
                         onchange="transact();" /></td>
    </tr>
    </table>
</td>

<td align="right" valign="top" nowrap>
<? if($item_thumbnail != "") { ?>
<img name="thumbnail_file_<?= $item_id ?>" src="<?= $thumbnail_file ?>" />
<? } ?>
</td>
</tr>

<? } ?>

<tr>
<td><input type="submit" value="purchase"></td>

<? if($transaction_id != "")  { ?>

<?
$select = "select price, quantity from items, orders " .
          "where items.id = orders.item_id and transaction_id = " . $transaction_id;
$sub_totals = mysql_query($select);

$total = 0;
//calculate total payment.
while($sub_total = mysql_fetch_assoc($sub_totals))
     {
     $total += $sub_total["price"] * $sub_total["quantity"];
     }

$product = "product-id" . $transaction_id;

$business_email = "sales@bambookit.com";

$paypal = "https://www.paypal.com/cgi-bin/webscr/?business=" . $business_email .
          "&item_name=" . $product .
          "&item_number=" . $product .
          "&currency_code=USD&amount=" . $total .
          "&cmd=_xclick&no_note=1";
?>

<td>
<? if($total > 0) { ?>
$<?= $total ?>&nbsp;&nbsp;
<a href="<?= $paypal ?>">PayPal</a>
<? } ?>
</td>

<? } ?>
</tr>
</table>
</form>
</body>
</html>

create table items
(
id int primary key AUTO_INCREMENT,
name varchar(255),
price decimal(6,2),
summary tinytext,
description text,
thumbnail blob,
image blob,
ordre int
);

create table orders
(
id int primary key AUTO_INCREMENT,
item_id int,
transaction_id int,
quantity int
);

create table transactions
(
id int primary key AUTO_INCREMENT,
date date
);