Wednesday, February 13, 2013

PDO for Database Access

Why you Should be using PHP’s PDO for Database Access



http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/

Monday, January 28, 2013

Week 4 - Class Notes

deals

reviews
- review_id
- product_id
- username
- comments
- rating
- timestamp

order
- order_id
- subtotal
- shipping
- tax
- grand total (Based on third rule of normilization there is no need to store grand total because you can figure it out from the data. Some sites will have a grand total in the data for efficiency.)


related_items
-related_items_id
-source_product_id
-target_product_id


products
- product_id
- images
- title
- price
- discount
- description
- item number
- inventory



order_item
- order_item_id
- order_id
- product_id
- price
- quantity - line_item (not necessary)

category_to_product_lookup
- id
- category_id
- product_id


categories
- category_id
- title


customers
- customer_id
- billing_address_line1
- billing_address_line2
- billing_city
- billing_state
- billing_zip
- phone
- firstname
- lastname
- email address
- credit card (number, name, ccc, exp date, type)
- shipping_address_line1
- shipping_address_line2
- shipping_city
- shipping_state
- shipping_zip





Monday, January 14, 2013

Week 2 - Class Notes

Example Project:
Product = Song
parameters: title, length, artist, price, year, album, genre

The more detailed the better.

Tuesday, October 5, 2010

Week 1 - Class Notes

Suppliers
Your Price Point
Customer Relations
The Back End

Desirable Capabilities
- Gift Sending
- Affliliate Programs
- Special Discounts



Alexa
http://www.alexa.com/


15 Common Mistakes of eCommerce Design
http://uxdesign.smashingmagazine.com/2009/10/08/15-common-mistakes-in-e-commerce-design-and-how-to-avoid-them/

- Lack detailed product information
- Hides contact information
- Long and confusing check out process
- Requiring an account to order
- Inadequate site search engine
- Tiny product images
- Only 1 product image
- Poor shopping cart design
- Lack of payment options (authorize.net, paypal, google wallet)
- Not including related products
- Not including shipping rates




http://www.freepeople.com/vintage-loves/
http://www.toms.com/


Lab
Samy camera nikon d600
18-300 milimeter lens
camera bag lowepro









http://www.etsy.com/blog/en/2012/featured-shop-paulova/
http://www.etsy.com/listing/89159505/moss-green-dinosaur-planter-modern?ref=v1_other_1
http://www.etsy.com/shop/VanessaBullick
http://www.fullcircle.com/organic-produce-groceries/pricing/#s.ad7oqrspibaaa

http://icondock.com/icons/checkout