Table of Contents


book cover
Sams Teach Yourself PHP, MySQL and Apache: All in One, Third Edition
By Julie Meloni
...............................................
Publisher: Sams
Pub Date: June 30, 2006
Print ISBN-10: 0-672-32873-9
Print ISBN-13: 978-0-672-32873-2
Pages: 624
 

Table of Contents  | Index

   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
      Linux/UNIX 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 Linux/UNIX
      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
      Q&A
      Workshop
      Chapter 3.  Installing and Configuring Apache
      Current and Future Versions of Apache
      Choosing the Appropriate Installation Method
      Installing Apache on Linux/UNIX
      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
      Q&A
      Workshop
      Chapter 4.  Installing and Configuring PHP
      Current and Future Versions of PHP
      Building PHP on Linux/UNIX 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
      Q&A
      Workshop
    Part II:  PHP Language Structure
      Chapter 5.  The Building Blocks of PHP
      Variables
      Data Types
      Operators and Expressions
      Constants
      Summary
      Q&A
      Workshop
      Chapter 6.  Flow Control Functions in PHP
      Switching Flow
      Loops
      Code Blocks and Browser Output
      Summary
      Q&A
      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
      Q&A
      Workshop
      Chapter 8.  Working with Arrays
      What Are Arrays?
      Creating Arrays
      Some Array-Related Functions
      Summary
      Q&A
      Workshop
      Chapter 9.  Working with Objects
      Creating an Object
      Object Inheritance
      Summary
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      Workshop
      Chapter 27.  Application Localization
      About Internationalization and Localization
      About Character Sets
      Environment Modifications
      Creating a Localized Page Structure
      Summary
      Q&A
      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
      Q&A
      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
      Q&A
      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
      Q&A
      Workshop
      Chapter 32.  Software Upgrades
      Staying in the Loop
      Upgrading MySQL
      Upgrading Apache
      Upgrading PHP
      Summary
      Workshop
   Index



Sams Teach Yourself PHP, MySQL And Apache All in One
Sams Teach Yourself PHP, MySQL and Apache All in One (3rd Edition)
ISBN: 0672328739
EAN: 2147483647
Year: 2004
Pages: 327

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net