O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PHP and MySQL (Video Training)

Video Description

For every developer who wants to build production-quality applications using PHP and MySQL. 

In this one-of-a-kind video package, top Web developer and Prentice Hall author Marc Wandschneider shows you exactly how to build reliable, secure, industrial-strength Web applications with PHP and MySQL. You’ll master both PHP and MySQL through 18 comprehensive video lessons, and you’ll have your first PHP/MySQL application running in less than an hour.

Wandschneider shows how to set up PHP on Windows and Mac OS X and then builds your skills by walking you through actual application development projects. Just click, watch, and learn efficient ways to implement user account creation, form validation, cookie and session management, file upload/download, and much more.

Everything’s taught visually, using sample applications ranging from a simple calculator to a full-fledged photo sharing site, and all the sample can be downloaded under the related files link.  Programming challenges at the end of each lesson teach you how to take your skills to the next level.  You’ll master essential PHP and MySQL best practices at your own pace and learn how to deliver production-quality PHP/MySQL solutions faster and more effectively.

LiveLessons: Video Instruction from Technology Experts

Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts. 

  • LiveLessons are video courses that are organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as fifteen minutes!

  • Each lesson begins with well-defined learning objectives so you know exactly what you will learn in the lesson.

  • Follow along as your instructor shows exactly how to get great results in your real-world environment.

  • Table of Contents

    1. LiveLessons Introduction
      1. LiveLessons Introduction 00:03:48
    2. Lesson 1: Installing PHP
      1. Learning Objectives 00:02:01
      2. Installing Apache, PHP5, and MySQL on Windows 00:13:26
      3. Installing Apache, PHP5, and MySQL on Macintosh 00:22:22
    3. Lesson 2: Your First Web Application
      1. Learning Objectives 00:01:45
      2. Getting Started: Creating the "Hello, World!" Application 00:06:25
      3. Language Features: Entering PHP Script 00:09:16
      4. Practical PHP: Intro to Variables 00:09:52
      5. Building our Web Application 00:06:05
      6. Challenge: Change the Text in our Application to Look Different and Form Name 00:02:48
    4. Lesson 3: Language Basics
      1. Learning Objectives 00:01:54
      2. Language Features: Arrays, Expansion, Arithmetic Operators 00:14:00
      3. Practical PHP: Type Conversions 00:15:49
      4. Building our Web Application 00:04:41
      5. Challenge: Change Style of our Application 00:02:36
    5. Lesson 4: More PHP Language Features
      1. Learning Objectives 00:01:52
      2. Language Features: Formatting, Script Lifetime and Constants 00:11:24
      3. Practical PHP: Function Parameters, Variables, and Scoping 00:10:50
      4. Building our Web Application 00:03:36
      5. Challenge: Add Integer Division to our Calculator 00:02:18
    6. Lesson 5: Functions and Loops
      1. Learning Objectives 00:01:57
      2. Language Features: Functions and Loops 00:10:57
      3. Practical PHP 00:12:00
      4. Building our Web Application 00:04:16
      5. Challenge: Add Cubed Root Functionality to our Calculator App, Update power_of 00:02:39
    7. Lesson 6: Text and Strings
      1. Learning Objectives 00:01:56
      2. Language Features: Review of String Features Thus Far 00:10:48
      3. Practical PHP: Working with Strings 00:08:59
      4. Building our Web Application 00:08:43
      5. Challenge: Add Octal Notation Support 00:03:05
    8. Lesson 7: Arrays
      1. Learning Objectives 00:02:03
      2. Language Features: More on Arrays and Variable Expansion 00:10:33
      3. Practical PHP: Working with your Arrays and Managing Code 00:14:44
      4. Building our Web Application 00:06:12
      5. Challenge: Model an Image or Photo Object for an Application 00:02:32
    9. Lesson 8: Object Oriented Programming I
      1. Learning Objectives 00:01:57
      2. Language Features: Creating New Types, Object Oriented Programming 00:10:06
      3. Practical PHP: Making our Objects More Robust and Easier to Use 00:07:32
      4. Building our Web Application 00:08:47
      5. Challenge: Convert the Lesson 7 Photo Array / Funcs to be an Object Class 00:02:03
    10. Lesson 9: Object Oriented Programming II
      1. Learning Objectives 00:02:12
      2. Language Features: Even Better Code Re-use with Inheritance 00:08:30
      3. Practical PHP: Further Refining our Page Class Hierarchy 00:06:47
      4. Building our Web Application 00:05:16
      5. Challenge: Write Skeletons for a Login Page 00:01:57
    11. Lesson 10: Object Oriented Programming III
      1. Learning Objectives 00:02:01
      2. Language Features: Making our Objects More Flexible and Reusable 00:12:36
      3. Practical PHP: Structured Exception Handling 00:13:03
      4. Building our Web Application 00:03:36
      5. Challenge: Update your Photo Class to use SEH and Implement a _toString Method 00:02:00
    12. Lesson 11: Learning More About the Web Server
      1. Learning Objectives 00:01:59
      2. Language Features: Taking a Closer Look at HTML Forms and Elements 00:10:37
      3. Practical PHP: Processing Forms on the Server 00:07:51
      4. Building our Web Application 00:08:07
      5. Challenge: Add Extra Data to the User's Object and Add to Input Page 00:01:55
    13. Lesson 12: Designing and Creating your Database
      1. Learning Objectives 00:01:57
      2. Language Features: Beginning Work with Databases 00:12:17
      3. Practical PHP: Accessing our Data from within PHP 00:09:23
      4. Building our Web Application 00:06:52
      5. Challenge: Add Extra Fields to User Table and Modify Forms and Pages to Support This 00:02:02
    14. Lesson 13: Fetching Data from the Database
      1. Learning Objectives 00:01:56
      2. Language Features: Working with our Databases 00:12:34
      3. Practical PHP: Further Massaging our Returned Data 00:10:54
      4. Building our Web Application 00:07:22
      5. Challenge: Sort View All Users Page, and also Support Reverse Sorting 00:01:58
    15. Lesson 14: Modifying Data in the Database
      1. Learning Objectives 00:02:08
      2. Language Features: Modifying Data in the DB 00:07:49
      3. Practical PHP: FULLTEXT Data, Joins, and Transactions 00:12:41
      4. Building our Web Application 00:09:12
      5. Challenge: Create a Change Password Form 00:02:06
    16. Lesson 15: Remembering Things: Cookies and Sessions
      1. Learning Objectives 00:01:59
      2. Language Features: Moving Data with the User: Cookies 00:10:52
      3. Practical PHP: Sessions and FULLTEXT Searching 00:09:47
      4. Building our Web Application 00:09:09
      5. Challenge: Make Sure Users Can Only See Certain Pages if They're Logged In 00:02:57
    17. Lesson 16: Files and File Uploads
      1. Learning Objectives 00:01:52
      2. Language Features: Uploading Files 00:11:15
      3. Practical PHP: Working with Files on the Server 00:08:35
      4. Building our Web Application 00:11:36
      5. Challenge: Add a Description to the Photo in our Application 00:03:12
    18. Lesson 17: Formatted Output, Output Buffering and Security
      1. Learning Objectives 00:01:55
      2. Language Features: Formatted Output and Output Buffering 00:11:03
      3. Practical PHP: Looking at Security 00:10:34
      4. Building our Web Application 00:09:17
      5. Challenge: Add Output Formatting to our App 00:02:28
    19. Lesson 18: When Things Go Wrong
      1. Learning Objectives 00:01:57
      2. Language Features: Reviewing Errors 00:13:18
      3. Practical PHP: More Error Handling 00:11:04
      4. Building our Web Application 00:03:12
      5. Challenge: Add Exception Logging to our Application 00:02:02