PHP and MySQL 24-Hour Trainer and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a £1.99 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading PHP and MySQL 24-Hour Trainer on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

PHP and MySQL 24-Hour Trainer [Paperback]

Andrea Tarr
5.0 out of 5 stars  See all reviews (3 customer reviews)
RRP: £26.99
Price: £22.94 & FREE Delivery in the UK. Details
You Save: £4.05 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 4 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 27 Oct.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition £21.79  
Paperback £22.94  
Trade In this Item for up to £1.99
Trade in PHP and MySQL 24-Hour Trainer for an Amazon Gift Card of up to £1.99, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

21 Feb 2012
Step–by–step lessons for using PHP and MySQL in a unique book–and–video combination

Assuming no previous experience with PHP or MySQL, this book–and–video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons.

When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.

Lessons include:
Getting started with PHP
Setting up your workspace
Adding PHP to a web page
Learning PHP syntax
Working with variables
Debugging code
Working with complex data
Making decisions
Repeating program steps
Learning about scope
Reusing code with functions
Creating forms
Introducing object–oriented programming
Defining classes
Using classes
Using advanced techniques
Handling errors
Writing secure code
Introducing databases
Introducing MySQL
Creating and connecting to the
Creating tables
Entering data
Selecting data
Using multiple tables
Changing data
Deleting data
Preventing database security issues
Creating user logins
Turn the case study into a content management system

Note: As part of the print version of this title, video lessons are included on DVD. For e–book versions, video lessons can be accessed at using a link provided in the interior of the e–book.

Special Offers and Product Promotions

  • Between 20-26 October 2014, spend £10 in a single order on item(s) dispatched from and sold by and receive a £2 promotional code to spend in the Amazon Appstore. Here's how (terms and conditions apply)

Frequently Bought Together

PHP and MySQL 24-Hour Trainer + JavaScript 24-Hour Trainer (Wrox Programmer to Programmer)
Price For Both: £44.07

Buy the selected items together

Product details

  • Paperback: 504 pages
  • Publisher: John Wiley & Sons; Pap/Dvdr edition (21 Feb 2012)
  • Language: English
  • ISBN-10: 111806688X
  • ISBN-13: 978-1118066881
  • Product Dimensions: 2.3 x 18.3 x 23 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 583,190 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Take static pages and turn them into a dynamic website!

Perhaps you know how to create a static website using HTML/CSS, but now you want to learn how to create dynamic, data–driven websites. If you′re new to PHP and MySQL, this book–and–DVD package is an ideal introduction to working with website pages that contain a mixture of HTML and PHP/MySQL. Author Andrea Tarr starts with what you know—an HTML/CSS website—and step by step she teaches you how to replace and enhance the site using PHP to create and manipulate your HTML pages and MySQL to bring in your data. You learn how to design, create, and use databases with MySQL, both within PHP programs and using the popular phpMyAdmin program. Explaining the programming principles as you go along, this book–and–DVD combination provides you with a solid understanding of the fundamentals of PHP and the basics of object–oriented programming.

PHP and MySQL 24–Hour Trainer:

  • Escorts you through preparing your computer to run PHP and MySQL by downloading and installing free software

  • Explains what variables are, how to work with them, and how to debug your programs

  • Zeros in on how databases work and how to design them

  • Shares tips for working with MySQL in a PHP program

  • Details ways to create tables, enter data, select data, change data, and delete data

The 24–Hour Trainer is a unique book–and–DVD package that delivers step–by–step lessons for handling real–world scenarios. Each lesson in the book is accompanied by an instructional video that reinforces the content while providing additional explanations and tips.

On the DVD

Don′t just learn—do!

The lessons within the book are each accompanied by an instructional demonstration on the DVD.

You′ll learn to:

  • Manipulate your website using PHP

  • Use object–oriented programming

  • Handle errors and write secure code

  • Design a database

  • Integrate MySQL with PHP

  • Process HTML forms

  • Create user logins, a mini content management system, and a data–driven menu

Please see the DVD appendix for details and complete system requirements.

About the Author

Andrea Tarr has been a programmer and IT manager for 30 years and now spends her time programming websites using PHP/MySQL. She is a member of the Production Leadership Team for Joomla!, a popular PHP/MySQL–based content management system.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars Another great php book 8 April 2012
Brilliantly written book. Very easy to follow and nicely constructed chapters.
This is what you expect from these fine publishers.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Great book 28 Dec 2013
Format:Paperback|Verified Purchase
This book helped me get an awesome grade in my second year of university, it was so useful!! You really don't need to be a genius to understand php and MySQL, this book breaks it down perfectly
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Great book. also comes with walk thorough DVD 28 Dec 2013
Format:Paperback|Verified Purchase
This book does just as the title states. walks you through the design and by the end you have a good understanding of what PHP and MYSQL is about. Down side is I've sent an email to the author but as yet have not received a reply. But yes a great book.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.1 out of 5 stars  11 reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars Very useful book 15 Dec 2011
By Independent Thinker - Published on
Format:Paperback|Verified Purchase
Just exactly what I needed. Understandable even for a newbie. I am making great progress thanks to this book! Highly recommended.
2 of 2 people found the following review helpful
4.0 out of 5 stars Clear, Robust, and Complete 13 Mar 2012
By F. Gibbs - Published on
The only gripe I have is that it tends to repeat a lot of stuff (I'm betting this is for people who jump in at certain chapters) and that they fail to explain WHY many things are used (tho this is probably not important, it helps me to understand whats going on). I found it very clear and much easier to get through then some of the loftier books.

Also, I think the editor was drunk when he reviewed chapter 15. There are so many mistakes!
2 of 2 people found the following review helpful
5.0 out of 5 stars Best PHP Book in the market now. 21 Feb 2012
By MTwins - Published on
Format:Paperback|Verified Purchase
This is one of the best PHP book now in the market, I can tell if the author is a really technical person as what demonstrated in the video alone, I spent time learning in the video rather than reading it, if you have patient to practice by coding it, that video is better than taking some "in class" lesson, because the application discussed in the video has a complete package. Great book, especially if you're new to PHP and MySql.
1 of 1 people found the following review helpful
3.0 out of 5 stars Good Book - But not the one stop shop. 26 Mar 2013
By airbrushtutor - Published on
I bought this book because of the promise of quality learning through guided tutorials and it's for appreciation of the effort in constructing this book in such a way that i've given it 3 stars. While the book starts off easily enough for a beginner to follow i found that the tutorials were lacking in some detail. When we're adding dynamics to our test website and the '(isset($_GET['xxx']))' request comes up, with no explanations of what isset is, nor what $_GET is - just what it does, which is a fundamental difference when you are trying to learn 'why'.
I still follow the tutorials of this book, however I would recommend that you purchase another tutorial based book on PHP to help you along such as Head First PHP & MySQL, which goes into detail about the 'why', not just the function of the element.
1 of 1 people found the following review helpful
4.0 out of 5 stars Wonderful Primer on PHP and MySQL 25 May 2012
By Stephen Brennan - Published on
Format:Kindle Edition|Verified Purchase
I picked up this book to help me with my studies. I have found it to be very well written. The case study is fun, as are some of the examples. The video files help supplement the book. I highly recommend it for anyone starting out with PHP and MySQL.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category