Usar script php

[Lain0x]

Hola, tengo una duda, me gustaría probar este script, pero aún no entiendo muy bien como hacerlo.

Primero se explica lo de crear la base de datos, esta parte la entiendo:

Código:

Table structure for table 'inventory' 
# 
CREATE TABLE inventory ( 
product tinytext NOT NULL, 
quantity tinytext NOT NULL, 
id int(4) DEFAULT '0' NOT NULL auto_increment, 
description tinytext NOT NULL, 
price float(10,2) DEFAULT '0.00' NOT NULL, 
category char(1) DEFAULT '' NOT NULL, 
KEY id (id), 
PRIMARY KEY (id), 
KEY price (price) 
); 

# 
# Table structure for table 'shopping' 
# 
CREATE TABLE shopping ( 
session tinytext NOT NULL, 
product tinytext NOT NULL, 
quantity tinytext NOT NULL, 
card tinytext NOT NULL, 
id int(4) DEFAULT '0' NOT NULL auto_increment, 
KEY id (id), 
PRIMARY KEY (id) 
);

Después aparece el código en php:

Código:

<? 
/* shoppingcart.php 
* 
* 
*/ 

if(!$session && !$scid) { 
$session = md5(uniqid(rand())); 
SetCookie("scid", "$session", time() + 14400); 
} /* last number is expiration time in seconds, 14400 sec = 4 hrs */ 

class Cart { 
function check_item($table, $session, $product) { 
$query = "SELECT * FROM $table WHERE session='$session' AND product='$product' "; 
$result = mysql_query($query); 

if(!$result) { 
return 0; 
} 

$numRows = mysql_num_rows($result); 

if($numRows == 0) { 
return 0; 
} else { 
$row = mysql_fetch_object($result); 
return $row->quantity; 
} 
} 

function add_item($table, $session, $product, $quantity) { 
$qty = $this->check_item($table, $session, $product); 
if($qty == 0) { 
$query = "INSERT INTO $table (session, product, quantity) VALUES "; 
$query .= "('$session', '$product', '$quantity') "; 
mysql_query($query); 
} else { 
$quantity += $qty; 
$query = "UPDATE $table SET quantity='$quantity' WHERE session='$session' AND "; 
$query .= "product='$product' "; 
mysql_query($query); 
} 
} 

function delete_item($table, $session, $product) { 
$query = "DELETE FROM $table WHERE session='$session' AND product='$product' "; 
mysql_query($query); 
} 

function modify_quantity($table, $session, $product, $quantity) { 
$query = "UPDATE $table SET quantity='$quantity' WHERE session='$session' "; 
$query .= "AND product='$product' "; 
mysql_query($query); 
} 

function clear_cart($table, $session) { 
$query = "DELETE FROM $table WHERE session='$session' "; 
mysql_query($query); 
} 

function cart_total($table, $session) { 
$query = "SELECT * FROM $table WHERE session='$session' "; 
$result = mysql_query($query); 
if(mysql_num_rows($result) > 0) { 
while($row = mysql_fetch_object($result)) { 
$query = "SELECT price FROM inventory WHERE product='$row->product' "; 
$invResult = mysql_query($query); 
$row_price = mysql_fetch_object($invResult); 
$total += ($row_price->price * $row->quantity); 
} 
} 
return $total; 
} 

function display_contents($table, $session) { 
$count = 0; 
$query = "SELECT * FROM $table WHERE session='$session' ORDER BY id "; 
$result = mysql_query($query); 
while($row = mysql_fetch_object($result)) { 
$query = "SELECT * FROM inventory WHERE product='$row->product' "; 
$result_inv = mysql_query($query); 
$row_inventory = mysql_fetch_object($result_inv); 
$contents["product"][$count] = $row_inventory->product; 
$contents["price"][$count] = $row_inventory->price; 
$contents["quantity"][$count] = $row->quantity; 
$contents["total"][$count] = ($row_inventory->price * $row->quantity); 
$contents["description"][$count] = $row_inventory->description; 
$count++; 
} 
$total = $this->cart_total($table, $session); 
$contents["final"] = $total; 
return $contents; 
} 

function num_items($table, $session) { 
$query = "SELECT * FROM $table WHERE session='$session' "; 
$result = mysql_query($query); 
$num_rows = mysql_num_rows($result); 
return $num_rows; 
} 

function quant_items($table, $session) { 
$quant = 0; 
$query = "SELECT * FROM $table WHERE session='$session' "; 
$result = mysql_query($query); 
while($row = mysql_fetch_object($result)) { 
$quant += $row->quantity; 
} 
return $quant; 
} 
} 
?>

Y más abajo dice esto:

Ejemplo:

Código:

<? 
include("shoppingcart.php"); 
$cart = new Cart; 
$mysql_link = mysql_connect("localhost", "wwwrun", ""); 
$mysql_select_db("kmartShopper", $mysql_link) /* heh, use whatever database name you put the 2 tables under in place of kmartShopper */ 
?>

Que debo hacer con eso del ejemplo? agregarlo al código php??? Y después sólo ejecutarlo en dreamweaver?