Home > Store

MySQL & PHP From Scratch

Register your product to gain access to bonus material or receive a coupon.

MySQL & PHP From Scratch

eBook (Adobe DRM)

  • Sorry, this book is no longer in print.
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:

    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
Not for Sale


  • Copyright 2001
  • Dimensions: 7-3/8" x 9-1/8"
  • Edition: 1st
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-5582-X
  • ISBN-13: 978-0-7686-5582-7

Apache, MySQL, PHP3, and IMP… the pieces exist. Each piece has been described ad nauseam. What does not exist is a guide to the marriage of these software technologies into a useful book, until now. This book puts together information on installing, setting up, and troubleshooting each of these technologies into one complete volume. You also learn how each piece is part of a whole by learning, step-by-step, how to create a web-based e-mail system. Learn to run the Linux equivalent of Active Server Pages (ASP) using PHP3, set up an e-commerce site using a database and the Apache web server, and create a data entry system (such as sales, product quality tracking, customer preferences, etc) that requires no installation in the PC.

Sample Content

Table of Contents


1. Prerequisite Operational System and Software.

Red Hat Linux 6.0 or Greater Recommended.

How to Check for the Presence of an Installed Package. How to Install a Needed Package from. Standalone Usage: How to Verify Required Services Are Installed and Working.

Network Functionality.

General Network Connectivity Guidelines. Testing Your Network Connection.

System Security.

Initial Security Steps. Application Upgrades.

Apache Web Server.

Verifying Apache Installation. Testing the Web Server Locally. Testing the Web Server from Another Computer.


Verifying sendmail Installation. sendmail Configuration. Testing sendmail.

GNU C/C++ Compiler.

Verifying GNU C/C++ Installation. Testing the Compiler.

Optional Local Network Usage.

How to Connect to an Existing Local Area Network. Network Usage: Windows-Based Clients.

2. Obtaining the Software.

How to Obtain Red Hat 6.2.

Where to Purchase or Download.

How to Obtain MySQL, PHP3, and IMP.

Required File List.

3. MySQL.

A Brief History. What Is MySQL?

MySQL Description. How It Works. What It Does for You. Getting Online Help for MySQL.


Installing the RPM. A Quick Test of the Install. Troubleshooting the Install.

Configuration for Use with IMP. Database System Concepts.

Database Design Tips. System Design Overview. General Database Design Issues. Relational Databases. Data Identification Techniques. Database Design Helpers. Keys. Correct Utilization of Data. Modifications to the IMP Database. Graphical Database Representations.

The IMP Database Structure. SQL Overview.

MySQL Implements a Subset of SQL. SQL Keywords. Typical SQL Statements.

MySQL's License.

Free Use Within Limitations. Implications and Examples.


4. Apache Web Server.

Apache License. PHP Configuration Overview. IMP Configuration Overview. CGI and PHP Server Pages Overview.

How CGI Works. How PHP Works in the ESL Mode. Testing the PHP and IMP Configuration.

Security Issues.

Running PHP with Minimal Risk. Apache Configuration Issues.

The Next Step.

5. PHP.


A Brief History. PHP Worldwide Use.

The GNU Public License.

What It Means. Use of PHP Under the GNU License.

What Is PHP?

How It Works. What It Does for You. Getting Online Help for PHP.

The Software Packages to Obtain.

Apache Development RPM. PHP3 Source Code. IMP Source Code. IMAP Development RPM. Freetype Development RPM.

Installation. Troubleshooting the Installation. PHP in a Nutshell.

General Format. Strings and Parsing. Web Page Use. Apache Web Server.

PHP Use.

Database Interfacing. Graphics. Using PHP in HTML Documents.


6. IMP.

GPL and GNU Library General Public License.

Use of IMP Under the GNU Public License.

What Is IMP?

IMP Description.

IMP Installation.

Obtaining the Software. Configuring the Program. Installing IMP.

Testing IMP.

Setting Up User Accounts. Connecting to IMP.

Using IMP. How IMP Works.

What IMP Does for You. Getting Online Help for IMP.

Troubleshooting the Install. Everyday Use of IMP.

Customizing IMP. Email Inside an Office. Email on the Internet.

Appendix A. PHP Language Reference In this Appendix.

Basic Syntax. Variables and Types.

Arrays. Integers. Floating Point. Objects. Resource. Strings. Type Casting and Conversion. Predefined Variables. Variable Scoping. Variable Variables. External Variables.

Constants and Expressions. Operators.

Arithmetic Operators. Comparison Operators. Execution Operators. Assignment Operators. Logic Operators. Reference Operators. String Operator.

Program Flow Control Statements.

The if Statement. The else Statement. The elseif Statement. The while Statement. The do/while Statement. The for Statement. The switch Statement. The break Statement. The continue Statement. The require and include Statements.

User-Defined Functions. Classes. Built-In Functions.

Arrays. I/O. Apache Server-Specific. Calendar and Date / Time. Databases. Data Manipulation. Imaging. New Image Functions in PHP 4. IMAP. Math. Miscellaneous. PHP Information and Options. String Functions. URL Functions. Variable Functions.



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership