Table of content

•	Table of Contents
•	Index
•	Examples

Sams Teach Yourself PHP, MySQL™ and Apache in 24 Hours
By Julie C Meloni
Publisher	: Sams Publishing
Pub Date	: December 11, 2002
ISBN	: 0-6723-2489-X
Pages	: 528
	Copyright
		Lead Author
		Contributing Authors
		Acknowledgments
		We Want to Hear from You!
		Reader Services
		Introduction
			Who Should Read This Book?
			How This Book Is Organized
			Conventions Used in This Book
		Part I:  Getting Up and Running
			Hour 1.  Installing and Configuring MySQL
				How to Get MySQL
				Installing MySQL on Linux/Unix
				Installing MySQL on Windows
				Troubleshooting Your Installation
				Basic Security Guidelines
				Introducing the MySQL Privilege System
				Working with User Privileges
				Summary
				Q&A
				Workshop
			Hour 2.  Installing and Configuring Apache
				Choosing the Appropriate Installation Method
				Installing Apache on Linux/Unix
				Installing Apache on Windows
				Apache Configuration File Structure
				Apache Log Files
				Apache-Related Commands
				Starting Apache for the First Time
				Troubleshooting
				Summary
				Q&A
				Workshop
			Hour 3.  Installing and Configuring PHP
				Building PHP on Linux/Unix with Apache
				Installing PHP Files on Windows
				php.ini Basics
				Testing Your Installation
				Getting Installation Help
				The Basics of PHP Scripts
				Summary
				Q&A
				Workshop
		Part II:  Basic Language Elements
			Hour 4.  The Building Blocks of PHP
				Variables
				Data Types
				Operators and Expressions
				Constants
				Summary
				Q&A
				Workshop
			Hour 5.  Flow Control Functions in PHP
				Switching Flow
				Loops
				Code Blocks and Browser Output
				Summary
				Q&A
				Workshop
			Hour 6.  Working with Functions
				What Is a Function?
				Calling Functions
				Defining a Function
				Returning Values from User-Defined Functions
				Dynamic Function Calls
				Variable Scope
				Saving State Between Function Calls with the static Statement
				More About Arguments
				Creating Anonymous Functions
				Testing for the Existence of a Function
				Summary
				Q&A
				Workshop
			Hour 7.  Learning Basic SQL Commands
				Learning the MySQL Data Types
				Learning the Table Creation Syntax
				Using the INSERT Command
				Using the SELECT Command
				Using WHERE in Your Queries
				Selecting from Multiple Tables
				Using JOIN
				Using the UPDATE Command to Modify Records
				Using the REPLACE Command
				Using the DELETE Command
				Summary
				Q&A
				Workshop
			Hour 8.  Interacting with MySQL Using PHP
				Connecting to MySQL with PHP
				Working with MySQL Data
				Summary
				Workshop
		Part III:  Getting Involved with the Code
			Hour 9.  Working with Forms
				Predefined Variables
				Creating a Simple Input Form
				Accessing Form Input with User-Defined Arrays
				Combining HTML and PHP Code on a Single Page
				Using Hidden Fields to Save State
				Redirecting the User
				Sending Mail on Form Submission
				Creating the Form
				Creating the Script to Send the Mail
				Working with File Uploads
				Summary
				Workshop
			Hour 10.  Working with Files
				Including Files with include()
				include_once()
				Testing Files
				Creating and Deleting Files
				Opening a File for Writing, Reading, or Appending
				Reading from Files
				Writing or Appending to a File
				Working with Directories
				Summary
				Q&A
				Workshop
			Hour 11.  Working with Dates and Times
				Using Date and Time Functions in PHP
				Using Date and Time Functions in MySQL
				Summary
				Workshop
			Hour 12.  Creating a Simple Calendar
				Building a Simple Display Calendar
				Creating a Calendar Library
				Summary
				Q&A
				Workshop
			Hour 13.  Working with Strings
				Formatting Strings with PHP
				Investigating Strings in PHP
				Manipulating Strings with PHP
				Frequently Used String Functions in MySQL
				Summary
				Q&A
				Workshop
			Hour 14.  Creating a Simple Discussion Forum
				Types of Table Relationships
				Understanding Normalization
				Following the Design Process
				Creating a Discussion Forum
				Summary
				Q&A
				Workshop
			Hour 15.  Restricting Access to Your Applications
				Authentication Overview
				Apache Authentication Module Functionality
				Using Apache for Access Control
				Combining Apache Access Methods
				Limiting Access Based on HTTP Methods
				Introducing Cookies
				Setting a Cookie with PHP
				Restricting Access Based on Cookie Values
				Summary
				Q&A
				Workshop
			Hour 16.  Working with User Sessions
				Session Function Overview
				Starting a Session
				Working with Session Variables
				Passing Session IDs in the Query String
				Destroying Sessions and Unsetting Variables
				Summary
				Q&A
				Workshop
			Hour 17.  Logging and Monitoring Server Activity
				Standard Apache Access Logging
				Standard Apache Error Logging
				Managing Apache Logs
				Logging Custom Information to a Database
				Summary
				Q&A
				Workshop
		Part IV:  Simple Projects
			Hour 18.  Managing a Simple Mailing List
				Developing the Subscription Mechanism
				Developing the Mailing Mechanism
				Summary
				Q&A
				Workshop
			Hour 19.  Creating an Online Address Book
				Planning and Creating the Database Tables
				Creating a Menu
				Creating the Record Addition Mechanism
				Viewing Records
				Creating the Record Deletion Mechanism
				Adding Subentries to a Record
				Summary
				Workshop
			Hour 20.  Creating an Online Storefront
				Planning and Creating the Database Tables
				Displaying Categories of Items
				Displaying Items
				Summary
				Workshop
			Hour 21.  Creating a Shopping Cart Mechanism
				Planning and Creating the Database Tables
				Integrating the Cart with Your Storefront
				Payment Methods and the Checkout Sequence
				Summary
				Workshop
		Part V:  Administration and Fine-Tuning
			Hour 22.  Apache Performance Tuning and Virtual Hosting
				Scalability Issues
				Load Testing with ApacheBench
				Proactive Performance Tuning
				Preventing Abuse
				Implementing Virtual Hosting
				Summary
				Q&A
				Workshop
			Hour 23.  Setting Up a Secure Web Server
				The Need for Security
				The SSL Protocol
				Installing SSL
				Managing Certificates
				SSL Configuration
				Summary
				Q&A
				Workshop
			Hour 24.  Optimizing and Tuning MySQL
				Building an Optimized Platform
				MySQL Startup Options
				Optimizing Your Table Structure
				Optimizing Your Queries
				Using the FLUSH Command
				Using the SHOW Command
				Summary
				Q&A
				Workshop
		Index