Recycled Shoes

SQL statements

Create Table SQL

CREATE TABLE tblMaterials (
pmkMaterialsId INT AUTO_INCREMENT PRIMARY KEY,
fldMaterialsName varchar(20),
fldMaterialsCo varchar(50),
fldMaterialsHelp varchar(250)
);

Populate the table with data

INSERT INTO tblMaterials (fldMaterialsName,
fldMaterialsCo, fldMaterialsHelp) VALUES

('Yarn', 'Nike', 'Prevents billion plastic 
bottles from reaching landfills' ),

('Sustainable cotton', 'Nike', 'Through the Better Cotton Initiative, organic cotton is 
grown without fossil fuel procured pesticides or synthetic fertilizers.'),

('Yarn', 'Adidas', 'Diverts ocean pollutants from harming marine life and 
fights the plastic waterbottle epidemic'),

('gillnet', 'Adidas', 'Decreases the killing of wildlife by 
decreasing the amount of fishnets and gillnets left in the ocean.');

Select data for display

SELECT fldMaterialsName, fldMaterialsCo, fldMaterialsHelp FROM tblMaterials
        

Create table to save forms data

CREATE TABLE tblFavoriteApparel (
        pmktblFavoriteApparelId INT AUTO_INCREMENT PRIMARY KEY,
        fldFavoriteApparel varchar(20),
        fldWhyApparel text,
        fldFirstName varchar(50),
        fldLastName varchar(50),
        fldApparelName varchar(50),
        fldEmail varchar(50),
        fldPreference varchar(12),
        fldYears1 boolean,
        fldYears5 boolean,
        fldYears10 boolean

);

Populate table with data

        INSERT INTO tblFavoriteApparel (fldFavoriteApparel, fldWhyApparel, fldFirstName, 
        fldLastName, fldApparelName, fldEmail, fldPreference, 
        fldYears1, fldYears5, fldYears10) VALUES
        ('Shirt', 'I like the aesthetic fit and feel of a nicely recycled t-shirt', 'Arjun', 'Nair', 'Nike free tee',
        'anair@uvm.edu', '1', '1', '1', '0');
        

Select data for display

SELECT fldFavoriteApparel, fldWhyApparel, fldFirstName, fldLastName, fldApparelName, fldEmail, fldPreference,
fldYears1, fldYears5, fldYears10 FROM tblFavoriteApparel