You are previewing PHP & MySQL® Web Development All-in-One Desk Reference for Dummies®.
O'Reilly logo
PHP & MySQL® Web Development All-in-One Desk Reference for Dummies®

Book Description

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!

Table of Contents

  1. Copyright
  2. About the Author
  3. Dedication
  4. Author's Acknowledgments
  5. Publisher's Acknowledgments
  6. Introduction
  7. Setting Up Your Environment
    1. Setting Up Your Web Environment
      1. The Required Tools
      2. Choosing a Host for Your Web Site
      3. Choosing Your Development Environment
      4. Setting Up Your Local Computer for Development
      5. Keeping Up with PHP and MySQL Changes
    2. Installing PHP
      1. Checking the PHP Installation
      2. Obtaining PHP
      3. Installing PHP
      4. Configuring Your Web Server for PHP
      5. Configuring PHP
      6. Testing PHP
      7. Activating MySQL Support
      8. Troubleshooting
    3. Setting Up the MySQL Environment
      1. Checking the MySQL Installation
      2. Obtaining MySQL
      3. Installing MySQL
      4. Configuring MySQL
      5. Starting and Stopping the MySQL Server
      6. Testing MySQL
      7. Troubleshooting MySQL
      8. Installing MySQL GUI Administration Programs
      9. Installing phpMyAdmin
      10. Troubleshooting phpMyAdmin
    4. Installing a Web Server
      1. Testing Your Web Server
      2. Installing and Configuring Apache
      3. Installing IIS
    5. Setting Up Your Web Development Environment with the XAMPP Package
      1. Obtaining XAMPP
      2. Installing XAMPP
      3. Using the XAMPP Control Panel
      4. Testing Your Development Environment
      5. Configuring Your Development Environment
      6. Uninstalling and Reinstalling XAMPP
      7. Troubleshooting
  8. PHP Programming
    1. PHP Basics
      1. How PHP Works
      2. Structure of a PHP Script
      3. PHP Syntax
      4. Writing PHP Code
      5. Displaying Content in a Web Page
      6. Using PHP Variables
      7. Using PHP Constants
      8. Understanding Data Types
      9. Using Arrays
      10. Using Dates and Times
      11. Understanding PHP Error Messages
      12. Adding Comments to Your PHP Script
    2. Building PHP Scripts
      1. Setting Up Conditions
      2. Using Conditional Statements
      3. Repeating Actions with Loops
      4. Using Functions
      5. Organizing Scripts
    3. PHP and Your Operating System
      1. Managing Files
      2. Using Operating System Commands
      3. Using FTP
      4. Reading and Writing Files
      5. Exchanging Data with Other Programs
      6. Using SQLite
    4. Object-Oriented Programming
      1. Introducing Object-Oriented Programming
      2. Developing an Object-Oriented Script
      3. Defining a Class
      4. Using a Class in a Script
      5. Using Abstract Methods in Abstract Classes and Interfaces
      6. Preventing Changes to a Class or Method
      7. Handling Errors with Exceptions
      8. Copying Objects
      9. Comparing Objects
      10. Getting Information about Objects and Classes
      11. Destroying Objects
  9. Using MySQL
    1. Introducing MySQL
      1. How MySQL Works
      2. Understanding Database Structure
      3. Communicating with MySQL
      4. Protecting Your MySQL Databases
    2. Administering MySQL
      1. Understanding the Administrator Responsibilities
      2. Default Access to Your Data
      3. Controlling Access to Your Data
      4. Setting Up MySQL Accounts
      5. Backing Up Your Database
      6. Restoring Your Data
      7. Upgrading MySQL
    3. Designing and Building a Database
      1. Designing a Database
      2. Building a Database
      3. Changing the Database Structure
    4. Using the Database
      1. Adding Information to a Database
      2. Looking at the Data in a Database
      3. Retrieving Information from a Database
      4. Updating Information in a Database
      5. Removing Information from a Database
    5. Communicating with the Database from PHP Scripts
      1. How MySQL and PHP Work Together
      2. PHP Functions That Communicate with MySQL
      3. Communicating with MySQL
      4. Selecting a Database
      5. Handling MySQL Errors
      6. Using Other Helpful mysqli Functions
      7. Converting mysqli Functions to mysql Functions
  10. Security
    1. General Security Considerations
      1. Understanding Security Roles
      2. Understanding Security Threats
      3. Developing a Security Policy
    2. An Overview of Authentication and Encryption
      1. Understanding Authentication
      2. Exploring Encryption
    3. Creating a Secure Environment
      1. Securing Apache
      2. Securing IIS
      3. Setting Security Options in php.ini
    4. Programming Securely in PHP
      1. Handling Errors Safely
      2. Sanitizing Variables
      3. Uploading Files without Compromising the Filesystem
    5. Programming Secure E-Commerce Applications
      1. Securing Your Database
      2. Sending Encrypted Data with Secure Sockets Layer
      3. Keeping Sessions Secure
      4. Preventing Cross-Site Scripting
      5. Keeping Up to Date
  11. PHP Extensions
    1. Introduction to Extensions
      1. How Extensions Fit into the PHP Architecture
      2. Finding Out Which Extensions Are Loaded
      3. Loading Extensions
    2. Using PEAR
      1. Introducing PEAR
      2. Downloading and Installing the PEAR Package Manager
      3. Installing a PEAR Package
      4. Using a PEAR Package in Your Own Code
    3. Using the XML Extension
      1. Understanding the Document Object Model
      2. XML Validation Using Schema
      3. Giving Your Documents Some Style with XSLT
      4. Searching XML Documents with XPath
    4. Manipulating Images with the GD Extension
      1. Configuring the GD Extension
      2. Image Manipulations
    5. Mail Extensions
      1. Sending E-Mail with PHP
      2. Accessing IMAP and mBox Mailboxes
  12. PHP Web Applications
    1. Building and Processing Dynamic Forms
      1. Using Static HTML Forms
      2. Displaying Dynamic HTML Forms
      3. Processing Information from the Form
      4. Creating a Form That Allows Customers to Upload a File
    2. Making Information Available on Multiple Web Pages
      1. Navigating Web Sites with Multiple Pages
      2. Passing Information from One Page to the Next
      3. Making Information Available to All Pages in the Web Site
    3. Building a Login Application
      1. Designing the Login Application
      2. Creating the User Database
      3. Building the Login Web Page
      4. Building the Login Script
      5. Protecting Your Web Pages
    4. Building an Online Catalog
      1. Designing the Online Catalog
      2. Creating the Catalog Database
      3. Building the Catalog Web Pages
      4. Building the Online Catalog Application Script
    5. Building a Shopping Cart
      1. Designing the Shopping Cart
      2. Creating the Shopping Cart Database
      3. Building the Shopping Cart Web Pages
      4. Building the Shopping Cart Scripts
  13. Index