SitePoint
  • Premium
  • Library
  • Community
  • Jobs
  • Blog
LoginStart Free Trial
PHP and MySQL Programming Principles
Welcome to PHP & MySQL Web Development for Beginners
Download today's code
Introducing PHP & MySQL
Your Own Web Server
PHP & MySQL Windows Installation
PHP & MySQL Mac Installation
Your First PHP Script
Join a Discussion: Introduce Yourself!
Join a Discussion: Your Tools of Choice
Welcome to PHP & MySQL Web Development for Beginners Lesson 2
An Introduction to Databases
Using phpMyAdmin to Execute SQL (Part 1)
Using phpMyAdmin to Execute SQL (Part 2)
SQL Basics
Join a Discussion: Add Some More Jokes and Share Them
Welcome to PHP & MySQL Web Development for Beginners Lesson 3
Download today's code
A Closer Look at today.php
PHP Variables, Operators, and Comments
PHP Arrays
Passing Variables in Links
htmlspecialchars
Passing Variables in Forms
Join a Discussion: Pass a Variable to a Third Page
Welcome to PHP & MySQL Web Development for Beginners Lesson 4
Download Today's Code
PHP Conditional Statements
PHP Loops
Hiding the Seams
PHP Templates
Controllers and Templates
Join a Discussion: Any Questions?
Recorded Live Q&A Sessions
Week 1 Q&A Session A
Week 1 Q&A Session B
Week 1 Challenge Solution
Welcome to PHP & MySQL Web Development for Beginners Lesson 6
Download Today's Code
Creating a MySQL User
Connecting to MySQL with PHP
Sending SQL Queries with PHP
Handling SELECT Result Sets
Join a Discussion: Any Questions?
Welcome to Lesson 7 of PHP & MySQL Web Development for Beginners
Download Today's Code
Inserting Data into the Database
Deleting Data from the Database
Join a Discussion: Editing Existing Jokes?
Welcome to Lesson 8 of PHP & MySQL Web Development for Beginners
Download Today's Code
Rule of Thumb: Keep Entities Separate
SELECT with Multiple Tables
Join a Discussion: Challenge - Update joke list to display author info
Welcome to PHP & MySQL Web Development for Beginners Lesson 9
Simple Relationships
Many-to-Many Relationships
Join a Discussion: Challenge - Update joke database to include categories
Week 2 Q&A Session A
Week 2 Q&A Session B
Welcome to Lesson 11 of PHP & MySQL Web Development for Beginners
Download Today's Code
Including HTML Content and PHP Code
Types of Includes
Custom Functions
Variable Scope and Global Access
Template Helpers
Join a Discussion: Visit the Course Forum
Welcome to Lesson 12 of PHP & MySQL Web Development for Beginners
Download Today's Code
The Front Page
Managing Authors
Join a Discussion: Challenge - Managing Categories
Welcome to Lesson 13 of PHP & MySQL Web Development for Beginners
Download Today's Code
Managing Jokes
Join a Discussion: Visit the Course Forum
Welcome to Lesson 14 of PHP & MySQL Web Development for Beginners
Download Today's Code
Session Basics
Access Control: The Database
Access Control: The PHP Code
Challenge: Joke Moderation
Join a Discussion: Visit the Course Q&A System
Week 3 Q&A Session A
Week 3 Q&A Session B (Part 1)
Week 3 Q&A Session B (Part 2)