Home > Store

Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition

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

Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition

Premium Website

  • Sorry, this book is no longer in print.
Not for Sale



  • Fully updated to reflect the latest versions of PHP, MySQL, and Apache.
    • Teaches students Web development techniques they will be able to utilize for many years to come.

  • Task-focused, step-by-step coverage of installation, configuration, and usage—Practical, one-step-at-a-time coverage of all the skills students need to build basic dynamic Web sites and applications.
    • Covers everything students need to know to become productive Web developers as quickly as possible.

  • Easy introduction to the essentials of PHP scripting—Covers basic language elements and building blocks; flow control, functions, simple SQL commands, and more.
    • Gives students a firm foundation in the key concepts they need to script basic Web applications, so they can rapidly deepen their skills and build more sophisticated applications.

  • Broad coverage of fundamental Web development techniques—Covers topics ranging from basic SQL queries to Apache virtual hosting and MySQL tuning.
    • Familiarizes students with a wide range of tasks they may be called upon to perform as Web developers and Web application administrators.

  • Several sample applications—Walks students step-by-step through building discussion forums, mailing list managers, online address books, shopping carts, and e-commerce storefronts.
    • Gives students hands-on practice with a broad cross-section of the types of applications they may be involved in building.

  • Exercises and review questions in every chapter—Includes exercises and review questions that can easily be tailored to the needs of specific courses and instructors.
    • Provides constant feedback and reinforcement to ensure that students understand the material they are learning.

  • Extensive collection of tips and ideas—Offers practical Web development tips throughout.
    • Gives students the benefits of the authors extensive experience as a professional Web developer.

  • Complete learning Starter Kit on CD-ROM—Makes it easy for students to install a safe and foolproof learning environment for either Windows or Linux-based PCs.
    • Allows students to get started immediately, without worrying about finding software or troubleshooting installations.


  • Copyright 2004
  • Edition: 2nd
  • Premium Website
  • ISBN-10: 0-672-32620-5
  • ISBN-13: 978-0-672-32620-2

A new edition of the best selling book that covers three popular open-source tools in one complete Starter Kit package.

  • Revised and updated to reflect major changes in new versions of PHP, MySQL, and PHP 5.
  • Carefully steps the reader through the basic set up of PHP, MySQL, and Apache, and shows how to combine these technologies to quickly create simple interactive Web applications.
  • CD-ROM allows the reader to install a safe, foolproof learning environment for either a Windows or Linux-based PC.

Sample Content

Online Sample Chapter

Installing and Configuring PHP

Table of Contents


Who Should Read This Book? How This Book Is Organized. Conventions Used in This Book.


1. 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.

2. 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.

3. 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.


4. The Building Blocks of PHP.

Variables. Data Types. Operators and Expressions. Constants. Summary. Q&A. Workshop.

5. Flow Control Functions in PHP.

Switching Flow. Loops. Code Blocks and Browser Output. Summary. Q&A. Workshop.

6. 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.

7. Working with Arrays and Objects.

What Is an Array? Creating Arrays. Some Array-Related Functions. Creating an Object. Object Inheritance. Summary. Q&A. Workshop.


8. 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.

9. 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.

10. 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.

11. 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.

12. 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.

13. 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.


14. 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.

15. 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.

16. Interacting with MySQL Using PHP.

Connecting to MySQL with PHP. Working with MySQL Data. Summary. Workshop.


17. Managing a Simple Mailing List.

Developing the Subscription Mechanism. Developing the Mailing Mechanism. Summary. Q&A. Workshop.

18. 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.

19. 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.

20. Creating an Online Storefront.

Planning and Creating the Database Tables. Displaying Categories of Items. Displaying Items. Summary. Workshop.

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.

22. Creating a Simple Calendar.

Building a Simple Display Calendar. Creating a Calendar library. Summary. Q&A. Workshop.

23. 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. Q&A. Workshop.

24. Logging and Monitoring Web Server Activity.

Standard Apache Access Logging. Standard Apache Error Logging. Managing Apache Logs. Logging Custom Information to a Database. Summary. Q&A. Workshop.

25. Application Localization.

About Internationalization and Localization. About Character Sets. Environment Modifications. Creating a Localized Page Structure. Summary. Q&A. Workshop.


26. Apache Performance Tuning and Virtual Hosting.

Scalability Issues. Load Testing with ApacheBench. Proactive Performance Tuning. Preventing Abuse. Implementing Virtual Hosting. Summary. Q&A.

27. Setting Up a Secure Web Server.

The Need for Security. The SSL Protocol. Obtaining and Installing SSL Tools. Managing Certificates. SSL Configuration. Summary. Q&A.

28. 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. Q&A. Workshop.

29. Software Upgrades.

Staying in the Loop. Upgrading MySQL. Upgrading Apache. Upgrading PHP. Summary. Workshop.


30. Features and Backward Compatibility of PHP 5.0.

What's Wrong With PHP 4? The New Object Model. Additional New Features. So, When Should I Upgrade to PHP 5? Summary. Q&A.

31. Features and Backward Compatibility of MySQL 4.1.

Using Subqueries. Internationalization Enhancements. Additional New Functionality. Looking Further Ahead to MySQL 5.0. Summary. Q&A. Workshop.


Appendix A: Installing MySQL, Apache, and PHP from the CD-ROM.

Linux/Unix Installation. Windows Installation. Troubleshooting.




The errata for the book is available here in Adobe Portable Document Format (PDF) format. You will need Adobe's Acrobat Reader to view these files. If you do not have the Acrobat Reader installed, you may go to Adobe Systems' web site to download this free reader.

Click on the links below to display the PDF file in a new window. Right-click on the link and select Save As if you want to download it to your hard drive.

Errata for the book - 58 kb -- 0672326205errata.pdf

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership