Publicado em 6 de mar.

Carrinho de compras, opções tamanho e tipo.

Tenho um carrinho de compras que achei em um fórum, fiz ele tudo certinho mas eu queria saber como posso adicionar opções a eles, e como eu faria, criando tabela ou com sessions, e como eu poderia fazer obrigado.

opções:

tipo: rodio ou dourado

tamanho; tamanhos 12,14,16,18,20,22

Códigos.

Index.php

<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session

session_start();
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<title>www.phpdemos.com.br</title>
	<link rel="stylesheet" href="css/styles.css" />
</head>

<body>
<div id="shoppingcart">
<h1>Seu carrinho de compras</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Livros da loja</h1>

<?php
$sql = 'SELECT * FROM produto ORDER BY id LIMIT 0,3';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
	$output[] = '<li>'.$row['cod_dourado'].' R.$row['preco'].'<br /><a href="carrinho.php?action=add&id='.$row['id'].'10">Comprar</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>

</div>

</body>
</html>

mysql.class.php

<?php
/**
* MySQL Database Connection Class
* @access public
* @package SPLIB
*/
class MySQL {
/**
* MySQL server hostname
* @access private
* @var string
*/

 var $host;

 /**
 * MySQL username
 * @access private
 * @var string
 */
 var $dbUser;

 /**
 * MySQL user's password
 * @access private
 * @var string
 */
 var $dbPass;

 /**
 * Name of database to use
 * @access private
 * @var string
 */
 var $dbName;

 /**
 * MySQL Resource link identifier stored here
 * @access private
 * @var string
 */
 var $dbConn;

 /**
 * Stores error messages for connection errors
 * @access private
 * @var string
 */
 var $connectError;

 /**
 * MySQL constructor
 * @param string host (MySQL server hostname)
 * @param string dbUser (MySQL User Name)
 * @param string dbPass (MySQL User Password)
 * @param string dbName (Database to select)
 * @access public
 */
 function MySQL ($host,$dbUser,$dbPass,$dbName) {
 $this->host=$host;
 $this->dbUser=$dbUser;
 $this->dbPass=$dbPass;
 $this->dbName=$dbName;
 $this->connectToDb();
 }

 /**
 * Establishes connection to MySQL and selects a database
 * @return void
 * @access private
 */
 function connectToDb () {
 // Make connection to MySQL server
 if (!$this->dbConn = @mysql_connect($this->host,
 $this->dbUser,
 $this->dbPass)) {
 trigger_error('Could not connect to server');
 $this->connectError=true;
 // Select database
 } else if ( !@mysql_select_db($this->dbName,$this->dbConn) ) {
 trigger_error('Could not select database');
 $this->connectError=true;
 }
 }

 /**
 * Checks for MySQL errors
 * @return boolean
 * @access public
 */
 function isError () {
 if ( $this->connectError )
 return true;
 $error=mysql_error ($this->dbConn);
 if ( empty ($error) )
 return false;
 else
 return true;
 }

 /**
 * Returns an instance of MySQLResult to fetch rows with
 * @param $sql string the database query to run
 * @return MySQLResult
 * @access public
 */
 function query($sql) {
 if (!$queryResource=mysql_query($sql,$this->dbConn))
 trigger_error ('Query failed: '.mysql_error($this->dbConn).
 ' SQL: '.$sql);
 return new MySQLResult($this,$queryResource);
 }
}

/**
* MySQLResult Data Fetching Class
* @access public
* @package SPLIB
*/
class MySQLResult {
/**
* Instance of MySQL providing database connection
* @access private
* @var MySQL
*/

 var $mysql;

 /**
 * Query resource
 * @access private
 * @var resource
 */
 var $query;

 /**
 * MySQLResult constructor
 * @param object mysql (instance of MySQL class)
 * @param resource query (MySQL query resource)
 * @access public
 */
 function MySQLResult(& $mysql,$query) {
 $this->mysql=& $mysql;
 $this->query=$query;
 }

 /**
 * Fetches a row from the result
 * @return array
 * @access public
 */
 function fetch () {
 if ( $row=mysql_fetch_array($this->query,MYSQL_ASSOC) ) {
 return $row;
 } else if ( $this->size() > 0 ) {
 mysql_data_seek($this->query,0);
 return false;
 } else {
 return false;
 }
 }

 /**
 * Returns the number of rows selected
 * @return int
 * @access public
 */
 function size () {
 return mysql_num_rows($this->query);
 }

 /**
 * Returns the ID of the last row inserted
 * @return int
 * @access public
 */
 function insertID () {
 return mysql_insert_id($this->mysql->dbConn);
 }

 /**
 * Checks for MySQL errors
 * @return boolean
 * @access public
 */
 function isError () {
 return $this->mysql->isError();
 }
}
?>

global.inc.php

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$name = '2elementos3';
$db = &new MySQL($host,$user,$pass,$name);
?>

functions.inc.php

<?php
function writeShoppingCart() {
	$cart = $_SESSION['cart'];
	if (!$cart) {
 return '<p>Ainda não há itens no seu carrinho</p>';
	} else {
 // Parse the cart session variable
 $items = explode(',',$cart);
 $s = (count($items) > 1) ? 's':'';
 return '<p>Você tem <a href="carrinho.php">'.count($items).' item'.$s.' no seu carrinho</a></p>';
	}
}

function showCart() {
	global $db;
	$cart = $_SESSION['cart'];
	if ($cart) {
 $items = explode(',',$cart);
 $contents = array();
 foreach ($items as $item) {
 $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
 }
 $output[] = '<form action="carrinho.php?action=update" method="post" id="cart">';
 $output[] = '<table>';
 foreach ($contents as $id=>$qty) {
 $sql = 'SELECT * FROM produto WHERE id = '.$id;
 $result = $db->query($sql);
 $row = $result->fetch();
 extract($row);
 $output[] = '<tr>';
 $output[] = '<td><a href="carrinho.php?action=delete&id='.$id.'" class="r">Remover</a></td>';
 $output[] = '<td>'.$cod_dourado.''.$tamanho.'</td>';
 $output[] = '<td>R.$preco.'</td>';
 $output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
 $output[] = '<td>R.($preco * $qty).'</td>';
 $total += $preco * $qty;
 $output[] = '</tr>';
 }
 $output[] = '</table>';
 $output[] = '<p>Total: <strong>R.$total.'</strong></p>';
 $output[] = '<div><button type="submit">Atualizar carrinho</button></div>';
 $output[] = '</form>';
	} else {
 $output[] = '<p>Seu carrinho está vazio.</p>';
	}
	return join('',$output);
}
?>

carrinho.php

$cart = $_SESSION['cart'];
$action = $_GET['action'];

switch ($action) {
case 'add':

 if ($cart) {
 $cart .= ','.$_GET['id'];
 } else {
 $cart = $_GET['id'];
 }
 break;
	case 'delete':
 if ($cart) {
 $items = explode(',',$cart);
 $newcart = '';
 foreach ($items as $item) {
 if ($_GET['id'] != $item) {
 if ($newcart != '') {
 $newcart .= ','.$item;
 } else {
 $newcart = $item;
 }
 }
 }
 $cart = $newcart;
 }
 break;
	case 'update':
	if ($cart) {
 $newcart = '';
 foreach ($_POST as $key=>$value) {
 if (stristr($key,'qty')) {
 $id = str_replace('qty','',$key);
 $items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
 $newcart = '';
 foreach ($items as $item) {
 if ($id != $item) {
 if ($newcart != '') {
 $newcart .= ','.$item;
 } else {
 $newcart = $item;
 }
 }
 }
 for ($i=1;$i<=$value;$i++) {
 if ($newcart != '') {
 $newcart .= ','.$id;
 } else {
 $newcart = $id;
 }
 }
 }
 }
	}
	$cart = $newcart;
	break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<title>www.phpdemos.com.br</title>
	<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Seu carrinho de Compras</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="contents">

<h1>Verifique a quantidade...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Voltar para a loja...</a></p>

</div>

</body>
</html>

Discussão (1)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...