BN.com Gift Guide

PHP and MySQL (Video Training)

( 4 )

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....

See more details below
Available through our Marketplace sellers.
Other sellers (Other Format)
  • All (1) from $29.98   
  • Used (1) from $29.98   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$29.98
Seller since 2014

Feedback rating:

(4)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Very Good
book and dvd in sleeve

Ships from: Denver, CO

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

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 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.
Read More Show Less

Product Details

  • ISBN-13: 9780137155750
  • Publisher: Prentice Hall
  • Publication date: 10/16/2008
  • Series: LiveLessons Series
  • Pages: 112
  • Product dimensions: 7.50 (w) x 9.10 (h) x 1.10 (d)

Meet the Author

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.
Read More Show Less

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

Read More Show Less

Customer Reviews

Average Rating 4.5
( 4 )
Rating Distribution

5 Star

(1)

4 Star

(3)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Posted June 12, 2009

    Best money spent on PHP and MYSQL technical training

    I'm an IT professional. Had no experience with PHP and MySQL. The video was clear and excellent in delivery. Wandschneider was a developer at Microsoft for years. He knows what he's talking about. In one night I was able to get Apache Server, PHP and MySQL running and develop some significant programming. Thank you Mark Wandschneider!

    Was this review helpful? Yes  No   Report this review
  • Posted December 26, 2008

    more from this reviewer

    easy introduction

    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. <BR/><BR/>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. <BR/><BR/>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, summarises the lessons. What the booklet shows is that the lessons don't really have much in them, compared to a fully fledged book on PHP and MySQL. But those books might easily be 500 pages or more and very forbidding to some. If this is your case, then these videos are a far easier and gentler introduction. After which you can move on to more indepth texts.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 22, 2010

    No text was provided for this review.

  • Anonymous

    Posted June 6, 2010

    No text was provided for this review.

Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)