PHP and MySQL Programming Principles

Create a Website with PHP & MySQL

Published Date March 2011
86 Videos
8 hours 53 minutes
12771 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

Published Date March 2011
86 Videos
8 hours 53 minutes
12771 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

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

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