Sams Teach Yourself PHP, MySQL and Apache All in One [With CDROM] (Sams Teach Yourself All in One)

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.

Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web application development and HTML/CSS, and you can find translations of her work in 18 different languages.

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

CD-ROM Includes

A complete PHP, MySQL, and

Apache starter kit for Windows^®, Linux^®, or Mac^® OS X.

¿

• Updated to cover the latest versions of PHP, MySQL and Apache, while including new material on incorporating JavaScript and Ajax in PHP-based web applications
• Carefully walks through setting up PHP, MySQL, and Apache, and then using them together
• Short, simple lessons teach hands-on skills readers can use immediately
• CD contains all software needed to use these technologies on Windows, Mac, and Linux

¿

¿

Sams Teach Yourself PHP, MySQL, and Apache All in One, Fifth Edition brings together everything beginners need to build powerful web applications with PHP 5.3, MySQL 5.1/5.x, and the latest versions of Apache - whether they use Windows, Mac, or Linux platforms. Bestselling author Julie Meloni (Sams Teach Yourself HTML and CSS in 24 Hours) teaches simply and clearly, through brief, hands-on lessons focused on knowledge you can apply immediately. Meloni covers all the building blocks of practical web development with PHP and MySQL, integrating modern techniques and new software capabilities throughout. Each lesson builds on what's come before, showing how to configure PHP, MySQL, and Apache, and then use them together to create integrated solutions. Coverage includes: " Mastering PHP core features, including flow control, functions, arrays, and objects " Using strings, dates/times, forms, cookies, user sessions, files/directories, and images " Building AJAX-style applications " Designing effective databases using SQL, transactions, and stored procedures " Creating address books, mailing lists, forums, calendars, and storefronts " Logging, monitoring, and restricting access to web applications " Working with XML and connecting to web services " Administering and tuning web applications - including security, performance, and virtual hosting

PART I. Getting Up and Running

1. Installation QuickStart Guide

2. Installing and Configuring MySQL

3. Installing and Configuring Apache

4. Installing and Configuring PHP

PART 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

PART 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

14. Working with Images

PART IV. PHP and MySQL Integration

15. Understanding the Database Design Process

16. Learning Basic SQL Commands

17. Using Transactions and Stored Procedures in MySQL

18. Interacting with MySQL Using PHP

PART 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 and Shopping Cart Mechanism

23. Creating a Simple Calendar

24. Restricting Access to Your Applications

25. Logging and Monitoring Web Server Activity

26. Application Localization

27. Working with XML

28. Connecting to Web Services

PART 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