About N413

N413 Course Schedule

  • Introduction
    • The Full Stack: MySQL/PHP/HTML System Architecture
    • Designing a web app
    • MAMP-XAMPP/phpMyAdmin Demo
    • The TABLE
  • Database-to-Browser
    • The Connection Script
    • The SELECT Query
    • The Result
    • "Echo"-ing to the browser
    • Design strategies for PHP and HTML
    • Drawing a List
  • Forms and User Data
    • A Simple Form
    • POST/GET/REQUEST
    • Sanitizing Untrusted Data
    • The INSERT Query
    • Contact Form Project
  • Building a Site(Part 1)
    • A Landing Page
    • Reusable Code:The <head> Section
    • Introducing Bootstrap
    • The Nav-Bar
    • Pull it Together
    • The Site Project
  • Building a Site(Part 2)
    • Introducing jQuery
    • $(document).ready()
    • Bootstrap Revisions
    • Data Attributes
    • Event Listeners
    • The List-Detail Page Pattern
  • Accounts & Log-ins
    • "For Your Eyes Only" Privileged Content
    • The Users Table
    • Log-in Form
    • PHP Sessions
    • "Do we have a log-in?": The User ID
    • Drawing Conditional HTML
    • User Preferences and Personalizing Content
    • The Account Project
    • PROJECT PROPOSALS
  • Encryption and Security
    • Encryption Algorithms
    • PHP Password Hash
    • Authenticating Log-Ins
    • User Interfaces for Forgotten Passwords
    • Secure Password Resets
    • PHP mail()
    • The Secure Account Project
    • PROJECT PROTOTYPES
  • Model-View-Controller
    • Design Patterns
    • MVC and application design
    • The CodeIgniter Framework
    • Setting up CodeIgniter
    • Organizing the Project
    • A Simple CodeIgniter Example
    • Converting the Site Project
    • The CodeIgniter Project
    • PROJECT PLANNING DOCUMENTS
  • SPRING/FALL Break
  • AJAX
    • What is AJAX?
    • jQuery submit() Handlers: preventDefault()
    • jQuery AJAX Methods: $.post()
    • PHP, AJAX, and JSON
    • The Callback Function
    • Redrawing the Page with JSON data
    • Design Patterns With AJAX, CodeIgniter, JSON, and jQuery
    • The AJAX Project
    • FINALIZED PROJECT PLANS
  • Project Reviews I
    • Project Troubleshooting and Feedback
    • Student Presentations on Javascript Libraries/Plug-ins
  • Project Reviews II
    • Project Troubleshooting and Feedback
    • Student Presentations on Javascript Libraries/Plug-ins
    • Developing a User Test
  • User Testing Day
    • Students Conduct User Tests
  • Project Reviews III
    • User Testing Results
    • Project Troubleshooting and Feedback
    • Course Review
  • Final Project Presentations