msh-master.zip

SET NAMES UTF8; DROP DATABASE IF EXISTS foot; CREATE DATABASE foot CHARSET=UTF8; USE foot; CREATE TABLE foot_user( fid INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50), fpwd VARCHAR(32), phone CHAR(11) ); INSERT INTO foot_user VALUES(null,'tom',md5('123'),18810001234); INSERT INTO foot_user VALUES(null,'jerry',md5('123'),18810001234); CREATE TABLE foot_product( fid INT PRIMARY KEY AUTO_INCREMENT, fimg VARCHAR(50), ftitle VARCHAR(32), fscore_a CHAR(3), fscore_b CHAR(3), fscore_c CHAR(3), star INT, content VARCHAR(1000), time VARCHAR(25), do_1 VARCHAR(25), do_2 VARCHAR(25), do_3 VARCHAR(25), do_4 VARCHAR(25), do_5 VARCHAR(25), do_6 VARCHAR(25), do_7 VARCHAR(25), do_8 VARCHAR(25), do_9 VARCHAR(25), img_1 VARCHAR(50), img_2 VARCHAR(50), img_3 VARCHAR(50), img_4 VARCHAR(50), img_5 VARCHAR(50), img_6 VARCHAR(50), img_7 VARCHAR(50), img_8 VARCHAR(50), img_9 VARCHAR(50), main_1 VARCHAR(50), main_2 VARCHAR(50), main_3 VARCHAR(50), main_4 VARCHAR(50), main_5 VARCHAR(50), main_num_1 VARCHAR(50), main_num_2 VARCHAR(50), main_num_3 VARCHAR(50), main_num_4 VARCHAR(50), main_num_5 VARCHAR(50), seasoning_1 VARCHAR(50), seasoning_2 VARCHAR(50), seasoning_3 VARCHAR(50), seasoning_4 VARCHAR(50), seasoning_5 VARCHAR(50), seasoning_6 VARCHAR(50), seasoning_7 VARCHAR(50), seasoning_8 VARCHAR(50), seasoning_9 VARCHAR(50), seasoning_10 VARCHAR(50), seasoning_num_1 VARCHAR(50), seasoning_num_2 VARCHAR(50), seasoning_num_3 VARCHAR(50), seasoning_num_4 VARCHAR(50), seasoning_num_5 VARCHAR(50), seasoning_num_6 VARCHAR(50), seasoning_num_7 VARCHAR(50), seasoning_num_8 VARCHAR(50), seasoning_num_9 VARCHAR(50), seasoning_num_10 VARCHAR(50), last_text VARCHAR(500) ); INSERT INTO foot_product VALUES(null,'1.jpg',"最好吃的香辣虾",1,0,1,3,"香辣虾是属于乱劈柴香辣干锅的一种，重庆乱劈柴干锅包块：香辣虾、干锅鱼、干锅兔等系列产品。乱劈柴干锅是重庆邦辉餐饮集团旗下品牌，更多香辣虾介绍请关注重庆乱劈柴干锅官网。","20分钟","把虾剥壳、洗干净、准备好烹饪配料","把洗好的土豆切成条，黄瓜切条，红椒切成段，老姜切片、准备在旁边","在烧热的油锅里倒入土豆炸微黄，下入黄瓜和蒜子，炸一下，捞出，大火烧油复炸一次吐油。","把准备好的虾放入油锅里炸变色、复炸一下","锅里的油全部出来，剩下的油小火把豆瓣和剁椒炒和油完全融合，放入姜片炒匀","放入虾，烹入一汤匙料酒，一茶匙糖，半碗高汤翻炒均匀稍微煨3-5分钟","再倒入之前炸好的配菜一起翻炒","关火、放点鸡精，这样味道更好，然后就起锅了，最好吃的乱劈柴干锅香辣虾起锅了",null,'1-1.jpg','1-2.jpg','1-3.jpg','1-4.jpg','1-5.jpg','1-6.jpg','1-7.jpg','1-8.jpg',null,"鲜虾","黄瓜","土豆","红椒",null,"500g","1根","2个","2-4个",null,"蒜瓣","剁椒","老姜","盐","料酒","高汤","油","糖",null,null,"15个","半勺","1块","适量","一勺汤","高汤","适量","一勺",null,null,"虾一定要鲜虾肉质吃起来口味更好"); INSERT INTO foot_product VALUES(null,'2.jpg',"美味的红烧肉",1,1,1,2,"魔兽也爱吃肉哦，这款红烧肉超级好吃，朋友们动手做起来^_^","1小时","五花肉洗净切块","锅内放半锅冷水，肉一同冷水下锅，水开后大火煮两分钟，捞出用温水冲洗干净，沥干水分。","放入五花肉大火煸炒，直至肉块两面金黄油脂冒出，用锅铲盛出一部分油。","放老抽翻炒上色，大约一分钟左右。","放入料酒炒香后放入盐，糖，注入热水没过肉块，锅内放一个葱结，大火烧开后转小火焖煮一个小时。","时间差不多时，开大火收汁，放入鸡精调味，翻炒几下后撒入葱花起锅。","香喷喷的红烧肉装盘上桌，开吃^_^","软糯鲜香的红烧肉，来碗米饭，绝配哦。","肥而不油，瘦而不柴，绝对好吃^_^",'2-1.jpg','2-2.jpg','2-3.jpg','2-4.jpg','2-5.jpg','2-6.jpg','2-7.jpg','2-8.jpg','2-9.jpg',"五花肉",null,null,null,null,"500g",null,null,null,null,"老抽","剁椒","老姜","盐","料酒","八角","油","糖",null,null,"10g","半勺","1块","适量","一勺汤","2个","10g","5g",null,null,"小贴士 红烧肉要多焖一会才会更酥烂，老抽是用来上色的，如果喜欢放生抽，也可以，但要注意盐量，以免放多了太咸。鸡精可随个人口味放与不放，不放也很好吃的，如果喜欢入口即化的感觉，大火煮开后焖一个半小时。"); INSERT INTO foot_product VALUES(null,'3.jpg',"小炒韭菜花",1,0,0,4,"很简单的一道家常菜，在家经常做，因为老公喜欢！","20分钟","韭菜花洗净切段","鸡蛋打均","香肠切薄片用料酒处理下","油锅7成热","放入蛋液","倒入香肠片翻炒出香味","倒入韭菜花翻炒","加盐，少量水，大火翻炒50秒","加味精起锅装盘",'3-1.jpg','3-2.jpg','3-3.jpg','3-4.jpg','3-5.jpg','3-6.jpg','3-7.jpg','3-8.jpg','3-9.jpg',"韭菜花","鸡蛋","广式香肠",null,null,"适量","2个","1根",null,null,"盐","油",null,null,null,null,null,null,null,null,"适量","适量",null,null,null,null,null,null,null,null,"因为是一锅炒，所以油适当放多点； 其实用川味香肠或腊肉风味更佳"); INSERT INTO foot_product VALUES(null,'4.jpg',"鱼香茄子",1,1,0,3,"这道菜味道鲜美、柔软润香、鲜咸适口、营养也非常丰富。下饭更是一大特点，拌着米饭吃，唇齿留香。","30分钟","将茄子切成约七八厘米的长条、蒜切末、小红辣椒切段、豆瓣酱剁碎备用。"," 往茄条里撒少许盐，然后拌匀。让其腌制10分钟左右。","取一只干净的小碗，然后依次放入玉米淀粉、糖、鸡精、生抽、醋，再倒入半碗清水，调成碗汁备用。","锅中加入适量的油，油热后将茄条依次放入锅中煎炸至表面微黄后盛出备用。","另换一只锅，锅中加入少许底油，然后将肉馅倒入锅中煸炒。","煸炒至肉馅变白成熟，加入豆瓣酱、小红辣椒煸炒匀均。","加入蒜末煸炒出香味。","将茄条放入锅中煸炒。","将碗汁倒入锅中，大火烧开后翻炒匀均。然后关火淋少许香油即可装盘。",'4-1.jpg','4-2.jpg','4-3.jpg','4-4.jpg','4-5.jpg','4-6.jpg','4-7.jpg','4-8.jpg','4-9.jpg',"蒜","猪肉馅","小红辣椒",null,null,"适量","适量","适量",null,null,"盐","鸡精","糖","生抽","醋","香油","玉米淀粉",null,null,null,"1大勺","1大勺","2勺","2勺","2勺","适量","适量",null,null,null,"小贴士 １、 这道菜在选茄子的时候，最好选用长茄子。 ２、 茄子的皮很有营养，最好留下。 ３、 辣椒的量可根据自己的口味适当增加减少。 ４、 豆瓣酱有盐味。所以在腌茄子的时候，放盐一定要小心。如果放了太多，就要过水清洗一下。 ５、 煎炸茄子的时候最好用平底锅。这样一次炸的茄子量多，还省油。"); INSERT INTO foot_product VALUES(null,'5.jpg',"鱼香肉丝好吃的三个秘诀",1,1,1,3,"鱼香肉丝做法并不难，但要出“咸甜酸微辣”、“红油满溢”的鱼香肉丝，要注意三个关键点。一是选材。里脊肉是首选，这样吃起来较为鲜嫩。要选择质量好的红泡椒，下锅前细细剁碎，这样才能炒出鲜亮的红油。二是火候。炒鱼香肉丝要猛火快炒，火要够大，锅气要足，这样炒出的菜味道自然不赖。三是比例。鱼香肉丝讲究“见油不见汤”，鱼香汁的调料比例要拿捏好，酱油、香醋、酒、白糖和水淀粉的比例为1:1:1:1.5:2；水淀粉不易过多，否则做出来的菜会芡汁太厚、汤汁过多。葱姜蒜的比例为", "30分钟","猪肉先横向切成片，再切成火柴棍大小的肉丝。","肉丝中加入半小勺盐和一小�