PHP and MySQL Programming Principles

4.5 Average Customer Rating

Create a Website with PHP & MySQL

Start Free Trial
  • 86 Videos
  • 8 hours 53 minutes
  • 12825 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
  • 12825 Happy Students
Start Free Trial

Your 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!
Kevin Yank
6 Courses

Customer Reviews

  • ()
    5 stars
    4 stars
    3 stars
    2 stars
    1 stars

    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
    Start Free Trial
    • 86 Videos
    • 8 hours 53 minutes
    • 12825 Happy Students