PHP Classes

File: shopcart.sql

Recommend this page to a friend!
  Classes of RAZA   shopcart   shopcart.sql   Download  
File: shopcart.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Script
Class: shopcart
Manage a shopping cart stored in a MySQL database
Author: By
Last change:
Date: 14 years ago
Size: 658 bytes


Class file image Download
CREATE DATABASE if not exists `shopcart`; USE `shopcart`; /*Table structure for table `products` */ DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `productID` int(11) NOT NULL AUTO_INCREMENT, `productName` varchar(50) NOT NULL, `productCode` varchar(10) NOT NULL, `productPrice` double NOT NULL, PRIMARY KEY (`productID`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*Data for the table `products` */ LOCK TABLES `products` WRITE; insert into `products`(`productID`,`productName`,`productCode`,`productPrice`) values (1,'Tshirt','SRTS',20),(2,'Trousers','SRTR',25.5),(3,'Track Suit','SRTSU',40);