phpdb

phpdb is project number 30106 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider vantrix)

Status:	Closed
Budget:	$30-100
Created:	10/19/2005 at 2:45 EDT
Bidding Ends:	10/21/2005 at 2:45 EDT
Project Creator:	bobjones3003   Buyer Rating: (No Feedback Yet)
Description:	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 (DEFAULT.ASPX OR PHP) [C,A,G] - LINKS TO - ALL BICYCLES (BICYCLES.ASPX OR .PHP) - ALL PARTS (PARTS.ASPX OR .PHP) - PARTS.ASPX WHERE PARTCATEGORY=PARTSCATEGORY - ALL COMPANIES (BUILDERS.ASPX OR .PHP) - REGISTER PAGE (REGISTER.ASPX) REGISTER PAGE (REGISTER.ASPX) IS WHERE COMPANIES CAN REGISTER TO USE THIS SYSTEM [C,A,G] - LOGIN - EMAIL - PASSWORD SUBMIT (ON SUBMIT, IF TRUE, REFRESH TO COMPANY.ASPX WHERE ID=ID) (ON SUBMIT, IF FALSE, REFRESH TO REGISTER.ASPX AND ERROR MESSAGE "INVALID, TRY AGAIN") - FORGOT PASSWORD - ENTER EMAIL (ON SUBMIT, IF EMAIL=YES IN DATABASE, REFRESH REGISTER.ASPX AND MESSAGE "EMAIL SENT WITH PASSWORD") (ON SUBMIT, IF EMAIL=NOT IN DATABASE, REFRESH TO REGISTER.ASPX 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 COMPANY.ASPX OR .PHP WHERE COMPANY ID=ID) COMPANY.ASPX - 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 (BICYCLES_ADD.ASPX OR .PHP) [C,A] IF BUILD=TRUE - ADD PARTS LINK (PARTS_ADD.ASPX OR .PHP) [C,A] IF SELL=TRUE - UPDATE COMPANY INFORMATION (LINK TO REGISTER.ASPX OR UPDATEREGISTER.ASPX - 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 ADD_BICYCLE.ASPX OR EDIT_BICYCLE.ASPX your choice in programming separately) [C,A !!!] DELETE (Delete bicycle row where companyid=id and bicycleid=id, REFRESH to COMPANY.ASPX) - 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 ADD_PARTS.ASPX OR EDIT_PARTS.ASPX your choice in programming separately) [C,A !!!] DELETE (Delete parts row where companyid=id and partsid=id, REFRESH to COMPANY.ASPX) BICYCLES_ADD.ASPX FIELDS - ID HIDDEN , ENTERED ON DATABASE NEW ENTRY - BICYCLESYEAR (CHAR 4) - BICYCLESMAKE (STATIC DROPDOWN) - BICYCLESMODEL (CHAR 50) - BICYCLESDESCRIPTION (CHAR 500) - BICYCLESLINK (CHAR 100 - example http://www.mysite.com/bicyle1.html) - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO COMPANY.ASPX WHERE ID=ID) BICYCLES_EDIT.ASPX 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 http://www.mysite.com/bicyle1.html) SHOW EXISTING BICYCLESIMAGE IF TRUE!! - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO COMPANY.ASPX WHERE ID=ID) PARTS_ADD.ASPX FIELDS - ID HIDDEN , ENTERED ON DATABASE NEW ENTRY - PARTSCATEGORY (STATIC ROPDOWN LIST, CHAR 100) - PARTSPRICE (CHAR 5) - PARTSDESCRIPTION (CHAR 500) - PARTSLINK (CHAR 100 - example http://www.mysite.com/HANDLEBAR1.html) - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO COMPANY.ASPX WHERE ID=ID) PARTS_EDIT.ASPX 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 http://www.mysite.com/HANDLEBAR1.html) SHOW EXISTING PARTSIMAGE IF TRUE!! - IMAGE UPLOAD SUBMIT (ON SUBMIT, GO TO COMPANY.ASPX WHERE ID=ID) BICYCLES.ASPX [C,A,G] - SEARCH FOR BICYCLES BY SEARCH FORM (RESULTS ON BICYCLES.ASPX OR BICYCLESRESULTS.ASPX - programmers CHOICE) - SEARCH FOR BICYCLES BY bicyclesMake DROPDOWN LIST (RESULTS ON BICYCLES.ASPX OR BICYCLESRESULTS.ASPX - 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 COMPANY.ASPX?ID=BICYCLEID RELATION) PARTS.ASPX [C,A,G] - SEARCH FOR PART BY SEARCH FORM (RESULTS ON PARTS.ASPX OR PARTSRESULTS.ASPX - programmers CHOICE) - SEARCH FOR PART BY PARTSCATEGORY DROPDOWN LIST (RESULTS ON PARTS.ASPX OR PARTSRESULTS.ASPX - 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 http://www.mysite.com/HANDLEBAR1.html) COMPANYLINK (LINKS TO COMPANY.ASPX?ID=PARTSID RELATION) BUILDERS.ASPX [C,A,G] - SEARCH FOR BUILDER BY SEARCH FORM (RESULTS ON BUILDER.ASPX OR BUILDERRESULTS.ASPX - 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 COMPANY.ASPX 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,
Job Type:	PHP
Database:	(I don't know)
Operating system:	(I don't know)
Bid count:	10
Average bid:	N/A