Learning PHP/MySQL & SITE BUILDING

The hosting company that i bought my website from had dbadmin pre-installed which according to the tutorial on http://www.freewebmasterhelp.com/tutorials/phpmysql/2 will make the whole system much simpler.


I am going through the tutorial, but i realised that i don't actually know what i want in my fields, or how to structure it. I realise that i need to create an example in excel to work out how to structure it, and find a few recipes to populate it.

I wasnt sure if i should include include the original web address of the recipe in the database in the first test database to save space, but i will do as it allows me to keep a good record. In my first database i am going to include: an index of the recipe (an 'R' followed by a 3 digit number), the main ingredients, and the cooking time.

I realised that i have no idea what the most commonly thrown away foodstuffs are, so i decided to look it up. If i am designing an app to save ofen discarded food, i have to know what food is often discarded. I found this article by the BBC: http://news.bbc.co.uk/1/hi/uk/7389351.stm which states that 60% of food waste is salad, fruit or bread, resulting in 9bn of avoidable waste, most of which went untouched. The study looked at over 2,00 households. Potatoes and bread made up almost 40%. Meat and fish made up around 18%

I think that i'll focus on these, but in the future I'll undertake my own survey to find out what is most often thrown away in a more detailed way. I want to include food costs too.

I found a link on the website which states 20 recipes for under £1 per head, which assumes that you have the basics: oil, butter, flour, stock cubes and dried herbs. I'll do the same, as my idea does kind of rely on the fact that you have very basic things as otherwise it might be too complicated (you'd have to input absolutely everything you have in the cupboard, and assuming means that youd save time). I will aso assume that you have milk, onions and garlic.



this is my database test layout, which i will use to build my first online database



this is my first online database, which i made using dbadmin, and populated using information taken from my excel spreadsheet.

I'm watching this video tutorial to learn how to link it up with dreamweaver: http://www.youtube.com/watch?v=Xuy4cvL2zqs