★★★★⋆ (30 reviews)

PHP & MySQL Web Development for Beginners

Create a Website with PHP & MySQL
Start a premium membership and access all ebooks and courses.
8h 55m
Release date:
March 2, 2011
Closed captions available
Beginner

Under the expert guidance of SitePoint’s own Kevin Yank, you’ll find the combination of digestible audio, video and mini-articles with a supportive forum of classmates to be so much fun, you won’t even realise how much you’ve learned by the time you’re done.

“I am a couple of days away from finishing your PHP course which is brilliant. I had never done any website stuff ever before and just did it out of curiosity. I thought it would all be vastly complicated but it is so easy to follow and now I know how it all works, the way you taught it is faultless.” —Jamie Robinson, Student

Course Contents

Lesson 1: Installing PHP & MySQL
Free Welcome to PHP & MySQL Web Development for Beginners 1:48
Free Download today's code
Free Introducing PHP & MySQL
Free Your Own Web Server
PHP & MySQL Windows Installation 8:54
Free PHP & MySQL Mac Installation 6:00
Your First PHP Script
Join a Discussion: Introduce Yourself!
Join a Discussion: Your Tools of Choice
Lesson 2: Your First Database
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
Lesson 3: Introducing PHP
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
Lesson 4: PHP Language
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?
Lesson 5: Recorded Q&A
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
Lesson 6: Displaying MySQL Content
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?
Lesson 7: Adding and Removing Content with PHP
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?
Lesson 8: Database Design: Multi-table Queries
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
Lesson 9: Database Design: Complex Relationships
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
Lesson 10: Recorded Q&A
Week 2 Q&A Session A 58:06
Week 2 Q&A Session B 1:02:14
Lesson 11: Structured PHP Programming
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
Lesson 12: A Content Management System (#1)
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
Lesson 13: A Content Management System (#2)
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
Lesson 14: Sessions and Access Control
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
Lesson 15: Recorded Q&A
Week 3 Q&A Session A 1:13:22
Week 3 Q&A Session B (Part 1) 4:45
Week 3 Q&A Session B (Part 2) 48:06

Instructor

Kevin Yank Kevin Yank is a world-renowned author, speaker and JavaScript expert. He has a passion for making web technology easy to understand by anyone. Yes, even you!