Caloric Value Of Foods Search

Open foodValues database and index the data by the description(Field2) column In order to pass data to the script we need to use a form tag and post the input "food" from the user to the script. In this case it is the same URL as the input field.

Enter the food item below :

You can select the information you would like to view checking the boxes below.

	Weight Of Household Measure (g)	Water (%)	Calories (kcal)
	Ascorbic Acid (mg)	Protein (g)	Fat (g)
	Saturated Fatty Acid (g)	Monounsaturated Fatty Acid (g)	Polyunsaturated Fatty Acid (g)
	Cholesterol (mg)	Carbohydrate (g)	Calcium (mg)
	Phosphorus (mg)	Iron (mg)	Potassium (mg)
	Sodium (mg)	Vitamin A (IU)	Vitamin A (RE)
	Thiamin (mg)	Riboflavin (mg)	Niacin (mg)

Take the values passed from the form fields and assign it a name. Convert search text to upper case. All descriptions in database are in uppercase. Mavica searches are always case sensitive If the input field is blank or this is the first enter into the page, close the db connection Otherwise filter the database by the input field. This will look for the term in any part of the description field. This will print to the screen the column headings This will format and print to the screen the current record that is found by the filter command. The MvSKIP command will skip to the next record and the process will continue until end of record is met

Food Description

Weight Of Household Measure(g)

Water(%)

Calories(kcal)

Protein(g)

Fats(g)

Saturated Fatty Acid(g)

Monounsaturated Fatty Acid(g)

Polyunsaturated Fatty Acid(g)

Cholesterol(mg)

Carbohydrate(g)

Calcium(mg)

Phosphorus(mg)

Iron(mg)

Potassium(mg)

Sodium(mg)

Vitamin A(IU)

Vitamin A(RE)

Thiamin(mg)

Raboflavin(mg)

Niacin(mg)

Ascorbic Acid(mg)

Home Page A Helping Hand Design-A-Diet About The Author Our eBook Sign Me Up

Questionnaire Calorie Counter Food Calorie Table Contact Us Free Drawing #1 Diet Secret Weekly Recipes

Deli Sandwich Calculator Supplements Cathy's Comment Corner