Login   Register  
PHP Classes
elePHPant
Icontem

File: sql_database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of kostas gougakis  >  Shopping basket with MySQL connection  >  sql_database  >  Download  
File: sql_database
Role: Auxiliary data
Content type: text/plain
Description: sql database
Class: Shopping basket with MySQL connection
Shopping basket stored in a MySQL database
Author: By
Last change:
Date: 2004-09-02 06:36
Size: 1,518 bytes
 

Contents

Class file image Download
# MySQL-Front 3.1  (Build 4.40)


# Host: kostas    Database: demo
# ------------------------------------------------------
# Server version 4.0.15-nt

#
# Table structure for table tbl_active_sessions
#

CREATE TABLE `tbl_active_sessions` (
  `sessionid` int(6) NOT NULL auto_increment,
  `start` varchar(255) default NULL,
  PRIMARY KEY  (`sessionid`)
) TYPE=MyISAM;

#
# Dumping data for table tbl_active_sessions
#

INSERT INTO `tbl_active_sessions` VALUES (413385,'1093895673');

#
# Table structure for table tbl_basket
#

CREATE TABLE `tbl_basket` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `sessionid` varchar(255) default NULL,
  `prodid` varchar(255) default NULL,
  `product` varchar(255) default NULL,
  `price` varchar(255) default NULL,
  `qty` varchar(255) default NULL,
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

#
# Dumping data for table tbl_basket
#

INSERT INTO `tbl_basket` VALUES (5,'413385f933014','1','a','12','2');
INSERT INTO `tbl_basket` VALUES (4,'413385f933014','2','sda','324','3');

#
# Table structure for table tbl_products
#

CREATE TABLE `tbl_products` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `product` varchar(255) default NULL,
  `price` varchar(255) default NULL,
  `data` varchar(255) default NULL,
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

#
# Dumping data for table tbl_products
#

INSERT INTO `tbl_products` VALUES (1,'a','12','sadadas');
INSERT INTO `tbl_products` VALUES (2,'sda','324','fgdgdfg');