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