anitacm

large php project. admin tools, multiple text/image upload tools, multiple tables. no graphics. MS DATABASE OR PHP SQL NUMBER OF COMPANIES: UNLIMITED NUMBER OF ADMINISTRATORS: 1 NUMBER OF GUESTS: UNLIMITED C = COMPANY RIGHTS = TRUE, and where company ID=ID A = ADMIN RIGHTS = TRUE G = GUEST RIGHTS = TRUE --------------- HOME PAGE ([login to view URL] OR PHP) [C,A,G] - LINKS TO - ALL BICYCLES ([login to view URL] OR .PHP) - ALL PARTS ([login to view URL] OR .PHP) - [login to view URL] WHERE PARTCATEGORY=PARTSCATEGORY - ALL COMPANIES ([login to view URL] OR .PHP) - REGISTER PAGE ([login to view URL]) REGISTER PAGE ([login to view URL]) IS WHERE COMPANIES CAN REGISTER TO USE THIS SYSTEM [C,A,G] - LOGIN - EMAIL - PASSWORD SUBMIT (ON SUBMIT, IF TRUE, REFRESH TO [login to view URL] WHERE ID=ID) (ON SUBMIT, IF FALSE, REFRESH TO [login to view URL] AND ERROR MESSAGE "INVALID, TRY AGAIN") - FORGOT PASSWORD - ENTER EMAIL (ON SUBMIT, IF EMAIL=YES IN DATABASE, REFRESH [login to view URL] AND MESSAGE "EMAIL SENT WITH PASSWORD") (ON SUBMIT, IF EMAIL=NOT IN DATABASE, REFRESH TO [login to view URL] AND ERROR MESSAGE "INVALID, TRY AGAIN") - REGISTER FIELDS - ID HIDDEN AND CREATED ON ENTRY TO DATABASE - Name (50 CHAR) - Email (50 CHAR) - PASSWORD (10 CHAR) - STATE (60 CHAR, DROP DOWN - YOU CAN TAKE STATIC LIST FROM MY PAGE ONLINE NOW) - ZIP (14 CHAR) - COUNTRY (60 CHAR, DROP DOWN - YOU CAN TAKE STATIC LIST FROM MY PAGE ONLINE NOW) - SELL (CHECKBOX) - BUILD (CHECKBOX) - TELEPHONE (50 CHAR) - ADDRESS 1 (50 CHAR) - ADDRESS 2 (50 CHAR) - CITY (50 CHAR) - COMPANYEMAIL (50 CHAR) - COMPANYWEBSITE (100 CHAR) - COMPANYDESCRIPTION (500 CHAR) SUBMIT BUTTON (ON SUBMIT, INFO INTO DATABASE, REFRESH PAGE TO [login to view URL] OR .PHP WHERE COMPANY ID=ID) [login to view URL] - WHERE COMPANY WHICH JUST REGISTERED CAN VIEW WHAT IT HAS TO OFFER [C,A,G] COMPANY INFORMATION TO BE LISTED AT TOP OF PAGE - NAME - Address 1 - Address 2 - City - State - ZIP - Country - Telephone - Company Email - Company Website (WITH LINK TO Company Website TARGET="_BLANK") - Company Description LINKS - ADD BICYCLE LINK ([login to view URL] OR .PHP) [C,A] IF BUILD=TRUE - ADD PARTS LINK ([login to view URL] OR .PHP) [C,A] IF SELL=TRUE - UPDATE COMPANY INFORMATION (LINK TO [login to view URL] OR [login to view URL] - programming decision for you) 2 TABLES [C,A,G] - TABLE 1, list ALL BICYCLES WHICH COMPANY ID HAS CREATED - YOU WILL SEE (REPEAT ROWS) COLUMN 1 - IMAGE COLUMN 2 - bicyclesYear bicyclesMake bicyclesModel bicyclesDescription bicyclesLink (LINKS TO HREF="bicyclesLink" target="_blank") [C,A !!!] EDIT (EDIT bicycle row where companyid=id and bicycleid=id links to [login to view URL] OR [login to view URL] your choice in programming separately) [C,A !!!] DELETE (Delete bicycle row where companyid=id and bicycleid=id, REFRESH to [login to view URL]) - TABLE 2, list ALL PARTS WHICH COMPANY ID HAS CREATED COLUMN 1 - IMAGE COLUMN 2 - Part PartPrice PartDescription PartLink (LINKS TO HREF="PartLink" target="_blank") [C,A !!!] EDIT (EDIT parts row where companyid=id and partsid=id links to [login to view URL] OR [login to view URL] your choice in programming separately) [C,A !!!] DELETE (Delete parts row where companyid=id and partsid=id, REFRESH to [login to view URL]) [login to view URL] FIELDS - ID HIDDEN , ENTERED ON DATABASE NEW ENTRY - BICYCLESYEAR (CHAR 4) - BICYCLESMAKE (STATIC DROPDOWN) - BICYCLESMODEL (CHAR 50) - BICYCLESDESCRIPTION (CHAR 500) - BICYCLESLINK (CHAR 100 - example [login to view URL]) - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO [login to view URL] WHERE ID=ID) [login to view URL] WHERE COMPANYID=ID AND BICYCLESID=ID FIELDS - ID HIDDEN - BICYCLESYEAR (CHAR 4) - BICYCLESMAKE (STATIC DROPDOWN) - BICYCLESMODEL (CHAR 50) - BICYCLESDESCRIPTION (CHAR 500) - BICYCLESLINK (CHAR 100 - example [login to view URL]) SHOW EXISTING BICYCLESIMAGE IF TRUE!! - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO [login to view URL] WHERE ID=ID) [login to view URL] FIELDS - ID HIDDEN , ENTERED ON DATABASE NEW ENTRY - PARTSCATEGORY (STATIC ROPDOWN LIST, CHAR 100) - PARTSPRICE (CHAR 5) - PARTSDESCRIPTION (CHAR 500) - PARTSLINK (CHAR 100 - example [login to view URL]) - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO [login to view URL] WHERE ID=ID) [login to view URL] WHERE COMPANYID=ID AND PARTSID=ID FIELDS - ID HIDDEN - PARTSCATEGORY (STATIC ROPDOWN LIST, CHAR 100) - PARTSPRICE (CHAR 5) - PARTSDESCRIPTION (CHAR 500) - PARTSLINK (CHAR 100 - example [login to view URL]) SHOW EXISTING PARTSIMAGE IF TRUE!! - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO [login to view URL] WHERE ID=ID) [login to view URL] [C,A,G] - SEARCH FOR BICYCLES BY SEARCH FORM (RESULTS ON [login to view URL] OR [login to view URL] - programmers CHOICE) - SEARCH FOR BICYCLES BY bicyclesMake DROPDOWN LIST (RESULTS ON [login to view URL] OR [login to view URL] - programmers CHOICE) - TABLE, list ALL BICYCLES FOR ALL COMPANIES (SORTED BY BICYCLEYEAR, 2005 LAST) - YOU WILL SEE (REPEAT ROWS - 10 or 20 per page?) COLUMN 1 - IMAGE COLUMN 2 - bicyclesYear bicyclesMake bicyclesModel bicyclesDescription bicyclesLink (LINKS TO HREF="bicyclesLink" target="_blank") COMPANYLINK (LINKS TO [login to view URL] RELATION) [login to view URL] [C,A,G] - SEARCH FOR PART BY SEARCH FORM (RESULTS ON [login to view URL] OR [login to view URL] - programmers CHOICE) - SEARCH FOR PART BY PARTSCATEGORY DROPDOWN LIST (RESULTS ON [login to view URL] OR [login to view URL] - programmers CHOICE) - TABLE, list ALL PARTS FOR ALL COMPANIES - YOU WILL SEE (REPEAT ROWS - 10 or 20 per page?) COLUMN 1 - IMAGE COLUMN 2 - PARTSCATEGORY COLUMN 3 - PARTSPRICE PARTSDESCRIPTION PARTSLINK (CHAR 100 - example [login to view URL]) COMPANYLINK (LINKS TO [login to view URL] RELATION) [login to view URL] [C,A,G] - SEARCH FOR BUILDER BY SEARCH FORM (RESULTS ON [login to view URL] OR [login to view URL] - programmers CHOICE) - TABLE, list ALL COMPANIES WHERE BUILD=TRUE - YOU WILL SEE (REPEAT ROWS - 10 or 20 per page?) COLUMN 1 - NAME (IF CLICK, SORT BY ALPHABETICAL) - LINK TO [login to view URL] WHERE COMPANYID=COMPANY NAME RELATION COLUMN 2 - STATE (IF CLICK, SORT BY STATE) COLUMN 3 - ZIP (IF CLICK, SORT BY ZIP) COLUMN 4 - COUNTRY (IF CLICK, SORT BY COUNTRY) COLUMN 5 - Description ----------------------------- MORE Programmer Choice to make: - IMAGE UPLOADS CAN BE PUT INTO DATABASE OR INTO SEPARATE FILE - PARTSCATEGORY CAN BE EITHER A STATIC LIST OR A RELATION TABLE WHERE 1=HANDLEBAR, 2=FRAME, - bicyclesMake CAN BE EITHER A STATIC LIST OR A RELATION TABLE WHERE 1=nissan, 2=honda,