MAKE YOUR OWN EATS WHY DESIGN MAKE YOUR

MAKE YOUR OWN EATS!

WHY DESIGN MAKE YOUR OWN EATS? Solution for the busy individual wanting to get into nutrition. Solution for the enthusiast wanting more ideas. Central location for updated health and nutrition information. Save on your grocery budget. Learn how to swap your ingredients around for better nutrition.

TASKS Research recipe options for different dietary requirements. Research health and nutrition topics. What technology will provide a simple and efficient solution to building the database and website?

DATA MODEL

MEALPLANDB (WORDPRESS_BITNAMI) mysql> show tables; | wp_m_pings | +-------------------------+ | wp_m_subscription_transaction | | Tables_in_bitnami_wordpress | | wp_m_subscriptionmeta | +-------------------------+ | wp_m_subscriptions | | accountsettings | | customer | | ingredient | | mealplan | | nutritionalfacts | | orderhistory | | wp_m_subscriptions_levels | | wp_m_urlgroups | | wp_options | | wp_postmeta | | wp_posts | | payment | | wp_term_relationships | | recipe | | wp_term_taxonomy | | recipeingredients | | wp_terms | | wp_commentmeta | | wp_usermeta | | wp_comments | | wp_users | | wp_links | | wp_woocommerce_api_keys | | wp_m_communications | | wp_woocommerce_attribute_taxonomies | | wp_m_coupons | | wp_woocommerce_downloadable_product_permissions | | wp_m_levelmeta | | wp_m_member_payments | | wp_m_membership_levels | | wp_m_membership_news | | wp_m_membership_relationships | | wp_m_membership_rules | | wp_m_ping_history | | wp_woocommerce_order_itemmeta | | wp_woocommerce_order_items | | wp_woocommerce_tax_rate_locations | | wp_woocommerce_tax_rates | | wp_woocommerce_termmeta | +-------------------------+ 43 rows in set (0. 00 sec)

MEALPLANDB (WORDPRESS_BITNAMI) mysql> select * from wp_users; +----------+------------------+------------------------+---------------+-----------------------+---------------+ | ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name | +----------+------------------+------------------------+---------------+-----------------------+---------------+ | 1 | mpadmin | $P$BT 14 MKo 53 t. EXd 7 VAEE/VTCZHjc. V 27 F/ | mpadmin | clo 0315@westminstercollege. edu | | 2015 -11 -11 01: 24: 56 | 0 | mpadmin | | 2 | testing | $P$BZ/T 1 Hwd. XW/lm. Vmbz. Htfj. MRIvfu. Hzb 0 | testing | xtm 1109@westminstercollege. edu | | 2015 -11 -20 01: 05: 56 | 0 | testing | | 3 | jumiesdera | $P$BQ 2 b. Zj 8 l. CVQg. JUYo 61 n. OPMXa. SF 5 t 0 P 1 | jumiesdera | jack 4@1 email. space | 2015 -11 -26 00: 23: 44 | 1448497425: $P$BJJx. XUyq. Z 4 AXBC 2 v. P 9 b. NQ 1 QBpd. SS 6 N. | 0 | jumiesdera | | 4 | Nikkihastings | $P$B 6/u 1 Hd 2 Q 3. m. T 77 TAElt. NINn. PYVUKh/ | nikkihastings | jumes@1 email. space | 2015 -11 -26 09: 51: 16 | 1448531476: $P$BDBT 3 LFjm 8 L 2 did. Zj. Ip. WUBjd 0 h. Trl 21 | 0 | Nikkihastings | | 5 | kbroten | $P$Bqcw 8 s. Uzp 9 b. V 1 ul. LYo 4 O/23 t. Dtl. XWJ. | kbroten | kmbroten 14@gmail. com | 2015 -12 -06 00: 14: 02 | 1449425827: $P$BYYJX 1 Mb 4 IVSf. Qx. Yi 5 mh 50 NAIAD/OI. | 0 | kbroten | | 6 | CPEats | $P$Bt/Eq. QBu. E/9 Z/2 GZje. Lr 2 Odobzu 75 C. | cpeats@gmail. com | 2015 -12 -06 03: 36: 00 | 0 | CPEats | | 7 | mail_test | $P$BF 2 IKUh. Zd. ksve 8 k. Id. WCPMQJ/z. Ko. Sh. | mail_test | xuan. tmai@yahoo. com | 2015 -12 -06 19: 33: 19 | 0 | mail_test | | 8 | crystalo test | $P$BI 7 p. /Qmpz. WV 1 j. Twt. WNy. X 4 Rb 25 X 1 sz. | crystalo-test | crystalmcdaniels@comcast. net | 2015 -12 -06 23: 58: 51 | 0 | crystalo test | +----------+------------------+------------------------+---------------+-----------------------+---------------+ 8 rows in set (0. 00 sec)

QUERY A RECIPE Grab recipe: select recipe. Name, servings, directions from recipe where recipe. ID = ‘some recipe. ID’; Grab ingredients for recipe: select ingredient. Name, measurement, amount from ingredients join recipe. Ingredients on recipe. Ingredients. ingredient. ID=ingredient. ID join recipe on recipe. ID=recipe. Ingredients. recipe. ID where recipe. ID = ‘some recipe. ID’;

RESULT | recipe. Name | servings | directions | +-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Chicken and Leek Pot Pie | 6 | 1. Spray a pie dish with cooking spray. Place the oil in a large skillet over medium-high heat. Add the chicken and cook for 3 minutes, turning until browned. Transfer to a bowl. 2. Add the butter to the pan and cook the leeks over medium heat for 4 -5 minutes or until soft. 3. Return the chicken to the skillet and increase the heat to medium-high. Sprinkle the flour into the pan and cook for 2 minutes, stirring constantly so that the flour thickly coats the chicken and leeks. Gradually add the broth, stirring the entire time. 4. Stir in the cream, tarragon, lemon juice and parsley and season with salt and pepper. 5. Reduce the heat and gently simmer until thickened. Remove from the heat and let cool. Spoon the mixture into the pie dish. 6. Roll the pastry out onto a lightly floured surface large enough to cover your dish. Fold the dough over the top of the pie, leaving the edges to overhang. Cut several slits in the top of the pie and gently press down around the edges with tines of a fork. 7. Place on a baking sheet and bake for 30 minutes or until the crust is golden brown. Let rest and slice into individual servings. |

RESULT +----------+-------+----+ | ingredient. Name | measurement | amount | +----------+-------+----+ | Puff Pastry Sheet | sheet | 1 | | Olive Oil | tbsp | 2 | | Chicken Breast | 2 | | Butter | tbsp | 1 | | Leeks | NULL | 2 | | Chicken Broth | cup | 1 | | Cream | cup | 2 | | Fresh Tarragon | tbsp | 2 | | Lemon Juice | tbsp | 1 | | Italian Parsley | tbsp | 2 | | Salt and Pepper | NULL | NULL | +----------+-------+----+ 11 rows in set (0. 00 sec)

TECHNOLOGY AWS Free Tier Ubuntu instance Bitnami hosting Wordpress app

MAJOR PROBLEMS? PHP learning curve WP objects and functions Custom templates