Sams Teach Yourself PHP, MySQL and Apache All in One (5th Edition)

This book is the Chinese translation of the 5th edition of Sams Teach Yourself PHP, MySQL and Apache All in One, a classic introductory textbook from the American publisher Sams. Aimed at complete beginners or novice readers, it teaches the PHP scripting language, the MySQL relational database, and the Apache web server—three open-source tools—as a single integrated whole. The book is divided into 6 parts and 33 chapters. Part 1, "Basics," first guides readers to quickly set up a development environment using a third-party integrated package (XAMPP), then explains the installation, configuration, and security settings of MySQL, Apache, and PHP on Linux/UNIX, Mac OS X, and Windows. Part 2, "PHP Language Structure," covers language elements such as variables, operators, flow control, functions, arrays, and objects. Part 3, "Deeper Programming," moves into intermediate topics including string and date handling, forms, cookies and user sessions, file and directory operations, and image processing. Part 4, "PHP and MySQL Integration," begins with the database design process and introduces basic SQL commands, transactions and stored procedures, and methods for connecting to and operating MySQL with PHP. Part 5, "Basic Projects," uses a set of small projects—a mailing list, an online address book, a discussion forum, an online store and shopping cart, a calendar, access restriction, log monitoring, application localization, and XML—to tie what has been learned into complete applications. Part 6, "Management and Optimization," discusses Apache performance tuning and virtual hosts, building a secure web server, MySQL optimization and tuning, software upgrades, and using application frameworks. The book advances in a "concept—demonstration—exercise" rhythm, with a summary, Q&A, and practical exercises in each chapter, and sample code on the accompanying CD, making it suitable as a self-study guide or course reference.