PHP and MySQL (video training)

This is a comprehensive, practical guide for programmers who want to develop production-quality, database-enabled web applications with PHP and MySQL. Long-time developer Marc Wandschneider systematically addresses the entire process: not only coding, but also upfront application, user interface and database design, PLUS security, testing, and more. You'll walk through building three applications from start to finish: a calendaring system, a weblog engine, and an e-commerce store. Along the way, you'll master essential strategies for creating robust web database applications and learn how to avoid the common pitfalls that trip up many developers moving to PHP and MySQL.

'

Lesson 1: Installation of MySQL, Apache, and PHP 1

Windows 1

Mac / Unix 2

Lesson 2: Your First Web Application 7

Getting Started 7

Entering PHP Scripts 8

Variables 11

Variables 11

Working with Multiple Pages 13

Lesson 3: Language Basics 15

Arrays 15

Testing Variables 15

Simple Variable Substitution 16

Arithmetic Operators 16

Type Conversions 17

NULL 18

The if Statement 18

Comparison Operators: Equality and Identity 18

Lesson 4: More Language Features 21

Script Lifetime 21

Strings, Newlines, and the Web Browser 21

Constants 22

More Comparison Operators 22

Logical Operators 22

The switch Stateme