Perl Cookbook: Solutions and Examples for Perl Programmers

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well. Other recipes in the book teach you to: Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped. Find a Perl programmer, and you'll find a copy of Perl Cookbook nearby. Perl Cookbook is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. The book contains hundreds of rigorously reviewed Perl "recipes" and thousands of examples ranging from brief one-liners to complete applications.The second edition of Perl Cookbook has been fully updated for Perl 5.8, with extensive changes for Unicode support, I/O layers, mod_perl, and new technologies that have emerged since the previous edition of the book. Recipes have been updated to include the latest modules. New recipes have been added to every chapter of the book, and some chapters have almost doubled in size.Covered topic areas include: Manipulating strings, numbers, dates, arrays, and hashes Pattern matching and text substitutions References, data structures, objects, and classes Signals and exceptions Screen addressing, menus, and graphical applications Managing other processes Writing secure scripts Client-server programming Internet applications programming with mail, news, ftp, and telnet CGI and mod_perl programming Web programming Since its first release in 1998, Perl Cookbook has earned its place in the libraries of serious Perl users of all levels of expertise by providing practical answers, code examples, and mini-tutorials addressing the challenges that programmers face. Now the second edition of this bestselling book is ready to earn its place among the ranks of favorite Perl books as well.Whether you're a novice or veteran Perl programmer, you'll find Perl Cookbook , 2nd Edition to be one of the most useful books on Perl available. Its comfortable discussion style and accurate attention to detail cover just about any topic you'd want to know about. You can get by without having this book in your library, but once you've tried a few of the recipes, you won't want to. Find a Perl programmer, and you’ll find a copy of Perl Cookbook nearby. Perl Cookbook is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. The book contains hundreds of rigorously reviewed Perl “recipes” and thousands of examples ranging from brief one-liners to complete applications. \n The second edition of Perl Cookbook has been fully updated for Perl 5.8, with extensive changes for Unicode support, I/O layers, mod_perl, and new technologies that have emerged since the previous edition of the book. Recipes have been updated to include the latest modules. New recipes have been added to every chapter of the book, and some chapters have almost doubled in size. COMPUTERS / Programming Languages / JavaScript Perl Cookbook is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. The first edition of Perl Cookbook was published in 1998 to universal acclaim. It quickly became known not only as one of the best books on Perl, but also as one of the best programming books for any language. With Perl Cookbook, a new type of programming book had been invented: not just a collection of tips and tricks, but a book that taught the nuances of programming 1 Strings 2 Numbers 3 Dates and Times 4. Arrays 5. Hashes 6. Pattern Matching 7. File Access 8. File Contents 9. Directories 10. Subroutines 11. References and Records 12. Packages, Libraries, and Modules 13. Classes, Objects, and Ties 14. Database Access 15. Interactivity 16. Process Management and Communication 17. Sockets 18. Internet Services 19. CGI Programming 20. Web Automation 21. mod_perl 22. XML The Perl Cookbook is a collection of problems, solutions, and practical examples for anyone using the Perl programming language. The examples range in complexity from brief one-liners to complete applications. The publisher represents it as a companion volume to "Programming Perl", also by Christiansen. Forward by Larry Wall. 733 pages. Paperback. A comprehensive guide to the programming language covers updating text and binary files, subroutines, libraries, data structures, signals, screen addressing, and client-server programming. 'Solutions & expamples for Perl programmers'--CoverIncludes bibliographical references (p. xxvi-xxvii) and index