Book description
A new edition of this title is available, ISBN-10: 067232976X ISBN-13: 9780672329760
You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesn't allow potential customers to purchase anything online. Don't risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache are three popular open-source tools that can work together to help you create a dynamic website, such as an online shopping experience. Sams Teach Yourself PHP, MySQL and Apache All in One is a complete reference manual for all three development tools. You will learn how to install, configure and set up the PHP scripting language, use the MySQL database system, and work with the Apache Web server. Then you'll take it a step further and discover how they work together to create a dynamic website. Use the book and the included CD to create a simple website, as well as a mailing list, online address book, shopping cart and storefront. Updated to reflect the most recent developments in PHP and MySQL, including the final stable release of MySQL 5.0, you will open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.
Table of contents
- Copyright
- About the Author
- Acknowledgements
- We Want to Hear from You!
- Introduction
-
I. Laying the Groundwork
- 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
-
13. Working with Files and Directories
- Including Files with include()
- Validating Files
- Creating a Function That Performs Multiple File Tests
- 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
Product information
- Title: Sams Teach Yourself PHP, MySQL and Apache: All in One, Third Edition
- Author(s):
- Release date: June 2006
- Publisher(s): Sams
- ISBN: 9780672328732
You might also like
book
Sams Teach Yourself PHP, MySQL™ and Apache in 24 Hours
Sams Teach Yourself PHP, MySQL, and Apache in 24 Hours combines coverage of three popular open-source …
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
Sams Teach Yourself PHP, MySQL® and Apache All in One, Second Edition
You own your own business. You have also created a website for your business that details …
book
Sams Teach Yourself PHP, MySQL® and Apache All in One
A new edition of the best selling book that covers three popular open-source tools in one …