---

Sams Teach Yourself PHP, MySQL and Apache All in One (3rd Edition)

ISBN: 0672328739
EAN: 2147483647

Year: 2004
Pages: 327

Authors: Julie C. Meloni

BUY ON AMAZON

• Sams Teach Yourself PHP, MySQL and Apache: All in One, Third Edition
• Table of Contents
• Copyright
• About the Author
• Acknowledgements
• We Want to Hear from You
• 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
• Troubleshooting
• Chapter 2. Installing and Configuring MySQL
• Current and Future Versions of MySQL
• How to Get MySQL 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
• What Are Arrays?
• Creating Arrays
• Some Array-Related Functions
• Summary
• QA
• Workshop
• Chapter 9. Working with Objects
• Creating an Object
• Object Inheritance
• Summary
• QA
• Workshop
• Part III: Getting Involved with the Code
• Chapter 10. Working with Strings, Dates, and Time
• Formatting Strings with PHP
• Investigating Strings in PHP
• Manipulating Strings with PHP
• Using Date and Time Functions in PHP
• Other String, Date, and Time Functions
• Summary
• Workshop
• Chapter 11. 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 12. 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 13. Working with Files and Directories
• Including Files with include()
• Validating Files
• Creating a Function That Performs Multiple File Tests
• Creating and Deleting Files
• Opening a File for Writing, Reading, or Appending
• Reading from Files
• Writing or Appending to a File
• Working with Directories
• 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. Using Transactions and Stored Procedures in MySQL
• What Are Transactions?
• What Are Stored Procedures?
• Summary
• Workshop
• Chapter 18. Interacting with MySQL Using PHP
• MySQL Versus MySQLi Functions
• Connecting to MySQL with PHP
• Working with MySQL Data
• Summary
• Workshop
• Part V: Basic Projects
• Chapter 19. Managing a Simple Mailing List
• Developing the Subscription Mechanism
• Developing the Mailing Mechanism
• Summary
• QA
• Workshop
• Chapter 20. 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 21. 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 22. Creating an Online Storefront
• Planning and Creating the Database Tables
• Displaying Categories of Items
• Displaying Items
• Summary
• Workshop
• Chapter 23. 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
• Chapter 24. Creating a Simple Calendar
• Building a Simple Display Calendar
• Creating a Calendar Library
• Summary
• QA
• Workshop
• Chapter 25. 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 26. 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 27. Application Localization
• About Internationalization and Localization
• About Character Sets
• Environment Modifications
• Creating a Localized Page Structure
• Summary
• QA
• Workshop
• Chapter 28. Working with XML
• What Is XML?
• Accessing XML in PHP Using DOM Functions
• Accessing XML in PHP Using SimpleXML Functions
• Summary
• Workshop
• Part VI: Administration and Fine-tuning
• Chapter 29. Apache Performance Tuning and Virtual Hosting
• Scalability Issues
• Load Testing with ApacheBench
• Proactive Performance Tuning
• Preventing Abuse
• Implementing Virtual Hosting
• Summary
• QA
• Workshop
• Chapter 30. 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 31. 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 32. Software Upgrades
• Staying in the Loop
• Upgrading MySQL
• Upgrading Apache
• Upgrading PHP
• Summary
• 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