tag:blogger.com,1999:blog-60707157603756152512024-03-13T10:05:42.290-07:00MM3311 ecommercewhatawhalehttp://www.blogger.com/profile/11475173156291726019noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6070715760375615251.post-66201697230612265612013-02-13T19:29:00.000-08:002013-02-13T19:29:14.875-08:00PDO for Database Access<h1 class="post_title">
Why you Should be using PHP’s PDO for Database Access</h1>
<br />
<br />
http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/whatawhalehttp://www.blogger.com/profile/11475173156291726019noreply@blogger.com0tag:blogger.com,1999:blog-6070715760375615251.post-45909419398540548192013-01-28T08:52:00.001-08:002013-01-28T09:39:59.720-08:00Week 4 - Class Notes<b>deals</b><br />
<br />
<b>reviews</b><br />
- review_id<br />- product_id<br />- username<br />- comments<br />- rating<br />- timestamp<br />
<br />
<b>order</b><br />
- order_id<br />- subtotal<br />- shipping<br />- tax<br />- 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.) <br />
<br />
<br />
<b>related_items</b><br />-related_items_id<br />-source_product_id<br />-target_product_id<br />
<br />
<br />
<b>products</b><br />- product_id<br />- images<br />- title<br />- price<br />- discount<br />- description<br />- item number<br />- inventory<br /><br /><br />
<br />
<b>order_item</b><br />
- order_item_id<br />- order_id<br />- product_id<br />- price<br />- quantity - line_item (not necessary)<br />
<br />
<b>category_to_product_lookup</b><br />- id<br />- category_id<br />- product_id<br />
<br />
<br />
<b>categories</b><br />- category_id<br />- title<br /><br /><br />
<b>customers</b><br />- customer_id<br />- billing_address_line1<br />- billing_address_line2<br />- billing_city<br />- billing_state<br />- billing_zip<br />- phone<br />- firstname<br />- lastname<br />- email address<br />- credit card (number, name, ccc, exp date, type)<br />- shipping_address_line1<br />- shipping_address_line2<br />- shipping_city<br />- shipping_state<br />- shipping_zip<br />
<br />
<br />
<br />
<br />
<br />whatawhalehttp://www.blogger.com/profile/11475173156291726019noreply@blogger.com0tag:blogger.com,1999:blog-6070715760375615251.post-90258303027212398342013-01-14T08:22:00.002-08:002013-01-14T09:34:50.638-08:00Week 2 - Class NotesExample Project:<br />
Product = Song<br />
parameters: title, length, artist, price, year, album, genre<br />
<br />
The more detailed the better.whatawhalehttp://www.blogger.com/profile/11475173156291726019noreply@blogger.com0tag:blogger.com,1999:blog-6070715760375615251.post-5243247396436103162010-10-05T15:25:00.001-07:002013-01-08T19:20:55.205-08:00Week 1 - Class Notes<b>Suppliers</b><br />
Your Price Point<br />
Customer Relations<br />
The Back End<br />
<br />
<b>Desirable Capabilities</b><br />
- Gift Sending<br />
- Affliliate Programs<br />
- Special Discounts<br />
<br />
<br />
<br />
<b>Alexa </b><br />
<a href="http://www.alexa.com/">http://www.alexa.com/</a><br />
<br />
<br />
<b>15 Common Mistakes of eCommerce Design </b><br />
<a href="http://uxdesign.smashingmagazine.com/2009/10/08/15-common-mistakes-in-e-commerce-design-and-how-to-avoid-them/">http://uxdesign.smashingmagazine.com/2009/10/08/15-common-mistakes-in-e-commerce-design-and-how-to-avoid-them/ </a><br />
<br />
- Lack detailed product information<br />
- Hides contact information<br />
- Long and confusing check out process <br />
- Requiring an account to order<br />
- Inadequate site search engine<br />
- Tiny product images<br />
- Only 1 product image <br />
- Poor shopping cart design<br />
- Lack of payment options (authorize.net, paypal, google wallet)<br />
- Not including related products<br />
- Not including shipping rates<br />
<br />
<br />
<br />
<br />
http://www.freepeople.com/vintage-loves/<br />
http://www.toms.com/<br />
<br />
<br />
<b>Lab </b><br />
Samy camera nikon d600<br />
18-300 milimeter lens<br />
camera bag lowepro<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqZEkVmRfhmr6QnVvTclvCTLeDArc_hho2nT70xkJHtE3m2DyXcGPCYwlJGyOBNh8QMOFEmnZUF6aE0pCSPWA3wUitqFKHM1W-oE3ukwyY5shqaBi4HyhwoYcS3vzz9ZSvyvHyZbVuBzk/s1600/nikon3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqZEkVmRfhmr6QnVvTclvCTLeDArc_hho2nT70xkJHtE3m2DyXcGPCYwlJGyOBNh8QMOFEmnZUF6aE0pCSPWA3wUitqFKHM1W-oE3ukwyY5shqaBi4HyhwoYcS3vzz9ZSvyvHyZbVuBzk/s320/nikon3.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhThQTNEgqCVfIvikCkGQZMMKj-FToeMBNpArfN4AZHuRkC3cPjdJgfGlyEQ9eU6qiF2cjaTlwEB6l-Wc7hzcAAFUvwfdT2eEtQao_v2f3zjpcWlU7vahivbKs2JNFufQpozgg3Dou7z1E/s1600/nikon2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhThQTNEgqCVfIvikCkGQZMMKj-FToeMBNpArfN4AZHuRkC3cPjdJgfGlyEQ9eU6qiF2cjaTlwEB6l-Wc7hzcAAFUvwfdT2eEtQao_v2f3zjpcWlU7vahivbKs2JNFufQpozgg3Dou7z1E/s320/nikon2.jpg" width="246" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpD8qjvsE0CvaOQiwM2hE79MZbMhDCxzPr8f3g6-7E0qNhkNHX2qjx-i3GFktfDop58p2LcwG4iOkeq-Fu3NuFvdAc44Wn_MEFNXW3_qHN6f_Gf_v6lXKwzbRRyKZ6571mVNX8ZMhKllc/s1600/nikon5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpD8qjvsE0CvaOQiwM2hE79MZbMhDCxzPr8f3g6-7E0qNhkNHX2qjx-i3GFktfDop58p2LcwG4iOkeq-Fu3NuFvdAc44Wn_MEFNXW3_qHN6f_Gf_v6lXKwzbRRyKZ6571mVNX8ZMhKllc/s320/nikon5.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjchbiiaKPpu_SL9TRV18xxtygGCczEl41bez0nTIYyfNmhHWZCC6jjd2DjaXLfLF0BL2SKJW9oQ0p84IQLLGgrzjCrr4ERR4W6tB_b9UWa_d32rDmURTfZfmEFNRXKlvF_6GAlmrLKtWI/s1600/nikon1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjchbiiaKPpu_SL9TRV18xxtygGCczEl41bez0nTIYyfNmhHWZCC6jjd2DjaXLfLF0BL2SKJW9oQ0p84IQLLGgrzjCrr4ERR4W6tB_b9UWa_d32rDmURTfZfmEFNRXKlvF_6GAlmrLKtWI/s320/nikon1.jpg" width="238" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRTAk9YmJjRCOz2u1h1BBGasYD8iDwEPTthBBX9erMXyrdaXYo_9dH-t7rhhWYgVi3Q3u14lPdRQk1NqdWr6aTb9xizeLLyoYXYD5uweq7WLP2Urezxg-l-gxRw_QUYH0uxDU_TKvIXFM/s1600/bag1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRTAk9YmJjRCOz2u1h1BBGasYD8iDwEPTthBBX9erMXyrdaXYo_9dH-t7rhhWYgVi3Q3u14lPdRQk1NqdWr6aTb9xizeLLyoYXYD5uweq7WLP2Urezxg-l-gxRw_QUYH0uxDU_TKvIXFM/s320/bag1.jpg" width="284" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-LDkkyzKZ59QAl6W7XFmGi4q8AzPZlc6yXpQhIEbmWSUdI55UDizeYaCbtrOJFSN-SI3Mu2A3-1G49UyKqV3uMFlRnjR4qgM6L9fWWGjqRUNw5nBS-9d6DnWQ7Spw67aW0IlBI6luHhc/s1600/bag.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="253" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-LDkkyzKZ59QAl6W7XFmGi4q8AzPZlc6yXpQhIEbmWSUdI55UDizeYaCbtrOJFSN-SI3Mu2A3-1G49UyKqV3uMFlRnjR4qgM6L9fWWGjqRUNw5nBS-9d6DnWQ7Spw67aW0IlBI6luHhc/s320/bag.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-y0HKHth42mUQIlc4YJ3-vlqYjOgj5UP0Vdzn8jzIkpKVqLA71IcAzHnA2AXoOA32OdduGQbw9zFGLo6uOy3XsK5mHv2cZMYBXJiPriwTPCqoyj8-vTkw_u8oI5P5hyphenhyphenqw-c3ZxgS4LGI/s1600/bag33.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-y0HKHth42mUQIlc4YJ3-vlqYjOgj5UP0Vdzn8jzIkpKVqLA71IcAzHnA2AXoOA32OdduGQbw9zFGLo6uOy3XsK5mHv2cZMYBXJiPriwTPCqoyj8-vTkw_u8oI5P5hyphenhyphenqw-c3ZxgS4LGI/s320/bag33.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjFyM9v3gTqW8GUD5fkz1hBGx0s1NHx5DGx5k1cFwZTsfhUWG0RnQeOW7V5HGKjKUbdUIu9AVqQAWeuVELRKpsKzSmtjI27opGsrg2fN91EQKQJES-z5yuPXnt7pi3ugECF4QiNSnI7Ug/s1600/checkout1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjFyM9v3gTqW8GUD5fkz1hBGx0s1NHx5DGx5k1cFwZTsfhUWG0RnQeOW7V5HGKjKUbdUIu9AVqQAWeuVELRKpsKzSmtjI27opGsrg2fN91EQKQJES-z5yuPXnt7pi3ugECF4QiNSnI7Ug/s320/checkout1.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrTIkPfhL6lZHadL2IkDXEz9aZ6MwfHp2BSV3OzcX65cuGvEXL0eIChA05dYWHiZ2_ZEInAc15UVe94CFY0kuL0rYXDKjeV3isLSItpJDAOmLy1Tw1rilO0oVDYlWrVcrILv6WxR24jBY/s1600/checkout.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="264" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrTIkPfhL6lZHadL2IkDXEz9aZ6MwfHp2BSV3OzcX65cuGvEXL0eIChA05dYWHiZ2_ZEInAc15UVe94CFY0kuL0rYXDKjeV3isLSItpJDAOmLy1Tw1rilO0oVDYlWrVcrILv6WxR24jBY/s320/checkout.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKmSjR3Qr5K5q9oH3HmtGo_0H0NgPJuoaKuXPVcXsjWfSpyHU1yva9KRf6256xE-cHiLoMvTKHbgpGj2Bn2o_T7gn0JYn-lmOEaVDE5OzehlqSACfusXBlWIY6cmnXhOCyCVzy2naNHBY/s1600/bag3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKmSjR3Qr5K5q9oH3HmtGo_0H0NgPJuoaKuXPVcXsjWfSpyHU1yva9KRf6256xE-cHiLoMvTKHbgpGj2Bn2o_T7gn0JYn-lmOEaVDE5OzehlqSACfusXBlWIY6cmnXhOCyCVzy2naNHBY/s320/bag3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
http://www.etsy.com/blog/en/2012/featured-shop-paulova/</div>
<div class="separator" style="clear: both; text-align: left;">
http://www.etsy.com/listing/89159505/moss-green-dinosaur-planter-modern?ref=v1_other_1</div>
http://www.etsy.com/shop/VanessaBullick<br />
http://www.fullcircle.com/organic-produce-groceries/pricing/#s.ad7oqrspibaaa<br />
<br />
http://icondock.com/icons/checkout whatawhalehttp://www.blogger.com/profile/11475173156291726019noreply@blogger.com0