I have a database link the following:
An example record:
id = auto from mysql
Description=<strong>Ingredient Name:</strong> Riboflavin (Vitamin B2)<br /><strong>Category:</strong> Colouring<br /><strong>Description:</strong><br />Riboflavin formerly called lactoflavin (Vitamin G) is yellow or orange-yellow in colour and in addition to being used as a food Colouring. It is also used to fortify some foods. It can be found in baby foods, breakfast cereals, sauces, processed cheese, fruit drinks and vitamin-enriched milk products as well as being widely used in vitamin supplements. Usually the source is synthetic.
Note, description has a HTML template set that needs filling, the tags need to be in-order for mySQL.
I will give the winning bidder the URL of the site that contains all the information, make a script to fill my database automatically from their pages. There pages consist of a table, and the table has many rows with these bits inside them.
The job is four parts:
- Understand the database and the two food types, E codes and Ingredients.
- Make a PHP script which the admin can run that loads the database MySQL automatically.
- Make a PHP simple page for admin, admin can view results, delete or edit the database.