Home
Programming

PHP, MySQL and Apache in 24 hours

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

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

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

Part II: Basic Language Elements

Hour 4. The Building Blocks of PHP

Operators and Expressions

Hour 5. Flow Control Functions in PHP

Code Blocks and Browser Output

Hour 6. Working with Functions

What Is a Function?

Calling Functions

Defining a Function

Returning Values from User-Defined Functions

Dynamic Function Calls

Saving State Between Function Calls with the 'static' Statement

More About Arguments

Creating Anonymous Functions

Testing for the Existence of a Function

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 the 'UPDATE' Command to Modify Records

Using the 'REPLACE' Command

Using the 'DELETE' Command

Hour 8. Interacting with MySQL Using PHP

Connecting to MySQL with PHP

Working with MySQL Data

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

Hour 10. Working with Files

Including Files with 'include()'

'include_once()'

Creating and Deleting Files

Opening a File for Writing, Reading, or Appending

Reading from Files

Writing or Appending to a File

Working with Directories

Hour 11. Working with Dates and Times

Using Date and Time Functions in PHP

Using Date and Time Functions in MySQL

Hour 12. Creating a Simple Calendar

Building a Simple Display Calendar

Creating a Calendar Library

Hour 13. Working with Strings

Formatting Strings with PHP

Investigating Strings in PHP

Manipulating Strings with PHP

Frequently Used String Functions in MySQL

Hour 14. Creating a Simple Discussion Forum

Types of Table Relationships

Understanding Normalization

Following the Design Process

Creating a Discussion Forum

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

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

Hour 17. Logging and Monitoring Server Activity

Standard Apache Access Logging

Standard Apache Error Logging

Managing Apache Logs

Logging Custom Information to a Database

Part IV: Simple Projects

Hour 18. Managing a Simple Mailing List

Developing the Subscription Mechanism

Developing the Mailing Mechanism

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

Hour 20. Creating an Online Storefront

Planning and Creating the Database Tables

Displaying Categories of Items

Displaying Items

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

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

Hour 23. Setting Up a Secure Web Server

The Need for Security

The SSL Protocol

Managing Certificates

SSL Configuration

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

Remember the name: eTutorials.org

Copyright eTutorials.org 2008-2023. All rights reserved.