shoppingcarts Database Table

Table: shoppingcarts

Tool: Store
Associated Objects: ShoppingCarts, ShoppingCart

Fields

member INT UNSIGNED NOT NULL DEFAULT 0 v5

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

product INT UNSIGNED NOT NULL DEFAULT 0 v5

added INT UNSIGNED NOT NULL v5

price DECIMAL(8,2) NOT NULL DEFAULT 0 v5

ip VARCHAR(20) NOT NULL v5

customvar VARCHAR(255) NOT NULL v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM shoppingcarts");
while ($resRow = $results->fetch_assoc())
{
 $member = $resRow["member"];  //
 $id = $resRow["id"];  //
 $product = $resRow["product"];  //
 $added = $resRow["added"];  //
 $price = $resRow["price"];  //
 $ip = $resRow["ip"];  //
 $customvar = $resRow["customvar"];  //
}

Other Store Tables

invoicecart invoiceitems invoices productreviews shoppingcarts

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us