Shopping Cart Using PHP and MySQL

Shopping Cart Using PHP and MySQL online course
Class Name

Shopping Cart Using PHP and MySQL

The course will demonstrate how to build a shopping cart from scratch. Participants will learn intermediate to advanced use of PHP and MySQL, particularly the use of cookies and sessions to maintain state, and the security aspects of coding for e-commerce sites, or any other site handling sensitive information.

Applicable Job Roles: web programmers, and web application developers.

Outline
Week 1
  • Review of PHP knowledge (especially array handling and MySQL functions)
  • Review of MySQL knowledge
  • Good coding practices
  • Writing functions: students will develop their own functions to access and query a MySQL database
Week 2:
  • Working with arrays: useful PHP functions and how to use them
  • Create and populate the database
  • Output a simple list of products with images
Week 3:
  • Understand the concept of 'statelessness'
  • System design: techniques for determining the system flow for the application
  • Building a wireframe of the application
  • Setting up the coding environment: templates, include files, libraries
Week 4:
  • Using sessions in PHP
  • Building the cart: adding, removing, and changing quantities
  • Viewing the cart
Week 5:
  • Future-proofing your code: good practice
  • More on sessions: security
  • The checkout process: calculate simple shipping and tax, build checkout form
Week 6:
  • Validating user input using classes for extensible, re-usable code
  • Preparing data for insertion to the database
  • Updating the database
Week 7:
  • Interfacing with a payment processor for online credit card payments
  • Using a class to send emails to merchant and customer
  • Security considerations
Week 8:
  • Final review of cart
  • Error handling
  • Enhancing the cart
  • Don't Repeat Yourself: using libraries and classes to encapsulate and re-use code
Prerequisites
'Introduction to PHP' course (P100) or equivalent knowledge is required. Some basic knowledge of SQL is useful
Requirements
Access to a webhost running PHP (at least version 5.x) and MySQL (version 5.x). Students may choose to load PHP and MySQL on their local systems, but this is not necessary. If a student chooses to do a local installation, she or he should understand that debugging installations is not within the scope of this course and that assignments must still be posted in working order to an accessible online account for grading.
Class Books
Course Price
  • Member Price: $200 US
  • Non-Member Price: $300.00 US
[Register Now]

Additional Information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page.

How eClasses Work:Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

  • Member Price: $200 US
  • Non-Member Price: $300.00 US
  • Web Course No: P104
  • Instructor: Veronica Yuill
  • Co-instructor/TA:
  • CEUs: 4
  • Duration: 8 weeks
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Intro to DreamweaverAdvanced DreamweaverBuilding Data-Driven Websites with Adobe Dreamweaver
Advanced Adobe FlashIntro to FlashAdobe Fireworks
Adobe Flash Level IIWeb VideographyContracting Your Services
Intro to Apache AdministrationBlog and Article WritingWeb Content Writing
Intro to DNSIntro to UNIXIntro to Web Analytics
WordPress Theme DesignIntro to WordPressIntro to Drupal
Project ManagementIntro to Joomla!Intermediate Joomla!
Logo DesignWebsite Project ManagementLegal Issues for Web Designers and Content Managers
Search Engine OptimizationWebsite PromotionEmail Marketing and Strategies
Social Media MarketingIntro to Designing Accessible WebsitesDesign Concepts
Intro to Web DesignIntro to Adobe MuseMobile Application UI Design
Photoshop Level 1Photoshop for the WebPhotoshop Retouching
InDesign Level 1Adobe IllustratorAdobe Illustrator Level 2
Intro to Adobe Edge AnimateIntro to HTMLHTML Level 2
Mobile Web DesignHTML5 IntroIntro to Cascading Style Sheets
Intermediate CSS WorkshopCSS 2.1 in DepthIntro to CSS3
Intro to XHTMLIntro to Database DesignIntro to SQL (Using Access)
Intro to SQL (Using MySQL)MySQLIntro to SQL Server
Intro to Programming ConceptsIntro to PHPShopping Cart Using PHP and MySQL
Intro to JSPIntro to ColdFusion Web DevelopmentIntermediate ColdFusion
Intro to JavaScriptIntermediate JavaScriptIntro to AJAX
Intro to jQueryJava for Non-ProgrammersProgramming in Java - Intro
Intermediate Java ProgrammingIntro to PerlIntro to C#
Intro to ASP.NET Web Development with C#Intro to Visual Basic.NETIntro to ASP
Intermediate ASPIntermediate ASP.NET Web Development with C#Intro to Web Security
Intro to XMLIntermediate XMLIntro to Android App Development
Intro to Game ProductionIntro to Game Design and DevelopmentIntro to Flash Game Programming
Intro to C++ Using GamesIntro to Windows Game Programming Using C++3D Game Programming Using DirectX