PHP Classes

File: mydatabase.sql

Recommend this page to a friend!
  Classes of Carlos Miguel Guevara   classListbox   mydatabase.sql   Download  
File: mydatabase.sql
Role: Auxiliary data
Content type: text/plain
Description: the database for the example
Class: classListbox
Generate form select inputs from database queries
Author: By
Last change:
Date: 18 years ago
Size: 2,006 bytes
 

Contents

Class file image Download
-- -- Table structure for table `catalog` -- CREATE TABLE `catalog` ( `rowId` tinyint(4) NOT NULL auto_increment, `catalog` varchar(30) NOT NULL default '', PRIMARY KEY (`rowId`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -- Dumping data for table `catalog` -- INSERT INTO `catalog` VALUES (1, 'fruits'); INSERT INTO `catalog` VALUES (2, 'vehicles'); INSERT INTO `catalog` VALUES (3, 'names'); INSERT INTO `catalog` VALUES (4, 'countries'); -- -------------------------------------------------------- -- -- Table structure for table `inventory` -- CREATE TABLE `inventory` ( `productId` tinyint(4) NOT NULL auto_increment, `catalogId` tinyint(4) NOT NULL default '0', `product` varchar(20) NOT NULL default '', `decription` varchar(40) NOT NULL default '', PRIMARY KEY (`productId`) ) TYPE=MyISAM AUTO_INCREMENT=17 ; -- -- Dumping data for table `inventory` -- INSERT INTO `inventory` VALUES (1, 1, 'banana', 'yellow fruit'); INSERT INTO `inventory` VALUES (2, 1, 'apple', 'red fruit'); INSERT INTO `inventory` VALUES (3, 1, 'orange', 'delicious fruit'); INSERT INTO `inventory` VALUES (4, 1, 'watermelon', 'my favorite fruit'); INSERT INTO `inventory` VALUES (5, 2, 'car', 'I have a car'); INSERT INTO `inventory` VALUES (6, 2, 'bus', 'a large car'); INSERT INTO `inventory` VALUES (7, 2, 'airplane', 'my private airplane'); INSERT INTO `inventory` VALUES (8, 2, 'motorcycle', 'i dont like this'); INSERT INTO `inventory` VALUES (9, 3, 'cesar', 'my friend'); INSERT INTO `inventory` VALUES (10, 3, 'edward', 'my ugly friend'); INSERT INTO `inventory` VALUES (11, 2, 'Luis', 'cesar''s brother'); INSERT INTO `inventory` VALUES (12, 2, 'tamika', 'my dog'); INSERT INTO `inventory` VALUES (13, 4, 'Mexico', 'I live here'); INSERT INTO `inventory` VALUES (14, 4, 'Chile', 'a nice place'); INSERT INTO `inventory` VALUES (15, 4, 'Germany', 'I like this place'); INSERT INTO `inventory` VALUES (16, 4, 'Brazil', 'the best asses');