Featuring new information on the features and functions of the latest upgrades—MySQL 4.0.X, PHP5, and Apache 2.0—this book boasts a working Web site application and numerous updates throughout the text. The multi–platform approach addresses installation and usage on both Linux® and Windows®, and two common–themed, reusable Web sites are examined. Upon completion of this book, you′ll be able to create well designed, dynamic Web sites using open source tools.
What you will learn from this book
- Syntax, functions, and commands of PHP, Apache, and MySQL and how they can be used together in Web development
- The ins and outs of data manipulation
- The object–oriented programming advantages of PHP5
- Ways of using PHP for connecting HTML–based Web pages to a backend database for dynamic content
- How MySQL easily stores, updates, and accesses information
This book is for beginners who are new to PHP and who need to learn quickly how to create Web sites using open source tools. Some basic HTML knowledge is helpful but not essential.
Part I: Getting Started.
Chapter 1: Configuring Your Installation.
Part II: Movie Review Web Site.
Chapter 2: Creating PHP Pages Using PHP5.
Chapter 3: Using PHP5 with MySQL.
Chapter 4: Using Tables to Display Data.
Chapter 5: Form Elements: Letting the User Work with Data.
Chapter 6: Letting the User Edit the Database.
Chapter 7: Manipulating and Creating Images with PHP.
Chapter 8: Validating User Input.
Chapter 9: Handling and Avoiding Errors.
Part III: Comic Book Fan Site.
Chapter 10: Building Databases.
Chapter 11: Sending E–mail.
Chapter 12: User Logins, Profiles, and Personalization.
Chapter 13: Building a Content Management System.
Chapter 14: Mailing Lists.
Chapter 15: Online Stores.
Chapter 16: Creating a Bulletin Board System.
Chapter 17: Using Log Files to Improve Your Site.
Chapter 18: Troubleshooting.
Appendix A: Answers to Exercises.
Appendix B: PHP Quick Reference.
Appendix C: PHP5 Functions.
Appendix D: MySQL Data Types.
Appendix E: MySQL Quick Reference.
Appendix F: Comparison of Text Editors.
Appendix G: Choosing a Third–Party Host.
Appendix H: An Introduction to PEAR.
Appendix I: AMP Installation.