 64 Reviews Add a review

PHP & MySQL Web Development for Beginners

8h 53m
March 2011
Library / PHP / PHP & MySQL Web Development for Beginners

What you'll learn

  • The basics of PHP and MySQL and how they’re used
  • Insert and delete data from the database
  • Expand your skills into server-side programming
  • Intermediate
  • Closed captions available

Join SitePoint Premium for instant access

Start 14 day trial

Create a Website with PHP & MySQL

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

★★★★★
I rated this course 5 stars because it deserves it. I started this course with some self taughtPHP and no MySQL. Thanks to this course I actually saw how the basic PHP tried in with the MYSQL. I did do alot of extra reading, both in Kevin's book and on the web. Kevin's book coupled with his lectures would have been excellent on there own. Great Instructor who presents the material in an easy to understand format and in just the right size.

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) 2:11
Week 3 Q&A Session B (Part 2) 48:06

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!


Reviews

Our algorithm thinks you'll like

Database Access with PHP

Lami Ada

Make your applications data driven