PHP and MySQL Programming Principles

Lesson 1, Step 1: Welcome to PHP & MySQL Web Development for Beginners

Courses Outline

Free
Welcome to PHP & MySQL Web Development for Beginners
1:48
Download today's code
Introducing PHP & MySQL
Your Own Web Server
PHP & MySQL Windows Installation
8:54
PHP & MySQL Mac Installation
6:00
Your First PHP Script
Join a Discussion: Introduce Yourself!
Join a Discussion: Your Tools of Choice
Welcome to PHP & MySQL Web Development for Beginners Lesson 2
1:03
An Introduction to Databases
Using phpMyAdmin to Execute SQL (Part 1)
3:17
Using phpMyAdmin to Execute SQL (Part 2)
9:13
SQL Basics
Join a Discussion: Add Some More Jokes and Share Them
Welcome to PHP & MySQL Web Development for Beginners Lesson 3
0:59
Download today's code
A Closer Look at today.php
9:30
PHP Variables, Operators, and Comments
PHP Arrays
Passing Variables in Links
htmlspecialchars
9:56
Passing Variables in Forms
Join a Discussion: Pass a Variable to a Third Page
Welcome to PHP & MySQL Web Development for Beginners Lesson 4
0:35
Download Today's Code
PHP Conditional Statements
PHP Loops
Hiding the Seams
4:50
PHP Templates
8:50
Controllers and Templates
Join a Discussion: Any Questions?
Recorded Live Q&A Sessions
Week 1 Q&A Session A
1:04:49
Week 1 Q&A Session B
1:00:56
Week 1 Challenge Solution
Welcome to PHP & MySQL Web Development for Beginners Lesson 6
2:35
Download Today's Code
Creating a MySQL User
7:15
Connecting to MySQL with PHP
9:56
Sending SQL Queries with PHP
Handling SELECT Result Sets
Join a Discussion: Any Questions?
Welcome to Lesson 7 of PHP & MySQL Web Development for Beginners
1:18
Download Today's Code
Inserting Data into the Database
Deleting Data from the Database
Join a Discussion: Editing Existing Jokes?
Welcome to Lesson 8 of PHP & MySQL Web Development for Beginners
4:23
Download Today's Code
Rule of Thumb: Keep Entities Separate
SELECT with Multiple Tables
8:55
Join a Discussion: Challenge - Update joke list to display author info
Welcome to PHP & MySQL Web Development for Beginners Lesson 9
0:52
Simple Relationships
8:08
Many-to-Many Relationships
Join a Discussion: Challenge - Update joke database to include categories
Week 2 Q&A Session A
58:06
Week 2 Q&A Session B
1:02:14
Welcome to Lesson 11 of PHP & MySQL Web Development for Beginners
1:22
Download Today's Code
Including HTML Content and PHP Code
7:11
Types of Includes
Custom Functions
7:51
Variable Scope and Global Access
Template Helpers
7:55
Join a Discussion: Visit the Course Forum
Welcome to Lesson 12 of PHP & MySQL Web Development for Beginners
3:40
Download Today's Code
The Front Page
5:55
Managing Authors
Join a Discussion: Challenge - Managing Categories
Welcome to Lesson 13 of PHP & MySQL Web Development for Beginners
2:11
Download Today's Code
Managing Jokes
Join a Discussion: Visit the Course Forum
Welcome to Lesson 14 of PHP & MySQL Web Development for Beginners
2:00
Download Today's Code
Session Basics
9:10
Access Control: The Database
Access Control: The PHP Code
Challenge: Joke Moderation
8:05
Join a Discussion: Visit the Course Q&A System
Week 3 Q&A Session A
1:13:22
Week 3 Q&A Session B (Part 1)
2:11
Week 3 Q&A Session B (Part 2)
48:06