MySQL - PHP Database Applications, Second Edition
Welcome. If you are thumbing through these pages, you’re probably considering writing Web-based applications with PHP and MySQL. If you decide to go with these tools, you’ll be in excellent company. Thousands of developers — from total newbies to programmers with years of experience — are turning to PHP and MySQL for their Web-based projects, and for good reason.
Both PHP and MySQL are easy to use, fast, free, and powerful. If you want to get a dynamic Web site up quickly, there are no better choices. The PHP scripting language was built for the Web. All the tasks common to Web development can be performed in PHP with an absolute minimum of effort. Similarly, MySQL excels at tasks common to dynamic Web sites. Whether you’re creating a content-management system or an e-commerce application, MySQL is a great choice for your data storage
Part I: Working with MySQLBefore you code any PHP scripts you need to know how to design a database, create tables in your database, and get the information you want from the database. Part I of this book shows you just about everything you need to know to work with MySQL.
Part II: Working with PHP
As an applications developer, you will spend the bulk of your time writing scripts that access the database and present HTML to a user’s browser. Part II starts by showing you the basics of the PHP scripting language, covering how PHP works with variables, conditions, and control structures. Part II also covers many of PHP’s functions and discusses techniques for writing clean, manageable code.
Part III: Simple Applications
In this part we present two of the nine applications in this book: a guestbook and a survey. Here you see the lessons from Parts I and II put into practice as we build working applications.
Part IV: Not So Simple Applications
Here the applications become more complex, as we present applications commonly used on the Web. You see how you can design a content management system, a discussion board, a shopping cart, and other useful applications. Along the way we show you some tips and techniques that should be helpful as you write your applications.
Part V: Appendixes
The appendixes cover several topics of interest to the MySQL/PHP developer. In them you can find installation and configuration instructions, quick reference guides to PHP and MySQL functions, a regular expressions overview, and guides to MySQL administration. In addition, you can find a few helpful resources, some snippets of code, and instructions on using the CD-ROM.