Sams Teach Yourself PHP, MySQL and Apache All-in-One

✍ Scribed by Julie C. Meloni

• Publisher: Sams
• Year: 2003
• Tongue: English
• Leaves: 645
• Edition: Bk&CD-Rom
• Category: Library

✦ Synopsis

Three popular Web development tools, covered together in an easy-to-understand book. Carefully steps the reader through the basic installation and set-up of PHP, MySQL, and Apache. Shows the beginner how to combine these technologies to quickly create simple interactive Web applications. CD-ROM Starter Kit allows the reader to easily install a safe, foolproof learning environment for either a Windows- or Linux-based PC. Sams Teach Yourself PHP, MySQL, and Apache in 24 Hours combines coverage of these three popular open-source Web development tools into one easy-to-understand book - and it comes packaged with one easy-to-use Starter Kit CD for Windows or Linux. The book teaches the reader to install, configure and set up the PHP scripting language, the MySQL database system, and the Apache Web server. By the end of this book the reader will understand how these technologies work, and - more importantly - how they can work together to create a dynamic Web site. After creating a simple Web site using these tools, the reader will be able to manage a simple mailing list, and to create an online address book, shopping cart, and storefront. The book also teaches the reader how to fine tune Apache and MySQL, and covers simple Web server security. Julie Meloni is the technical director for i2i Interactive, a multimedia company located in Campbell, CA. 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, such as Sams Teach Yourself MySQL in 24 Hours.

✦ Table of Contents

Table of Contents......Page 1
Introduction......Page 30
Part I: Laying the Groundwork......Page 34
1 Installing and Configuring MySQL......Page 36
2 Installing and Configuring Apache......Page 56
3 Installing and Configuring PHP......Page 80
Part II: PHP Language Structure......Page 98
4 The Building Blocks of PHP......Page 100
5 Flow Control Functions in PHP......Page 122
6 Working with Functions......Page 144
7 Working with Arrays and Objects......Page 164
Part III: Getting Involved with the Code......Page 180
8 Working with Strings, Dates and Time......Page 182
9 Working with Forms......Page 210
10 Working with User Sessions......Page 232
11 Working with Files and Directories......Page 242
12 Working with the Server Environment......Page 266
13 Working with Images......Page 274
Part IV: PHP and MySQL Integration......Page 289
14 Learning the Database Design Process......Page 291
15 Learning Basic SQL Commands......Page 302
16 Interacting with MySQL Using PHP......Page 350
Part V: Basic Projects......Page 362
17 Managing a Simple Mailing List......Page 364
18 Creating an Online Address Book......Page 376
19 Creating a Simple Discussion Forum......Page 400
20 Creating an Online Storefront......Page 416
21 Creating a Shopping Cart Mechanism......Page 428
22 Creating a Simple Calendar......Page 442
23 Restricting Access to Your Applications......Page 456
24 Logging and Monitoring Web Server Activity......Page 478
25 Application Localization......Page 496
Part VI: Administration and Fine Tuning......Page 508
26 Apache Performance Tuning and Virtual Hosting......Page 510
27 Setting Up a Secure Web Server......Page 528
28 Optimizing and Tuning MySQL......Page 544
29 Software Upgrades......Page 562
Part VII: Looking Toward the Future......Page 568
30 Features and Backwards-Compatibility of PHP 5.0......Page 570
31 Features and Backwards-Compatibility of MySQL 4.1......Page 576
Part VIII: Appendix......Page 584
APPENDIX A Installing MySQL, Apache, and PHP from the CD-ROM......Page 586
Index......Page 598