Book description
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. Learn how they work individually and more importantly, how they work together to create your 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. Open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.
Table of contents
- Copyright
- About the Authors
- Acknowledgments
- 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 and Objects
-
III. Getting Involved with the Code
- 9. Working with Strings, Dates, and Times
- 10. Working with Forms
- 11. Working with Cookies and User Sessions
- 12. Working with Files and Directories
- 13. Working with the Server Environment
- 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. Interacting with MySQL Using PHP
-
V. Basic Projects
- 18. Managing a Simple Mailing List
- 19. Creating an Online Address Book
- 20. Creating a Simple Discussion Forum
- 21. Creating an Online Storefront
- 22. Creating a Shopping Cart Mechanism
- 23. Creating a Simple Calendar
- 24. Restricting Access to Your Applications
- 25. Logging and Monitoring Web Server Activity
- 26. Application Localization
-
VI. Administration and Fine-Tuning
- 27. Apache Performance Tuning and Virtual Hosting
- 28. Setting Up a Secure Web Server
- 29. Optimizing and Tuning MySQL
- 30. Software Upgrades
- VII. Looking Toward the Future
Product information
- Title: Sams Teach Yourself PHP, MySQL® and Apache All in One, Second Edition
- Author(s):
- Release date: December 2004
- Publisher(s): Sams
- ISBN: 9780672327254
You might also like
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 …
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 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, Fourth Edition
Sams Teach Yourself PHP, MySQL® and Apache All in One Fourth Edition Julie C. Meloni Starter …