Web技術を統合したカロリー計算データベースの設計と構築

Abstract

This paper proposes a design and construction for calorie calculating database integrated with some Web technologies. The database server is implemented by MySQL, Web server is by Apache, and Web scripting language is by PHP. PHP is known as well-suited with both MySQL and Apache servers. The database consists of five tables such as a dish table, a cooking recipe table, a food table, a cooking-category table, and a personal-user's table. All of tables are derived from the entity-relationship (ER) model regarding to cooking recipes. The behavior of system could be started with selecting a menu among Japanese, Western, and Chinese foods or entering food amount for the recipe. The values of food compositions per 100g are automatically calculated, then the system show the total calorie and Protein-Fat-Carbohydrate (PFC) balance on user's web browser. The former is formed as a table, and the later as a radar chart. The chart could be dynamically drawn by the combination with a Flash ActionScript and a XML script. Here, PHPDOM rewrites the values of contents in the XML file. The number of foods contained in "The Standard Tables of Food Composition in Japan Fifth Revised Edition" is up to 1882 items.