Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

by: Meloni, Julie C.

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

by: Meloni, Julie C.

ISBN 13:
9780672326202
ISBN 10:
0672326205
Edition: 1st
Format: Paperback w/CD
Copyright: 01/01/2004
Publisher: Sams
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

"Sams Teach Yourself PHP, MySQL and Apache in 24 Hours" combines these most popular open source Web development tools into one easy-to-understand book, packaged with one easy-to-use Starter Kit CD. This book teaches the reader to install, configure and set up the PHP scripting language, the MySQL database system, and the Apache Web server. By the end of this book the reader will understand how these technologies work, and more importantly, how they work together to create a dynamic Web site. After creating a simple Web site using these tools, the reader will be able to manage a simple mailing list, and to create an online address book, shopping cart, and storefront.

"Sams Teach Yourself PHP, MySQL and Apache in 24 Hours" also teaches the reader how to fine-tune Apache and MySQL, and covers simple Web server security.

Introduction
Who Should Read This Book?
How This Book Is Organized
Conventions Used in This Book
Laying The Groundwork
Installing and Configuring MySQL
Current and Future Versions of 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
Installing and Configuring Apache
Current and Future Versions of Apache
Choosing an 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
Installing and Configuring PHP
Current and Future Versions of 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
PHP Language Structure
The Building Blocks of PHP
Variables
Data Types
Operators and Expressions
Constants
Summary
Q&A. Workshop
Flow Control Functions in PHP
Switching Flow
Loops
Code Blocks and Browser Output
Summary
Q&A. Workshop
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
Working with Arrays and Objects
What Is an Array? Creating Arrays
Some Array-Related Functions
Creating an Object
Object Inheritance
Summary
Q&A. Workshop
Getting Involved With The Code
Working with Strings, Dates, and Times
Formatting Strings with PHP. Investigating Strings in PHP. Manipulating Strings with PHP. Using Date and Time Functions in PHP. Summary
Workshop
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
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
Working with Files and Directories
Including Files with include(). 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
Working with the Server Environment
Opening Pipes to and from Processes Using popen(). Running Commands with exec(). Running Commands with system() or passthru(). Summary
Q&A. Workshop
Working with Images
Understanding the Image-Creation Process
Necessary Modifications to PHP. Drawing a New Image
Getting Fancy with Pie Charts
Modifying Existing Images
Summary
Q&A. Workshop
PHP and Mysql Integration
Learning the Database Design Process
The Importance of Good Database Design
Types of Table Relationships
Understanding Normalization
Following the Design Process
Summary
Q&A. Workshop
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
Interacting with MySQL Using PHP
Connecting to MySQL with PHP. Working with MySQL Data
Summary
Workshop
Basic Projects
Managing a Simple Mailing List
Developing the Subscription Mechanism
Developing the Mailing Mechanism
Summary
Q&A. Workshop
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
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
Creating an Online Storefront
Planning and Creating the Database Tables
Displaying Categories of Items
Displaying Items
Summary
Workshop
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
Creating a Simple Calendar
Building a Simple Display Calendar
Creating a Calendar library
Summary
Q&A. Workshop
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 Cooki
Table of Contents provided by Publisher. All Rights Reserved.

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

9780672326202

0672326205

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

9780672326202

0672326205

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products