PHP and MySQL Programming Principles

4.5 Average Customer Rating

Create a Website with PHP & MySQL

  • 86 Videos
  • 8 hours 53 minutes
  • 12805 Happy Students

About the course

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

  • 86 Videos
  • 8 hours 53 minutes
  • 12805 Happy Students

Courses Outline

Lesson 1: Installing PHP & MySQL
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
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)
2:11
Week 3 Q&A Session B (Part 2)
48:06
  • 86 Videos
  • 8 hours 53 minutes
  • 12805 Happy Students