Create script to publish content of nutrition database

Closed

Description

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]

OTHER INFO

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.

TIME

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.

Skills: Excel, PHP

See more: excel database template nutrition, php nutrition database, mysql nutritional database, works at freelancer, where to work as a freelancer, where is freelancer com based, where is freelancer based in, where is freelancer based, where i change my name on freelancer, where can i get freelancer, what to order from freelancer, what to do in freelancer, what to do freelancer, what to do as a freelancer, what is a data entry test like, web template food, web rr com, web.rr, user test freelancer, to-do categories, the content freelancer, test at freelancer, select freelancer, rr web, rr. com

Project ID: #305509

Awarded to:

DesignSolutionSW

Please check PMB.Thanks.

$30 USD in 1 day
(59 Reviews)
7.0

10 freelancers are bidding on average $186 for this job

AphroECS

Hi. please check PM for details.

$250 USD in 3 days
(72 Reviews)
7.4
grazianno

hello, please check your PMB.

$200 USD in 3 days
(180 Reviews)
6.9
netxpertindia

We are ready to start

$250 USD in 5 days
(86 Reviews)
6.8
Team21

hi! we are ready to start.

$200 USD in 4 days
(50 Reviews)
6.0
corpotec1993

Hello ! Please refer PMB. Many thanks. Corpotec

$175 USD in 2 days
(33 Reviews)
4.7
blinki

hello, please check PMB. Thanks

$180 USD in 3 days
(19 Reviews)
4.4
Markkalender

hey budget on this might be lower but max 250 lets say. you can see all the work i have done on my site markkalender.com im a php/mysql expert and have worked with many projects similar to this. i am from montreal cana More

$250 USD in 1 day
(9 Reviews)
4.0
opbissa

Hello, We are experienced PHP Developers. We can handle this job as per your requirements. We are ready to start this job. Thanks

$150 USD in 3 days
(6 Reviews)
2.0
prasadfreelancer

Hi! I am interested in your project! Thank you! Please see PMB ....

$175 USD in 2 days
(1 Review)
1.0
kangarsoft

Hi, As per your requirements and our past experience, we can do such kind of in 3 days. We have expertise in PHP and MySQL. I am sure that we will exceed your expectations. We always prioritise client satisfactio More

$200 USD in 3 days
(0 Reviews)
0.0