Dictionary Lookup Website in PHP / MYSQL

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)


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 [url removed, login to view]

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)


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.

Skills: MySQL, PHP, Software Architecture, Software Testing, SQL, Web Hosting, Website Management, Website Testing

See more: php dictionary lookup, online dictionary phpmyadmin, word designing online, website user database programming, website to find professionals, website for designing words, website designing and hosting, video made from pictures, to find professionals, start php programming, quick logo online, q find, programming website for php, programming sql server online, programming in sql, programming dictionary, programming definitions, programming definition, php object oriented programming, php mysql website programming, php code search mysql database, online geology, object oriented programming in c, object oriented programming example, object oriented programming definition

About the Employer:
( 1 review ) United States

Project ID: #2670406