[ Team LiB ] Previous Section Next Section

   
•  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
[ Team LiB ] Previous Section Next Section