Wicked Cool PHP

Appendix A. APPENDIX

Several scripts in this book refer to a product_info table containing details of the inventory for a hypothetical store. Here is the table definition:

CREATE TABLE 'product_info' (
  'product_name' varchar(50) default NULL,
  'product_id' int(10) default NULL,
  'category' enum('shoes','gloves','hats') default NULL,
  'price' double default NULL,
  PRIMARY KEY  ('product_id')
);

Once you have the table in place, you will probably want to provide some sample data:

INSERT INTO 'product_info' VALUES ('Cowboy Boots',12,'shoes',19.99); INSERT INTO 'product_info' VALUES ('Slippers',17,'shoes',9.99); INSERT INTO 'product_info' VALUES ('Snowboarding Boots',15,'shoes',89.99); INSERT INTO 'product_info' VALUES ('Flip-Flops',19,'shoes',2.99); INSERT ...