In my previous post i mentioned that i was going to setup the basic functionality of the website, and the databses before i worked on anything else, and this is what i am going to do!
Step1: users database
Fields: user id, username, password, email address
STATUS: POPULATED WITH 4 USERS
Step 2: recipe database
fields: recipe id, title, time, cost, ingredients, meal type, instructions
STATUS: POPULATED WITH 5 RECIPES
SOURCE: CREATED BY ME
These have been created on both the hosted database and my local database for testing. I am now going to construct a login page, a checklogin page, a user account page, as well as a page to search the menu database and a page which displays the results.
THIS SCREENSHOT DISPLAYS MY LOGIN PAGE DATABASE ON THE SERVER!
THIS SCREENSHOT SHOWS ME EXPORTING THE DATABASE SO THAT I CAN DUPLICATE IT ON MY SERVER FOR TESTING
I need to do some planning which will be in my sketchbook on pages 4-5Pages i need to make: WELCOME PAGE, LOGIN PAGE, CHECKLOGIN PAGE, SUCCESS PAGE, FAILURE PAGE, SEARCH DATABASE PAGE, RESULTS DATABASE PAGE.
It outlines the pages i am making. The php code files that i am making the login pages from will be derived from my PHP blogging project that i am doing for another university project.
I am writing my own recipes for the purposes of this project. They will use only 2-5 ingredients.I will derive some of my instructions and info from various sources which will be listed below!
cheese on toast: ME! (SIMPLIFIED)
red pepper chicken pasta: me! (simplified)
tuna pasta bake: me! (simplified)
bacon and cheese pasta: http://www.studentrecipes.com/recipes/quick-food/bacon-and-cheese-pasta/
chicken and chips: me! (simplified)
The offline database source for the recipe is titled 'recipe database' and is a .txt file. In the next post i'll have my basic website up and running.
EDIT I added a second recipe to the end of the database with duplicate ingredients in order to test the function & show how results would be displayed.
No comments:
Post a Comment