Database-Driven Web Development

This book will teach you the essential knowledge required to be a successful and productive web developer with the ability to produce cutting-edge websites utilizing a database.

This updated edition starts with the fundamentals of web development before delving into Perl and MySQL concepts such as script and database modelling, script-driven database interactions, content generation from a database, and information delivery from the server to the browser and vice versa. The only skills required to get the most from this book are basic knowledge of how the Internet works and a novice skill level with Perl and MySQL. The rest is intuitively presented code that most people can quickly and easily understand and employ. An extensive selection of practical, fully functional programming constructs in six different programming languages will give you the knowledge and tools required to create eye-catching, capable, and functionally impressive database-driven websites. 

Author Thomas Valentine has taken the concepts presented in the first edition of this book to new heights, offering in-depth discussions of each area of functionality required to develop fully formed database-driven web applications. He has expanded on the examples presented in the first edition and has included some very interesting and useful programming techniques for your consideration. Upon completing this book, you’ll have gained the benefit of the author’s decades worth of experience and will be able to apply your new knowledge and skills to your own projects.

What You Will Learn

• Install, configure and use a trio of software packages (Apache Web Server, MySQL Database Server, and Perl Scripting Server)
• Create an effective web development workstation with databases in mind
• Use the PERL scripting language and MySQL databases effectively
• Maximize the Apache Web Server 

Who This Book Is For

Those who already know web development basics and web developers who want to master database-driven web development. The skills required to understand the concepts put forth in this book are a working knowledge of PERL and basic MySQL. 

Table of Contents

Chapter 1: Database-Driven Web Development Fundamentals

Chapter 2: Perl CGI and MySQL Essentials

Chapter 3: Essential MySQL Skills

Chapter 4: Nuts and Bolts

Chapter 5: Understanding the Document Object Model (DOM)

Chapter 6: Practical JavaScript Concepts and Projects

Chapter 7: Installing and Using the Perl Server

Chapter 8: Installing and Using the MySQL Database Server

Chapter 9: Installing and Using the Apache Web Server

Chapter 10: Scripted Email: Using sendmail

Chapter 11: A Database-Driven Menu System

Appendix A: From Flat File to Database

Appendix B: Internet Socket Programming Using Perl

Appendix C: Interprocess Communication Essentials

About the Author

Thomas Valentine has 20 years of experience as both a professional web developer and writer. He is a LAMP, Perl, PHP and MySQL web developer, programmer and expert. He writes for various magazines and web sites and has been a technical consultant for large scale, database driven web sites such as FedEx.ca and Texas Instruments (ti.com).