Sklepy internetowe
Autor: Adam Major

CREATE TABLE prod
(
 id_pr       smallint unsigned not null
             auto_increment,
 pr_act	     tinyint unsigned not null,
 rid_ct	     tinyint unsigned not null,
 rid_sc	     tinyint unsigned not null,
 name        char(40) not null,
 price_n     float(4,2) not null,
 price_b     float(4,2) not null,
 vat         tinyint,
 mini_t      tinyint unsigned,
 mini_w      tinyint unsigned,
 mini_h      tinyint unsigned,
 key         pr_act (pr_act),
 key         rid_ct (rid_ct),
 key         rid_sc (rid_sc),
 key         name (name),
 key         price_n (price_n),
 key         price_b (price_b),
 primary key (id_pr)
);

CREATE TABLE prod2
(
 id_pr2      smallint unsigned not null
             auto_increment,
 big_t       tinyint unsigned,
 big_w       tinyint unsigned,
 big_h       tinyint unsigned,
 info        text,
 primary key (id_pr2)
);

CREATE TABLE buy
(
 id_b        smallint unsigned not null
             auto_increment,
 status      tinyint unsigned not null,
 total       float (6,2) not null,
 firm        varchar (40),
 fname       varchar (20),
 lname       varchar (30) not null,
 street      varchar (40),
 post        char (6),
 city        varchar (30),
 region      tinyint unsigned not null,
 phone       varchar (22),
 email       varchar (40),
 pesel       varchar (11),
 nip         varchar (13),
 bad_post    tinyint unsigned,
 buy_date    timestamp not null,
 send_date   timestamp not null default '0',
 host        varchar (200),
 key         status (status),
 key         total (total),
 key         firm (firm),
 key         lname (lname),
 key         region (region),
 key         buy_date (buy_date),
 key         send_date (send_date),
 primary key (id_b)
);

CREATE TABLE buy2
(
 id_b2       mediumint unsigned not null
             auto_increment,
 id_z        smallint unsigned not null,
 id_p        smallint unsigned not null,
 qt          smallint unsigned,
 price_n     float (4,2),
 price_b     float (4,2),
 vat         tinyint,
 key         id_z (id_z),
 key         id_p (id_p),
 primary key (id_b2)
);

CREATE TABLE admin
(
 id_a        tinyint unsigned not null
             auto_increment,
 login       char(12) not null,
 pass        char(14) binary,
 primary key (id_a)
);

<?php

class cart
{
 var $za;
 function add ($element) { $this->za[$element]++; }
 function del ($element)
          { unset($this->za[$element]); }
 function edit ($element, $val)
          { $this->za[$element] = $val; }
 function show_cart() { return $this->za; }
 function drop_cart() { unset($this->za); }
}

function add_cart()
{
 global $HTTP_GET_VARS, $HTTP_SESSION_VARS, $cart,
  $c_total, $c_bad;

 $conn = pconnect_to_mysql();
 $sql = "select id_pr from prod where id_pr =
 '$HTTP_GET_VARS[id_p]'";
 if (!($res = @mysql_query($sql,$conn)))
   {$err_ln=__LINE__; include('db_error.php'); }
 if (@mysql_num_rows($res) == 0) return 0;

 if (!$HTTP_SESSION_VARS[cart])
  {
   session_register(cart, c_total, c_bad);
   $HTTP_SESSION_VARS[cart] = $cart = new cart;
   $HTTP_SESSION_VARS[c_total] = 0;
   $HTTP_SESSION_VARS[c_bad] = 0;
   if (ini_get ('register_globals'))
      $cart->add($HTTP_GET_VARS[id_p], 1);
      else $HTTP_SESSION_VARS[cart]->
        add($HTTP_GET_VARS[id_p], 1);
  }
  else $HTTP_SESSION_VARS[cart]->
       add($HTTP_GET_VARS[id_p], 1);
}

if ($HTTP_GET_VARS[id_p] > 0 AND
   is_numeric($HTTP_GET_VARS[id_p])) add_cart();
header('location: koszyk.php');

?>