O'Reilly - Safari Books Online - 9780137008704 - PHP and MySQL (Video Training)

Advanced Search

Table of Contents

PHP and MySQL (Video Training)

Browse by Category

Safari Books Online is an on-demand digital library that delivers expert content from the world's most trusted leaders in technology publishing to professionals worldwide. Safari brings you thousands of books, manuscripts, short topics, articles, and instructional video from expert authors, innovators, and thought leaders. Subscribe now! If you're interested in workgroup accounts, please visit our Multi-User Accounts page.

PHP and MySQL (Video Training)

by Marc Wandschneider

Publisher: Prentice Hall

Pub Date: October 03, 2008

Print ISBN-10: 0-13-700870-8

Print ISBN-13: 978-0-13-700870-4

Running Time: 10 hours 7 minutes 57 seconds

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.

Table of Contents

Video Preferences

Table of Contents

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

URL http://my.safaribooksonline.com/9780137008704