1. Library
  2. Course
  3. PHP

PHP and MySQL Programming Principles

  • By 

12829 Happy Students

4.5 Average Customer Rating
(from 82 user reviews)

Create a Website with PHP & MySQL

PHP and MySQL Programming Principles
Play button
  • 86 Videos
  • 8 hours 53 minutes
  • 12829 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
  • 12829 Happy Students

What students say..

I'm not a beginner, but needed a brush up. I was extremely pleased with this course. The teacher is highly engaging and has great communication skills. It also seems that the contents are well structured. I definitely recommend taking this course if you need to learn PHP and MySQL. I also loved that this course not only used a table but one-to-many and many-to-many relational tables as practical examples. I had a very hard time with trying to learn this many years ago and this course might have made that part much easier for me.
Gita Street Kristiansen
Gita Street Kristiansen
Kevin Yank is GREAT at explaining. I enjoyed watching and, ESPECIALLY, listening his explanations of the course contents. This course of high quality and was definitely WORTH my time and effort.
Anfilov Aleksandr
Anfilov Aleksandr

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
PHP and MySQL Programming Principles
Play button
  • 86 Videos
  • 8 hours 53 minutes
  • 12829 Happy Students