Sams Teach Yourself PHP, MySQL and Apache All in One (4th Edition)

ISBN: 067232976X
EAN: 2147483647

Year: 2003
Pages: 333

Authors: Julie Meloni

BUY ON AMAZON

Sams Teach Yourself PHP, MySQL and Apache All in One, Second Edition
Table of Contents
Copyright
About the Authors
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: Laying the Groundwork
Chapter 1. Installation QuickStart Guide
LinuxUnix Installation
Windows Installation
Mac OS X Installation
Chapter 2. Installing and Configuring MySQL
Current and Future Versions of MySQL
How to Get MySQL
Installing MySQL on LinuxUnix
Installing MySQL on Mac OS X
Installing MySQL on Windows
Troubleshooting Your Installation
Basic Security Guidelines
Introducing the MySQL Privilege System
Working with User Privileges
Summary
QA
Workshop
Chapter 3. Installing and Configuring Apache
Current and Future Versions of Apache
Choosing the Appropriate Installation Method
Installing Apache on LinuxUnix
Installing Apache on Mac OS X
Installing Apache on Windows
Apache Configuration File Structure
Apache Log Files
Apache-Related Commands
Starting Apache for the First Time
Troubleshooting
Summary
QA
Workshop
Chapter 4. Installing and Configuring PHP
Current and Future Versions of PHP
Building PHP on LinuxUnix with Apache
Installing PHP on Mac OS X
Installing PHP on Windows
php.ini Basics
Testing Your Installation
Getting Installation Help
The Basics of PHP Scripts
Summary
QA
Workshop
Part II: PHP Language Structure
Chapter 5. The Building Blocks of PHP
Variables
Data Types
Operators and Expressions
Constants
Summary
QA
Workshop
Chapter 6. Flow Control Functions in PHP
Switching Flow
Loops
Code Blocks and Browser Output
Summary
QA
Workshop
Chapter 7. Working with Functions
What is a Function?
Calling Functions
Defining a Function
Returning Values from User-Defined Functions
Variable Scope
Saving State Between Function Calls with the static Statement
More About Arguments
Testing for the Existence of a Function
Summary
QA
Workshop
Chapter 8. Working with Arrays and Objects
What is an Array?
Creating Arrays
Some Array-Related Functions
Creating an Object
Object Inheritance
Summary
Workshop
Part III: Getting Involved with the Code
Chapter 9. Working with Strings, Dates, and Times
Formatting Strings with PHP
Investigating Strings in PHP
Manipulating Strings with PHP
Using Date and Time Functions in PHP
Summary
QA
Workshop
Chapter 10. Working with Forms
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
Working with File Uploads
Summary
Workshop
Chapter 11. Working with Cookies and User Sessions
Introducing Cookies
Setting a Cookie with PHP
Session Function Overview
Starting a Session
Working with Session Variables
Passing Session IDs in the Query String
Destroying Sessions and Unsetting Variables
Using Sessions in an Environment with Registered Users
Summary
QA
Workshop
Chapter 12. Working with Files and Directories
Including Files with include()
Validating 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
QA
Workshop
Chapter 13. Working with the Server Environment
Opening Pipes to and from Processes Using popen()
Running Commands with exec()
Running Commands with system() or passthru()
Summary
QA
Workshop
Chapter 14. Working with Images
Understanding the Image-Creation Process
Necessary Modifications to PHP
Drawing a New Image
Getting Fancy with Pie Charts
Modifying Existing Images
Image Creation from User Input
Summary
QA
Workshop
Part IV: PHP and MySQL Integration
Chapter 15. Understanding the Database Design Process
The Importance of Good Database Design
Types of Table Relationships
Understanding Normalization
Following the Design Process
Summary
QA
Workshop
Chapter 16. 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 the UPDATE Command to Modify Records
Using the REPLACE Command
Using the DELETE Command
Frequently Used String Functions in MySQL
Using Date and Time Functions in MySQL
Summary
QA
Workshop
Chapter 17. Interacting with MySQL Using PHP
Connecting to MySQL with PHP
Working with MySQL Data
Summary
Workshop
Part V: Basic Projects
Chapter 18. Managing a Simple Mailing List
Developing the Subscription Mechanism
Developing the Mailing Mechanism
Summary
QA
Workshop
Chapter 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
Chapter 20. Creating a Simple Discussion Forum
Designing the Database Tables
Creating the Input Forms and Scripts
Displaying the Topic List
Displaying the Posts in a Topic
Adding Posts to a Topic
Summary
QA
Workshop
Chapter 21. Creating an Online Storefront
Planning and Creating the Database Tables
Displaying Categories of Items
Displaying Items
Summary
Workshop
Chapter 22. 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
Quiz
Answers
Chapter 23. Creating a Simple Calendar
Building a Simple Display Calendar
Creating a Calendar Library
Summary
QA
Workshop
Chapter 24. 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
Restricting Access Based on Cookie Values
Summary
QA
Workshop
Chapter 25. Logging and Monitoring Web Server Activity
Standard Apache Access Logging
Standard Apache Error Logging
Managing Apache Logs
Logging Custom Information to a Database
Summary
QA
Workshop
Chapter 26. Application Localization
About Internationalization and Localization
About Character Sets
Environment Modifications
Creating a Localized Page Structure
Summary
QA
Workshop
Part VI: Administration and Fine-Tuning
Chapter 27. Apache Performance Tuning and Virtual Hosting
Scalability Issues
Load Testing with ApacheBench
Proactive Performance Tuning
Preventing Abuse
Implementing Virtual Hosting
Summary
QA
Workshop
Chapter 28. Setting Up a Secure Web Server
The Need for Security
The SSL Protocol
Obtaining and Installing SSL Tools
Managing Certificates
SSL Configuration
Summary
QA
Workshop
Chapter 29. 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
QA
Workshop
Chapter 30. Software Upgrades
Staying in the Loop
Upgrading MySQL
Upgrading Apache
Upgrading PHP
Summary
Workshop
Part VII: Looking Toward the Future
Chapter 31. Features and Backward Compatibility of PHP 5.0
What Was Wrong with PHP 4?
The New Object Model
Additional New Features
So, When Should I Install PHP 5?
Summary
QA
Chapter 32. Features and Backward Compatibility of MySQL 4.1
Using Subqueries
Internationalization Enhancements
Additional New Functionality
Looking Further Ahead to MySQL 5.0
Summary
QA
Workshop
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z