Target Student:
PHP Live is aimed at intermediate and advanced web designers looking to make the leap into server-side programming
Prerequisites:
You™ll be expected to be comfortable with simple HTML. No knowledge of Cascading Style Sheets (CSS) or JavaScript is assumed or required, but if you do know JavaScript, you™ll find it will make learning PHP a breeze, since these languages are quite similar.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course Content
Lesson 1: Installing PHP & MySQL
Step 1: Welcome to PHP & MySQL Web Development for Beginners
Step 2: Download today's code
Step 3: Introducing PHP & MySQL
Step 4: Your Own Web Server
Step 5: PHP & MySQL Windows Installation
Step 6: PHP & MySQL Mac Installation
Step 7: Your First PHP Script
Step 8: Join a Discussion: Introduce Yourself!
Step 9: Join a Discussion: Your Tools of Choice
Lesson 2: Your First Database
Step 1: Welcome to PHP & MySQL Web Development for Beginners Lesson 2
Step 2: An Introduction to Databases
Step 3: Using phpMyAdmin to Execute SQL (Part 1)
Step 4: Using phpMyAdmin to Execute SQL (Part 2)
Step 5: SQL Basics
Step 6: Join a Discussion: Add Some More Jokes and Share Them
Lesson 3: Introducing PHP
Step 1: Welcome to PHP & MySQL Web Development for Beginners Lesson 3
Step 2: Download today's code
Step 3: A Closer Look at today.php
Step 4: PHP Variables, Operators, and Comments
Step 5: PHP Arrays
Step 6: Passing Variables in Links
Step 7: htmlspecialchars
Step 8: Passing Variables in Forms
Step 9: Join a Discussion: Pass a Variable to a Third Page
Lesson 4: PHP Language
Step 1: Welcome to PHP & MySQL Web Development for Beginners Lesson 4
Step 2: Download Today's Code
Step 3: PHP Conditional Statements
Step 4: PHP Loops
Step 5: Hiding the Seams
Step 6: PHP Templates
Step 7: Controllers and Templates
Step 8: Join a Discussion: Any Questions?
Lesson 5: Recorded Q&A
Step 1: Recorded Live Q&A Sessions
Step 2: Week 1 Q&A Session A
Step 3: Week 1 Q&A Session B
Step 4: Week 1 Challenge Solution
Lesson 6: Displaying MySQL Content
Step 1: Welcome to PHP & MySQL Web Development for Beginners Lesson 6
Step 2: Download Today's Code
Step 3: Creating a MySQL User
Step 4: Connecting to MySQL with PHP
Step 5: Sending SQL Queries with PHP
Step 6: Handling SELECT Result Sets
Step 7: Join a Discussion: Any Questions?
Lesson 7: Adding and Removing Content with PHP
Step 1: Welcome to Lesson 7 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: Inserting Data into the Database
Step 4: Deleting Data from the Database
Step 5: Join a Discussion: Editing Existing Jokes?
Lesson 8: Database Design: Multi-table Queries
Step 1: Welcome to Lesson 8 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: Rule of Thumb: Keep Entities Separate
Step 4: SELECT with Multiple Tables
Step 5: Join a Discussion: Challenge - Update joke list to display author info
Lesson 9: Database Design: Complex Relationships
Step 1: Welcome to PHP & MySQL Web Development for Beginners Lesson 9
Step 2: Simple Relationships
Step 3: Many-to-Many Relationships
Step 4: Join a Discussion: Challenge - Update joke database to include categories
Lesson 10: Recorded Q&A
Step 1: Week 2 Q&A Session A
Step 2: Week 2 Q&A Session B
Lesson 11: Structured PHP Programming
Step 1: Welcome to Lesson 11 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: Including HTML Content and PHP Code
Step 4: Types of Includes
Step 5: Custom Functions
Step 6: Variable Scope and Global Access
Step 7: Template Helpers
Step 8: Join a Discussion: Visit the Course Forum
Lesson 12: A Content Management System (#1)
Step 1: Welcome to Lesson 12 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: The Front Page
Step 4: Managing Authors
Step 5: Join a Discussion: Challenge - Managing Categories
Lesson 13: A Content Management System (#2)
Step 1: Welcome to Lesson 13 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: Managing Jokes
Step 4: Join a Discussion: Visit the Course Forum
Lesson 14: Sessions and Access Control
Step 1: Welcome to Lesson 14 of PHP & MySQL Web Development for Beginners
Step 2: Download Today's Code
Step 3: Session Basics
Step 4: Access Control: The Database
Step 5: Access Control: The PHP Code
Step 6: Challenge: Joke Moderation
Step 7: Join a Discussion: Visit the Course Q&A System
Lesson 15: Recorded Q&A
Step 1: Week 3 Q&A Session A
Step 2: Week 3 Q&A Session B (Part 1)
Step 3: Week 3 Q&A Session B (Part 2)
Lesson 16: Bonuses
Step 1: Bonuses
