Skip to main content

PHP and MySQL Web Development All-in-One Desk Reference For Dummies



PHP and MySQL Web Development All-in-One Desk Reference For Dummies

Janet Valade, Tricia Ballad (With), Bill Ballad (With)

ISBN: 978-1-118-05175-7 March 2011 672 Pages


If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination!

PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business.

It’s easy to find what you need in this handy guide. You’ll discover how to:

  • Find and acquire all the tools you need and set up your development environment
  • Build PHP scripts to make your Web site work
  • Create a MySQL database that visitors can access
  • Summarize and sort data results
  • Design and implement user access control
  • Build a shopping cart application
  • Create extensions that make your site more useful

With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it!


Book I: Setting Up Your Environment.

Chapter 1: Setting Up Your Web Environment.

Chapter 2: Installing PHP.

Chapter 3: Setting Up the MySQL Environment.

Chapter 4: Installing a Web Server.

Chapter 5: Setting Up Your Web Development Environment with the XAMPP Package.

Book II: PHP Programming.

Chapter 1: PHP Basics.

Chapter 2: Building PHP Scripts.

Chapter 3: PHP and Your Operating System.

Chapter 4: Object-Oriented Programming.

Book III: Using MySQL.

Chapter 1: Introducing MySQL.

Chapter 2: Administering MySQL.

Chapter 3: Designing and Building a Database.

Chapter 4: Using the Database.

Chapter 5: Communicating with the Database from PHP Scripts.

Book IV: Security.

Chapter 1: General Security Considerations.

Chapter 2: An Overview of Authentication and Encryption.

Chapter 3: Creating a Secure Environment.

Chapter 4: Programming Securely in PHP.

Chapter 5: Programming Secure E-Commerce Applications.

Book V: PHP Extensions.

Chapter 1: Introduction to Extensions.

Chapter 2: Using PEAR.

Chapter 3: Using the XML Extension.

Chapter 4: Manipulating Images with the GD Extension.

Chapter 5: Mail Extensions.

Book VI: PHP Web Applications.

Chapter 1: Building and Processing Dynamic Forms.

Chapter 2: Making Information Available on Multiple Web Pages.

Chapter 3: Building a Login Application.

Chapter 4: Building an Online Catalog.

Chapter 5: Building a Shopping Cart.


Code for Book II

We put many of the code examples presented in PHP & MySQL Web Development All-in-One Desk Reference For Dummies on this page so you don?t have to type out long code blocks. Click the following links to download and use the code samples:

The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.

Code for Book VI, Chapter 1
Code for Book VI, Chapter 2
Code for Book VI, Chapter 3
Code for Book VI, Chapter 4
Code for Book VI, Chapter 5
All code samples