MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites. It shows how to use Perl's DBI database access module, pairing it with with the CGI.pm module that allows Web pages and forms to be generated and processed easily. These tools provide developers with a solid foundation for creating applications that incorporate database content to create dynamic, up-to-date Web sites. The book employs a practical learn-by-doing approach that demonstrates development techniques by building complete applications, not just fragmentary pieces. It shows what to do at each step of the way during the process of building live, working examples. Applications are fully explained so you can understand how they work and apply the techniques they illustrate to your own projects.

The only book to address using cache to enhance and speed up Web application development Developers use Apache, MySQL, memcached, and Perl to build dynamic Web sites that store information within the MySQL database; this is the only book to address using these technologies together to alleviate the database load in Web development Covers each of the four systems and shows how to install, set up, and administer them; then shows the reader how to put the parts together to start building applications Explains the benefits of a base perl library for code re-use, and provides sample applications that demonstrate in a practical way the information covered in the previous chapters Examines monitoring, performance, and security, with a problem-solving chapter that walks the reader through solving real-world issues

The authors provide the most useful, practical information on a broad range of open source technologies. This practical guide presents a survey of LAMP technologies, and shows how these solutions can be implemented securely while improving reliability and cutting costs. The book focuses on the most important core material necessary for the developer to hit the ground running and begin building applications right away.

Learn to operate at a professional level with HTML, CSS, DOM, JavaScript, PERL and the MySQL database. With plain language explanations and step-by-step examples, you will understand the key facets of web development that today’s employers are looking for. Encapsulating knowledge that is usually found in many books rather than one, this is your one-stop tutorial to becoming a web professional. You will learn how to use the PERL scripting language and the MySQL database to create powerful web applications. Each chapter will become progressively more challenging as you progress through experimentation and ultimately master database-driven web development via the web applications studied in the last chapters. Including practical tips and guidance gleaned from 20+ years of working as a web developer, Thomas Valentine provides you with all the information you need to prosper as a professional database-driven web professional. What You'll Learn Leverage standard web technologies to benefit a database-driven approach Create an effective web development workstation with databases in mind Use the PERL scripting language and the MySQL database effectively Maximize the Apache Web Server Who This Book Is For The primary audience for this book are those who know 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 are a working knowledge of PERL and basic MySQL.

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

A new, updated and revised edition of the best-selling #1 book on any open source programming topic.

Introduces techniques for building applications that integrate large databases with web interfaces. Using a three-tier architecture, the book focuses on the middle tier and the application logic that brings together the fundamentally different client and database tiers. The authors explain the principles behind searching, browsing, storing user data, validating user input, managing user transactions, and security. Annotation copyrighted by Book News, Inc., Portland, OR.