Final Project - Source Code

I've posted my code to the onepotcooking.com server. I'm trying to get read-only FTP access setup for my site at Lunar Pages. If I get that going, I will post user/pass so people can access the code as it's updated. I will also try to give database access.

Keep in mind that the site will not run on onepotcooking, so you have to login via sFTP to download the files.

onepotcooking.com/brianyulke/final

Final Project

Website is done, at least within the scope of this class.

View it here: www.mishmoshofnosh.com

I will likely continue working on the site beyond this class. There is still a lot more work to be done before it is ready for prime time. However, I feel in its current condition it fulfills the requirements of the assignment in demonstration my knowledge of the topics covered throughout the course.

Feel free to register and post recipes. As I work on the site I will try my best to preserve what is there.

Final Project - Wire Frame 1

I completed the wireframe layouts for 3 of 4 pages.

Home Page:

Recipe View Page:

Post Recipe Page: This is done with two pictures because the PPT slides were not big enough to fit all the info I needed to include. The ellipses in the first picture indicate it continues to the next picture. The ellipses in the second picture indicate the section can continue if more data input is needed. For example, each time the user enters an ingredient, a line for another ingredient will appear below it. I'm not sure if I will make this automatic or if I will have a button or link at the end of the last line the user will have to push to add an additional ingredient. Whatever I decide will be implimented for both ingredients and for the direction steps.



I will also include a registration page which has not yet been wireframed. In addition, I'd like to include an advanced search page, but that will only happen if I have time. The advanced search would allow the user to search by criteria such as max ingredients, which ingredients, max prep/cook/total time, yield size, min/max rating, multiple categories. If I do include the advanced search page I will likely think of more search criteria.

Final Project - Database Layout

I decided to use Access to layout my tables and relationships. Using the relationships tool I connected the foreign keys from one table to the ids of other tables. This helped me get a clear picture of how my database tables will relate to one another. Drawing this stuff out on paper wasn't cutting it and I didn't want to just dive into building tables in MySQL.

Here's a picture of my current layout:

Web Dev Tools

Found an article this morning from David Bone's favorite magazine, Smashing Magazine. They outline 15 useful in-browser development tools. Some of those tools we are already using, and some of them seem like they might be very helpful additions.

Here's a link to their article.

I only found the article this morning and have not yet had a chance to try and of them myself. I'd be curious to see if anyone finds a use for them.

Final Project - Preliminary Idea

I plan to create a recipe collaboration site, of sorts...

A quick brainstorm of features:

• post, comment on, and rate recipes
• post substitutions and alternates to existing recipes
• browse recipes by category (soup, dessert, casserole, vegetarian, meat, etc)
• search based on cooking methods, ingredients, # of ingredients, prep/cook time, etc
• encourage copious pictures and videos to be posted alongside the recipes (commenters can also submit pics/vids)
• ability to moderate your post or allow anyone to comment/add
• allow for easy scaling of recipe to larger or smaller servings
• change between measurement units (oz to grams, cups to liters, etc)
• user profile page
  

Class 8 - Assignment

My blog is as its title suggests: CRUD Blog

I've struggled a bit getting elements to show/hide and things to line up as I want. The basics work, though. You can login, register, post/delete, add comments, etc. If you are not logged in, you cannot edit/delete or post a comment, only view them. Once logged in you have the option to edit/delete and post comments.

Mosaic Picture Search

This cool site allows you to choose up to 10 colors. It then returns images licensed under Creative Commons (free to use) that contain those colors.

Multicolr Search Lab

Class 7 - Assignment

Picture Pages

I have the base functionality working. Upload a pic, it shows in a list. I did not focus much on the ascetics of this page, but more on the functionality. I tried to think of useful features that a normal, commercial, picture website would have. Below is a list of some of the included features.

• Clicking any page when not logged in will send you to the login page
• You cannot register a user that already exists
• Must confirm password and it cannot match username
• Option to keep logged in for 1 day, else expires after 1 hour
• Default view is last 6 pics, can select 6, 12, 30, All
• Upload requires file and description - cannot upload blank entry
• Admin page: delete users, delete pictures

I had many other features I wanted to implement, but did not have the time to research and learn. As it is, I spent many hours every night this week working. Unfortunately, a lot of that time was troubleshooting silly errors such as misspelling a variable, forgetting the semicolon, or assuming I know how a function works when I really have no clue.

Funny Comic - MySQL

http://xkcd.com/327/

Class 6 Assignment

You can view my e-commerce store website here.

The page nav links all work (except for Show All). When you click on page 1, 2 or 3 it requests store.php?page=# where # is the page number you selected. I use $_GET['page'] to figure out what page is being requested.

I only have one store.php file. By default it displays the first 9 products. When you select another page, it figures out what 9 products to display based on the page number. Since the variables for each product contain a number corresponding to that product, I have the PHP code build the variable name to call based on which product it is trying to display.

I have a single statement to print the product thumbnail to the page which is nested in a loop. The loop gets it's starting and ending values based on a calculation performed on the page number which is being viewed. So if you are viewing page 2, it calculates $startProd to be 10 and $endProd to be 18, then loops from 10 to 18, each time printing to the screen the function productInfo() which is passed 4 variables: the ID, image path, name, and description. Every third iteration of the loop prints a
since we are working on a 3x3 grid. This is done by a simple if...elseif statement. Each iteration of the loop incriments a variable $brCount. Everytime it hits 3
is printed and the variable is reset to 1.

I didn't like the idea of hard coding all the product info into variables, but since we have not yet learned about MySQL, I had no choice. However, I opted to create a separate file containing all the variables for the product info and called it db.php.

The "displaying 1 to 9 of 27" is also calculated based on which page is being viewed. The 27 is static, but 1 and 9 are just a couple variables I was already using, $startProd and $endProd.

The Prev and Next are also calculated based on the current page number. Prev is $page+1. When you are on page 1, Prev is calculated to be 0. Rather than futz with some code (I'm tired) I just tested the value of $page at the top of the store.php file and set it to 1 if it starts as 0.

All Assignments Through Class 5

Class 1
Wireframe Diagram (jpg)

Class 2
Wireframe converted to XHTML and CSS
Petshop page using XHTML and CSS

Class 3
Web Dev Directory using XHTML and CSS

Class 4
Shipping Address using JavaScript

Class 5
E-commerce Store using JavaScript

Class 5 Assignment

My page isn't 100%, but the JavaScript part is complete.

I ended up spending too much time trying to get the JavaScript to be too fancy and too modular (and failing) leaving myself with little time for the rest of the design and layout.

Class 5 Assignment

Free Images

Found a site that has over 1000 images that are free to use. The majority of them are related to world travel, the rest are mostly food and flowers.

http://www.pachd.com

Webdesign Ideas

Given the light reading assignment for this week I spent a little time thinking about my final project ideas. In searching around for web site templates and design ideas I came across a couple sites.

www.layoutcookbook.com
This site has a ton of layout designs. They are all in gray-scale, and don't give a lot of detail, but seemed like a good place for some starter ideas.

websitetips.com
While it's not necessarily web layouts, it has links to other pages about how to get the creative juices going.