Hello, I have a domain and webserver for hosting my website.
The website is a dictionary-lookup type website.
The user will be brought to a search page on start (this is already done)
When the user types in a search query and presses enter,
it will have to search through the mysql database
The mysql database will display the information according to the word or phrase specified
We already have a sqlite database of about 1000 entries of words and their meaning and category -- which need to be converted and transferred over to MySQL database
for example if the user searches the word "rock", we would find 3 "rock"s in the database:
Rock - category: Music - A type of music
Rock - category: Slang - Cocaine
Rock - category: Geology - a hard object made of sand compacted together
This should get displayed in tabs (since there are more than one definition)
\[Music\]\[Slang\][Geology]
So the above part should be easy.
We will also have a feature called Become a Nutcracker, which will allow a webuser to add definitions to the mysql database (they need to be approved before they are displayed online)
If a user for example searches for a word that does not exist, it will show a message that the word was not found, and take them to the become a nutcracker page for that word, for example something like [login to view URL]
They can type in a quick short definition,
a category choose from existing or type a new one
they can add a maximum of 2 pictures
and \***|THE HARD PART\***|
We want to allow uploading of 1 video maximum or pointing to a youtube video per each word.
(You will have to find a way to store the video on our server for now)
Then the user clicks submit, and a thank you page will show up and the information will be submitted to the database (and an email will be sent to admin for approval)
Also
each search query should also be logged so we know which words are being searched for most
Aesthetics for the website should simple,
There should be a logo in the top left of each page.
## Deliverables
We need you to read between the lines and fill in the blanks when it comes to designing/programming this website. Code should be well written, object oriented, and files/code documented.
We want this website completely done after this.
We will provide you with a cpanel account and phpmyadmin account to a fresh new server upon acceptance of this project. Looking for PHP professionals at least 4 years of PHP/MySQL experience.