Sams Teach Yourself Php, Mysql and Apache in 24 Hours
, by Meloni, Julie C.Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
- ISBN: 9780672324895 | 067232489X
- Cover: Paperback w/CD
- Copyright: 1/1/2003
Quick reference showing the beginner how to combine PHP, MySQL, and Apache to quickly create simple interactive Web applications. Softcover. CD-ROM included.
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. |
What is included with this book?
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.