I have a nutrition database with appx. 1300 entries where different food is assigned a value of how many kcal, proteins, carbs etc. they contain. I need you to create a script which pulls the desired data from the database and displays it on my web pages. A MySQL/PHP solution is required.
Screenshot of database here: [url removed, login to view]
A sketch of how the categories and individual entries would be arranged:
[url removed, login to view]
The database is at the moment in an excel file.
The content of the database is in Norwegian. A language with strange characters like æ, ø & å. These characters can't be used as names on .html pages because not all browsers recognize them. This needs to be taken into consideration (replace "æ" with "_" for example)
Title tag in category pages need to be the name of the category. Example:
Pulver tørr vare
Title tag in entry pages need to be the name of the food AND some keywords provided by me. Example:
Buljongpulver - Antall kalorier, proteiner, karbohydrater
Name of pages need to user-friendly. Example: [url removed, login to view], not [url removed, login to view]
The pages need to be template based and possible to modify, add ads, add footer, change format of text and font.
WHAT I NEED YOU TO DO
I will send you the database and information about which information you need to pull from it. You create the script and upload it to your site so I can test it. When everything works fine you send me the final script.
I am not sure how long time this project takes, but the main work is pulling the data from the database and displaying it on .html pages. Modifications to .htaccess in order to make user/seo friendly URLS may also be time consuming. I would like to select a freelancer on Tuesday which can get the job done by the end of the week.