Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 4.454545454545454 out of 5 rating Based on 11 Ratings

"Excelent" - by Aaron_D_R on 25-OCT-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I'm currently about to begin lesson 15, But I've felt compelled to write a review, something I rarely do. My reason for using these video lessons was less of a learning tool and more of a "Ok, Definatly know that now." Type of thing, as Ive been studying PHP and a little mysql for the past 3 weeks, at 5-9 hours a day as I'm jobless so things have moved right along. Back to my point Although using this as a Review tool, Ive learned quite a few things here and their. The teacher is very concise RARELY messes up what he is saying, if he never did it would be like listening to a robot. By messes up I mean, says one wrong key word, then instantly corrects himself, nothing big. For me, some video tutorial teachers / sound quality of the video is annoying. This has been a pleasure to listen to. But to point out 2 things, sometimes its hard to follow him as he moves very fast in explanations of the programs as they get bigger and bigger. At first I thought I just didn't understand the material in the particular video, but sure enough If I rerun the  video and pay extra close attention no distractions , I completely understand what's going on. The second thing I'd like to point out which may just be me, but  he has either, the Technically correct pronounciation for certain words, or just likes saying things different, For instance Zebra = zeb-ra to him, I've always pronounced it Zee-Bra. Giga= jigga to him but to me I thought it was GIG-a. But that last bit isn't anything big I just thought it was funny.(I ususally pronounce things wrong so Its probably me).

OVERALL- Perfect Review material, and you'll learn something too, It may be a good learning tool but as I already know most of PHP syntax and how to use it and basics of MySQL, Its hard for me to judge weather or not this is a good Beginner source, I assume it is , if you don't mind pausing the videos to try out the syntax he teaches.

Report as Inappropriate

"Best Self Learn PHP I have tried" - by Greg on 06-AUG-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I have tried countless books, and all the videos on Safari. This is by far the clearest and best organized. SAM teach yourself in 24 hours is OK, but it is pretty outdated.

Marc took me from knowing almost nothing about PHP to being competent at writing my own basic web applications.


Report as Inappropriate

Table of Contents

Chapter/Selection

Time

LiveLessons Introduction

LiveLessons Introduction

Play Video

00:03:47

Lesson 1: Installing PHP

Learning Objectives

Preview

00:02:00

Installing Apache, PHP5, and MySQL on Windows

Preview

00:13:28

Installing Apache, PHP5, and MySQL on Macintosh

Preview

00:22:24

Lesson 2: Your First Web Application

Learning Objectives

Play Video

00:01:44

Getting Started: Creating the "Hello, World!" Application

Preview

00:06:27

Language Features: Entering PHP Script

Preview

00:09:18

Practical PHP: Intro to Variables

Preview

00:09:53

Building our Web Application

Preview

00:06:04

Challenge: Change the Text in our Application to Look Different and Form Name

Preview

00:02:50

Lesson 3: Language Basics

Learning Objectives

Play Video

00:01:54

Language Features: Arrays, Expansion, Arithmetic Operators

Preview

00:14:01

Practical PHP: Type Conversions

Play Video

00:15:48

Building our Web Application

Preview

00:04:42

Challenge: Change Style of our Application

Preview

00:02:38

Lesson 4: More PHP Language Features

Learning Objectives

Play Video

00:01:52

Language Features: Formatting, Script Lifetime and Constants

Preview

00:11:26

Practical PHP: Function Parameters, Variables, and Scoping

Preview

00:10:52

Building our Web Application

Preview

00:03:38

Challenge: Add Integer Division to our Calculator

Preview

00:02:19

Lesson 5: Functions and Loops

Learning Objectives

Play Video

00:01:57

Language Features: Functions and Loops

Preview

00:10:57

Practical PHP

Preview

00:12:02

Building our Web Application

Preview

00:04:16

Challenge: Add Cubed Root Functionality to our Calculator App, Update power_of

Preview

00:02:40

Lesson 6: Text and Strings

Learning Objectives

Play Video

00:01:55

Language Features: Review of String Features Thus Far

Preview

00:10:50

Practical PHP: Working with Strings

Play Video

00:09:01

Building our Web Application

Preview

00:08:45

Challenge: Add Octal Notation Support

Preview

00:03:07

Lesson 7: Arrays

Learning Objectives

Play Video

00:02:02

Language Features: More on Arrays and Variable Expansion

Preview

00:10:35

Practical PHP: Working with your Arrays and Managing Code

Preview

00:14:45

Building our Web Application

Preview

00:06:14

Challenge: Model an Image or Photo Object for an Application

Preview

00:02:33

Lesson 8: Object Oriented Programming I

Learning Objectives

Play Video

00:01:56

Language Features: Creating New Types, Object Oriented Programming

Preview

00:10:08

Practical PHP: Making our Objects More Robust and Easier to Use

Preview

00:07:34

Building our Web Application

Preview

00:08:49

Challenge: Convert the Lesson 7 Photo Array / Funcs to be an Object Class

Preview

00:02:04

Lesson 9: Object Oriented Programming II

Learning Objectives

Play Video

00:02:12

Language Features: Even Better Code Re-use with Inheritance

Preview

00:08:32

Practical PHP: Further Refining our Page Class Hierarchy

Play Video

00:06:49

Building our Web Application

Preview

00:05:17

Challenge: Write Skeletons for a Login Page

Preview

00:01:58

Lesson 10: Object Oriented Programming III

Learning Objectives

Play Video

00:02:01

Language Features: Making our Objects More Flexible and Reusable

Preview

00:12:38

Practical PHP: Structured Exception Handling

Preview

00:13:05

Building our Web Application

Preview

00:03:37

Challenge: Update your Photo Class to use SEH and Implement a _toString Method

Preview

00:02:02

Lesson 11: Learning More About the Web Server

Learning Objectives

Play Video

00:01:59

Language Features: Taking a Closer Look at HTML Forms and Elements

Preview

00:10:38

Practical PHP: Processing Forms on the Server

Preview

00:07:53

Building our Web Application

Preview

00:08:07

Challenge: Add Extra Data to the User's Object and Add to Input Page

Preview

00:01:57

Lesson 12: Designing and Creating your Database

Learning Objectives

Play Video

00:01:57

Language Features: Beginning Work with Databases

Preview

00:12:19

Practical PHP: Accessing our Data from within PHP

Preview

00:09:25

Building our Web Application

Preview

00:06:53

Challenge: Add Extra Fields to User Table and Modify Forms and Pages to Support This

Preview

00:02:04

Lesson 13: Fetching Data from the Database

Learning Objectives

Play Video

00:01:56

Language Features: Working with our Databases

Preview

00:12:35

Practical PHP: Further Massaging our Returned Data

Preview

00:10:56

Building our Web Application

Preview

00:07:22

Challenge: Sort View All Users Page, and also Support Reverse Sorting

Preview

00:02:00

Lesson 14: Modifying Data in the Database

Learning Objectives

Play Video

00:02:07

Language Features: Modifying Data in the DB

Preview

00:07:51

Practical PHP: FULLTEXT Data, Joins, and Transactions

Preview

00:12:43

Building our Web Application

Play Video

00:09:14

Challenge: Create a Change Password Form

Preview

00:02:07

Lesson 15: Remembering Things: Cookies and Sessions

Learning Objectives

Play Video

00:01:58

Language Features: Moving Data with the User: Cookies

Preview

00:10:53

Practical PHP: Sessions and FULLTEXT Searching

Preview

00:09:49

Building our Web Application

Preview

00:09:11

Challenge: Make Sure Users Can Only See Certain Pages if They're Logged In

Preview

00:02:58

Lesson 16: Files and File Uploads

Learning Objectives

Play Video

00:01:52

Language Features: Uploading Files

Preview

00:11:17

Practical PHP: Working with Files on the Server

Preview

00:08:37

Building our Web Application

Preview

00:11:35

Challenge: Add a Description to the Photo in our Application

Preview

00:03:14

Lesson 17: Formatted Output, Output Buffering and Security

Learning Objectives

Play Video

00:01:54

Language Features: Formatted Output and Output Buffering

Preview

00:11:03

Practical PHP: Looking at Security

Play Video

00:10:35

Building our Web Application

Preview

00:09:19

Challenge: Add Output Formatting to our App

Preview

00:02:30

Lesson 18: When Things Go Wrong

Learning Objectives

Play Video

00:01:56

Language Features: Reviewing Errors

Preview

00:13:18

Practical PHP: More Error Handling

Preview

00:11:05

Building our Web Application

Preview

00:03:14

Challenge: Add Exception Logging to our Application

Preview

00:02:04

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • macintosh.sitx
  • windows.zip