Home > Store > Programming > PHP
PHP and MySQL LiveLessons (Video Training)
- By Marc Wandschneider
- Published Oct 2, 2008 by Prentice Hall. Part of the LiveLessons series.
- Copyright 2009
- Edition: 1st
- DVD
- ISBN-10: 0-13-715575-1
- ISBN-13: 978-0-13-715575-0
Register your product to gain access to bonus material or receive a coupon.
Product Author Bios
Marc Wandschneider is the author of Core Web Application Development with PHP and MySQL (Prentice Hall, 2006). He has been a programmer for more than fifteen years and has worked extensively with open source platforms. He designed and implemented Swik to help people collaboratively document open source software, and continues to work on various free and open source projects. He currently travels the globe, consulting as a lead manager for software projects and teams. A graduate of McGill University’s School of Computer Science, he spent nearly six years at Microsoft as a developer and leader on the Visual Basic, Visual J++, and .NET Windows Forms teams.
Video
You need to upgrade your Flash Player. You need version 9 or above to view this video. You may download it here. You may also see this message if you have JavaScript turned off. If this is the case, please enable JavaScript and reload the page.
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 code is on the DVD. 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, on DVD with a book supplement, 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.
Downloads
Download the code for a PC (ZIP)
Download the code for a Mac (SITX)
Click to view the companion booklet or right-click and select Save Link As... to download it
|
6 of 6 people found the following review helpful
Don't do waste your money,
Amazon Verified Purchase(What's this?)
This review is from: PHP and MySQL LiveLessons (Video Training) (Paperback)
You can find free video tutorials of similar quality on the internet.Fatal Flaws: *The paperback book does not follow the video properly. It acts as two different sources of information. Neither is very good. *The software used in the video is outdated and the newer versions no longer function the same way. PLUS there are better utilities available now. *The video lessons use examples that are not provided for you, so you can not easily work on an application together. *The only web resource, [...], is just an affiliate redirect to another site where you can by more books/videos. The creator of[...] will get the commission. I will NEVER buy any live lessons products. I would suggest starting w3schools intro to php/mysql, it is not a video, but still very helpful.
4 of 4 people found the following review helpful
easy introduction to PHP and MySQL, By
This review is from: PHP and MySQL LiveLessons (Video Training) (Paperback)
Twenty years ago I took some video classes given by the IEEE. These were delivered via satellite. So at a given time, all over the US, people interested could go to some site hosting the event, and then get a lecture on a typically abstruse topic. Unidirectional, because the lecture was prerecorded. Reviewing these livelessons on PHP and MySQL reminded me of those now distant classes. The format is essentially the same. Though perhaps more convenient here, since you have the DVDs in hand and can play and replay them at your convenience.This video appeals to those people who have trouble studying strictly from the printed word, be it in a book or webpage. I never had any problem with the latters, but there are definitely people who need something like a human tutor to nudge things along. For you, the video can be helpful. The 18 lessons are about half an hour each. Short and focusing on a precise topic. The accompanying book, well actually it is a slim booklet,... Read more
1 of 1 people found the following review helpful
PHP - MySQL Video Training Lessons By Marc Wandschneider, By
Amazon Verified Purchase(What's this?)
This review is from: PHP and MySQL LiveLessons (Video Training) (Paperback)
This instructor knows this subject. However, he moves along very fast, and he assumes the student has a fairly substantial background in programming. If a student does not have substantial programming savvy, more elementary lessons first might be in order.
|
Excerpt
PHP and MySQL: Language Features
Table of Contents
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 Statement 23
Lesson 5: Functions and Loops 25
Loops 25
Functions 26
Byval and Byref Parameters 27
Scoping 28
Lesson 6: Text and Strings 29
Review of Strings in PHP 29
More on Variable Expansion 30
String Operators 30
Common Operations and Functions for Strings 31
Sending Data via GET Parameters 33
PHP and Unicode 33
Lesson 7: Arrays, File Organization 35
Review of Array Basics 35
Multidimensional Arrays 36
Counting Array Elements 36
Removing and Deleting 36
Iterating over Array Contents — foreach Loops 36
Common Array Operations 37
File Inclusion 38
Lesson 8: Object-Oriented Programming I 39
Declaring New Types 39
Constructors 41
Access Levels 41
Lesson 9: Object-Oriented Programming II 43
Better Code Reuse with Inheritance 43
Further Refining Our Objects 44
Lesson 10: Object-Oriented Programming III 47
Class Constants 47
Static Class Data 48
Static Methods 48
Operations on Objects 48
Structured Exception Handling 50
Lesson 11: Learning about the Web Server 53
More FORM Elements 53
POST vs. GET 54
The $_SERVER superglobal 56
FORM Security 58
More on Processing Forms 58
Serializing Objects 60
Lesson 12: Getting Started with the Database 61
Getting to MySQL 61
Creating Our Database 62
Creating a Database User 62
Creating the First Table 62
Inserting Data into Tables 64
Wrecking Things 64
Working with MySQL from within PHP 64
Securing User Data 65
Lesson 13: Fetching Data from the Database 67
Retrieving Data 67
More on Query Expressions: Functions 68
Sorting Result Sets 69
Fetching Subsets of the Result Sets 69
Modifying a Table 69
Lesson 14: Modifying Data in the Database 71
Modifying Rows in Our Tables 71
Deleting Rows from a Table 71
FULLTEXT Indexes 72
Joining Fetches 72
Transacting Queries 73
Using Hidden Fields on Forms 74
Lesson 15: Remembering Things: Cookies and Sessions 77
Carrying Information across Page Requests: Cookies 77
Sessions 79
FULLTEXT Searching in MySQL 81
Lesson 16: Files and File Uploads 83
Uploading User Files 83
File Functions 87
Browsing Directories 89
Lesson 17: Formatted Output, Output Buffering, and Security 91
Formatting Strings with printf and sprintf 91
Date and Time Functions 93
Output Buffering 96
Lesson 18: When Things Go Wrong 99
Errors in PHP 99
Handling Errors 100
Debugging with Xdebug 101
DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
This DVD includes free shipping!
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
