Sams Teach Yourself PHP, MySQL and Apache in 24 Hours
Sams Teach Yourself PHP, MySQL and Apache in 24 Hours
ISBN: 067232489X
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 263
Pages: 263
Authors: Julie C. Meloni
- Main Page
- Table of content
- 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 LinuxUnix
- Installing MySQL on Windows
- Troubleshooting Your Installation
- Basic Security Guidelines
- Introducing the MySQL Privilege System
- Working with User Privileges
- Summary
- QA
- Workshop
- Hour 2. Installing and Configuring Apache
- Choosing the Appropriate Installation Method
- Installing Apache on LinuxUnix
- Installing Apache on Windows
- Apache Configuration File Structure
- Apache Log Files
- Apache-Related Commands
- Starting Apache for the First Time
- Troubleshooting
- Summary
- QA
- Workshop
- Hour 3. Installing and Configuring PHP
- Building PHP on LinuxUnix with Apache
- Installing PHP Files on Windows
- php.ini Basics
- Testing Your Installation
- Getting Installation Help
- The Basics of PHP Scripts
- Summary
- QA
- Workshop
- Part II: Basic Language Elements
- Hour 4. The Building Blocks of PHP
- Variables
- Data Types
- Operators and Expressions
- Constants
- Summary
- QA
- Workshop
- Hour 5. Flow Control Functions in PHP
- Switching Flow
- Loops
- Code Blocks and Browser Output
- Summary
- QA
- 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
- QA
- 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
- QA
- 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
- QA
- 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
- QA
- 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
- QA
- Workshop
- Hour 14. Creating a Simple Discussion Forum
- Types of Table Relationships
- Understanding Normalization
- Following the Design Process
- Creating a Discussion Forum
- Summary
- QA
- 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
- QA
- 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
- QA
- 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
- QA
- Workshop
- Part IV: Simple Projects
- Hour 18. Managing a Simple Mailing List
- Developing the Subscription Mechanism
- Developing the Mailing Mechanism
- Summary
- QA
- 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
- QA
- Workshop
- Hour 23. Setting Up a Secure Web Server
- The Need for Security
- The SSL Protocol
- Installing SSL
- Managing Certificates
- SSL Configuration
- Summary
- QA
- 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
- QA
- Workshop
- Index
- Index SYMBOL
- Index A
- Index B
- Index C
- Index D
- Index E
- Index F
- Index G
- Index H
- Index I
- Index J
- Index K
- Index L
- Index M
- Index N
- Index O
- Index P
- Index Q
- Index R
- Index S
- Index T
- Index U
- Index V
- Index W
- Index X
- Index Y
Sams Teach Yourself PHP, MySQL and Apache in 24 Hours
ISBN: 067232489X
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 263
Pages: 263
Authors: Julie C. Meloni