Book description
Sams Teach Yourself PHP, MySQL® and Apache All in One
Fourth Edition
Julie C. Meloni
Starter Kit
CD-ROM includes a complete starter kit for Windows®, Linux®, and Mac® OS X
In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies.
Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up.
Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production.
Learn how to…
Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server
Get these technologies to work together to create a dynamic, database-backed website
Interact with MySQL using PHP
Work with forms and files
Create a web-based discussion forum or mailing list
Add a storefront and shopping cart to your site
Optimize your MySQL databases
Fine-tune the Apache server’s performance
Restrict access to your applications
Set up a secure web server
Julie C. Meloni is the technical director for i2i Interactive, a multimedia company located in Los Altos, California. She has been developing web-based applications since the early days of the web, and is the author of several books and articles on web-based programming languages and database topics, including Sams Teach Yourself MySQL in 24 Hours.
CD-ROM Includes
A complete PHP, MySQL, and Apache starter kit for Windows®, Linux®, or Mac® OS X.
Category: Web Development
Covers: PHP 5.2, MySQL 5, Apache 2.2
User Level: Beginning
Table of contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
-
I. Getting Up and Running
- 1. Installation QuickStart Guide
- 2. Installing and Configuring MySQL
-
3. Installing and Configuring Apache
- Current and Future Versions of Apache
- Choosing the Appropriate Installation Method
- Installing Apache on Linux/UNIX
- Installing Apache on Mac OS X
- 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
- 4. Installing and Configuring PHP
-
II. PHP Language Structure
- 5. The Building Blocks of PHP
- 6. Flow Control Functions in PHP
- 7. Working with Functions
- 8. Working with Arrays
- 9. Working with Objects
-
III. Getting Involved with the Code
- 10. Working with Strings, Dates, and Time
- 11. Working with Forms
-
12. Working with Cookies and User Sessions
- Introducing Cookies
- Setting a Cookie with PHP
- Deleting a Cookie with PHP
- Session Function Overview
- Starting a Session
- Working with Session Variables
- Passing Session IDs in the Query String
- Destroying Sessions and Unsetting Variables
- Using Sessions in an Environment with Registered Users
- Summary
- Q&A
- Workshop
-
13. Working with Files and Directories
- Including Files with include()
- Validating 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
- Opening Pipes to and from Processes Using popen()
- Running Commands with exec()
- Running Commands with system() or passthru()
- Summary
- Q&A
- Workshop
- 14. Working with Images
-
IV. PHP and MySQL Integration
- 15. Understanding the Database Design Process
-
16. 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
- 17. Using Transactions and Stored Procedures in MySQL
- 18. Interacting with MySQL Using PHP
-
V. Basic Projects
- 19. Managing a Simple Mailing List
- 20. Creating an Online Address Book
- 21. Creating a Simple Discussion Forum
- 22. Creating an Online Storefront
- 23. Creating a Shopping Cart Mechanism
- 24. Creating a Simple Calendar
- 25. Restricting Access to Your Applications
- 26. Logging and Monitoring Web Server Activity
- 27. Application Localization
- 28. Working with XML
-
VI. Administration and Fine-Tuning
- 29. Apache Performance Tuning and Virtual Hosting
- 30. Setting Up a Secure Web Server
- 31. Optimizing and Tuning MySQL
- 32. Software Upgrades
- Inside Front Cover
- Inside Back Cover
Product information
- Title: Sams Teach Yourself PHP, MySQL and Apache All in One, Fourth Edition
- Author(s):
- Release date: June 2008
- Publisher(s): Sams
- ISBN: 9780768680683
You might also like
book
Sams Teach Yourself PHP, MySQL® and Apache All in One, Fifth Edition
In just a short time, you can learn how to use PHP, MySQL, and Apache together …
book
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
When static HTML pages no longer cut it, you need to step up to dynamic, database-driven …
book
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition
Learn PHP and MySQL programming— the quick and easy way! Easy visual approach uses demonstrations and …
book
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth Edition
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven …