PHP/MySQL/Database Design and Connection

Require a coder that will provide 1. a database, that will a) take users details, name / email / tel / address / password b) take input of a website name, description of said website, URL of website, and upto 4 possible categories that the website is attributed to c) have an end date for website mentioned in b), d) be able to store the information within the db after the end date. 2. provide PHP coding to implement on a website, allowing users to log in and save details in their "area" and also have same/similar abilities that current site has. ## Deliverables Require a coder that will provide 1. a database, that will a) take users details, name / email / tel / address / password (and have the ability for the user to choose their password, and have it emailed to them) b) take input of a website name, description of said website, URL of website, and upto 4 possible categories that the website is attributed to c) have an end date for website mentioned in b), d) be able to store the information within the db after the end date. e) Admin must have access to this, and the ability to edit the information. f) when the end date has passed, the website in b can be archived, but still searchable. g) provide basic searchability - with users having the option to choose current websites (from b) or closed websites - or both. h) ability for users to add the details for b but for it not to go live before an Admin authorises it. i) ability to mark a specific website as being visited/entered by a user, and that saved in their account area 2. provide PHP coding to implement on a website, allowing users to log in and save details in their "area" and also have same/similar abilities that current site has. This list is possibly not exhaustive, however I think I've covered the main areas, I currently have a db on Mysql which holds: name of website description of website URL of website other field (for website) End date and 5 columns for categories, which are in a table names sectors. * * *This broadcast message was sent to all bidders on Sunday Jan 24, 2010 1:32:07 PM: Thank you for your interest. The website is going to be showing a list of websites and their competitions (I run a competition website) I require admin and registered users to: Do the following 1. Add Name of Website 2. Add Specific URL of website 3. Add Description of website 4. Add a Closing Date for the website 5. Add a Field of Text (quite small - around 60characters max) 6. Add upto 5 categories that the website fits into 7. create further categories When a registered user adds a basic listing - admin will need to moderate before it's visible to all on the website. Users will as you stated have the ability to: 1. Change their password 2. Login/Logout 3. Add the 6 above points (not point 7) 4. Have the ability to click a button eg beside the public listing, to say that they have visited/entered the competition listed. 5. as the database entry will have a closing date, when this date passes - the competition is automatically moved to a searchable archive category. 6. users will be able to view the competitions that they have entered. 7, users will be able to view the normal listings - however - with competitions they have entered - these will be highlighted I have also added a picture of the listings at the moment - the website is [login to view URL] the users area is to be called - "UKwins Trackbox"