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,