Apache, MySQL, and PHP Web Development All-in-One Desk Reference For Dummies* Covers the entire open source Web platform known as LAMP, which includes Linux, Apache, MySQL, and PHP, the basis for many dynamic data-driven Web sites * Seven convenient minibooks provide easy reference on open source and team development, working with Linux and Apache, automating Web sites with Perl, developing front-end applications with Tcl/TK, creating dynamic Web pages with PHP, accessing Web databases with MySQL, and processing Web files with regular expressions * Includes valuable, hard-to-find coverage of collaboration, file sharing, and version control with CVS * PHP is running on over nine million sites, with an average increase of 6.5 percent monthly over the past two years; Apache Web servers handle seventy percent of Web content |
Contents
Configuring Linux | 9 |
Configuring Windows | 23 |
Ten ThirdParty Packages That Enhance Security | 33 |
Building an Apache Web Site | 41 |
Introducing the Apache Web Server | 43 |
Taking a Look at the Apache Architecture | 49 |
Installing Apache | 51 |
Configuring Apache | 67 |
PHP Web Pages for Dynamic Content | 345 |
What You Can Do with PHP | 347 |
Writing ServerSide Scripts | 353 |
Storing Information | 367 |
Controlling the Program Flow | 385 |
Arrays and Functions | 401 |
Interacting with HTML | 417 |
Advanced Programming with PHP | 435 |
Apache Modules | 87 |
Ten Security Tips | 93 |
Perl Web Site Automation | 97 |
Introducing Perl | 99 |
Simple Data Types | 107 |
Comparing and Testing Variables | 125 |
Controlling the Structure of Your Program | 137 |
Processing Text Files and Directories | 157 |
Advanced Perl Coding | 169 |
Perl and CGI Scripts | 191 |
Writing CGI Scripts with CGI | 197 |
Displaying Errors and Warnings | 204 |
Ten Useful Perl Functions | 207 |
TclTk Front End Development | 217 |
What Are Tcl and Tk? | 219 |
Processing Variables and Expressions | 227 |
Controlling the Structure | 249 |
Building Procedures | 265 |
Manipulating Files | 273 |
Programming with the Tcl Packages | 283 |
Designing GUIs with Tk | 291 |
Arranging Controls Drawing Pictures and Handling Text | 309 |
Displaying Standard Dialog Boxes in Tk | 333 |
Ten Useful TclTk Tools | 341 |
Creating Graphics | 453 |
Modeling Data with Classes | 465 |
Ten Ways to Enhance Your Web Site | 475 |
MySQL Databases on the Web | 487 |
What Is MySQL? | 489 |
Managing Databases and Tables | 505 |
Relating Your Data | 519 |
Accessing MySQL from PHP | 537 |
Querying with SQL and PHP | 553 |
Accessing MySQL from Perl | 567 |
Creating a Username System for Your Web Site | 577 |
Ten Ways to Enhance a Web Site with Databases | 599 |
Processing Web Files with | 607 |
Following the Syntax of Regular Expressions | 623 |
Customizing Searching and Replacing | 637 |
Grouping and Capturing | 649 |
Joining Splitting and Making Up | 659 |
Processing Multiple Lines and Files | 667 |
Processing HTML Files | 677 |
Ten Regular Expression Gotchas | 687 |
Appendixes | 693 |
Sharing Files with CVS | 695 |
Understanding OpenSource Licenses | 707 |
Copyright | |