Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
39 used & new from $5.49

Have one to sell? Sell yours here
 
   
MySQL and Perl for the Web (Landmark)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

MySQL and Perl for the Web (Landmark) (Paperback)

by Paul DuBois (Author)
4.4 out of 5 stars See all reviews (26 customer reviews)

List Price: $44.99
Price: $30.89 & this item ships for FREE with Super Saver Shipping. Details
You Save: $14.10 (31%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Monday, July 20? Choose One-Day Shipping at checkout. Details
17 new from $22.76 22 used from $5.49
Also Available in: List Price: Our Price: Other Offers:
Paperback (Bargain Price) 12 used & new from $12.89

Frequently Bought Together

Customers buy this book with Programming the Perl DBI by Tim Bunce

MySQL and Perl for the Web (Landmark) + Programming the Perl DBI
  • This item: MySQL and Perl for the Web (Landmark) by Paul DuBois

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Programming the Perl DBI by Tim Bunce

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details


Customers Who Bought This Item Also Bought


Editorial Reviews

Amazon.com Review
Once in a while a book comes along that covers an area of development that has previously been largely ignored. Both MySQL and Perl are well documented in several tutorials, but in-depth coverage of Web development using the combination of the two is rare. MySQL and Perl for the Web zeroes in on this interesting pairing, illustrating practical application development possibilities using this popular duo.

The book is perfect for developers of Web sites running on Apache on Unix. Loyalties vary in terms of operating systems, Web servers, and scripting languages, but those who find their home in the Unix and Perl environments will find this book right up their alleys. The target audience is developers somewhat familiar with Perl and the Unix-based Web server environment, but you'll find the book illustrative even if your knowledge is sketchy.

After showing how to make database connections using Perl and MySQL, author Paul DuBois dives into some useful real-world examples to help you build your skills. He shows how to implement a simple to-do list application, an online product registration site, contests, online polls, image databases, an online greeting card service, and more. There is also excellent coverage of search facilities and session management.

The sample code for the applications in this text is presented in small pieces in context with the discussion; most of the space is devoted to explanations of the issues and implementation. All of the code is available, however, from the book's companion Web site. This tutorial is an excellent way for Perl developers to move to the next level of development and make the most of some powerful, free tools. --Stephen W. Plain

Product Description

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.



See all Editorial Reviews

Product Details

  • Paperback: 552 pages
  • Publisher: Sams (August 13, 2001)
  • Language: English
  • ISBN-10: 0735710546
  • ISBN-13: 978-0735710542
  • Product Dimensions: 9 x 7 x 1.3 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars See all reviews (26 customer reviews)
  • Amazon.com Sales Rank: #157,121 in Books (See Bestsellers in Books)

    Popular in this category: (What's this?)

    #75 in  Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL

Look Inside This Book

Citations (learn more)
1 book cites this book:

What Do Customers Ultimately Buy After Viewing This Item?

MySQL and Perl for the Web (Landmark)
77% buy the item featured on this page:
MySQL and Perl for the Web (Landmark) 4.4 out of 5 stars (26)
$30.89
MySQL Cookbook
9% buy
MySQL Cookbook 4.7 out of 5 stars (27)
$31.49
MySQL (4th Edition) (Developer's Library)
9% buy
MySQL (4th Edition) (Developer's Library) 4.6 out of 5 stars (116)
$31.49
Learning MySQL
5% buy
Learning MySQL 4.2 out of 5 stars (12)
$29.69

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(1)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

26 Reviews
5 star:
 (14)
4 star:
 (10)
3 star:
 (1)
2 star:
 (1)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.4 out of 5 stars (26 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
30 of 30 people found the following review helpful:
5.0 out of 5 stars It lacks what...?, October 23, 2001
By "sherzodr" (East Lansing, MI USA) - See all my reviews
If you know some Perl and some MySQL, please, DO by
"MySQL and Perl for the Web" by Paul DeBois and figure out
how those fancy web applications out there are made and learn
how to be able to write one.

Paul's "MySQL and Perl for the Web" touches upon some topics
that NONE OF THE BOOKS out there ever covered in so much details.

The style and examples are amazing. He makes use of Perl5's Object
Oriented features which itself tells you that it's a professional
textbook for professional web-programmers.

The book teaches you neither Perl nor MySQL from basics. It
assumes you already have some basic knowledge of Perl and MySQL.
So it starts off at the most fun part without waisting neither his nor
the readers' time.

Here I'll go over the chapters in case the table of contents
don't tell you much (they didn't to me).

Chapter 1 and chapter 2 go over some basic things that you need
in order to understand and/or try out the examples in the book.

Chapter 2 goes over configurting your MySQL and Apache. I believe
if you are on a hosting service, this should've been done for you already.
It also teaches you to write "A Simple Web-Based Application - To-do List
Maintenance". Although the application doesn't require a lot of
brains to create, but it does cover some basic concepts that
you'll be using all the time in web-programming.

Chapter 3 gives some information on "Improving Performance with mod_perl"
and how to write scripts that work in mod_perl compiled servers.

Chapter 4, "Generating and Proccessing Forms" goes over "Form Anatomy"
and does introduce some concepts of "Form Desgin Issues"

Chapter 5, "Writing form-Based applications" is probably the wealthiest
chapter of the book. Following sections are available under this chapter:
"Product registration", "Using Email from Within Applications", "Running a
Giveaway contest", "Conducting a Poll", "Storing and Retriving Images",
"Electronic Greeting Cards - Send a Friend a Greeting".
This chapter lasts over 80 pages.

Chapter 6, "Automating the Form-Handling process" introduces some
concepts that you can make use of in order to automate the form handling
process through the use of MySQL's table metadata, which is available
through DESC table_name ( or SHOW COLUMNS FROM table_name ) query.
Using his concept I introduced a new module to CPAN.org, MySQL::TableInfo.

Chapter 7, "Performing Searches" covers "Writing a Form-Based Serch
Application" and "Extending" it. It also introduces the concept of
"Link-Based Navigation". It also teaches you how to split the results of the search
over several pages; suppose you have a result of 100 rows in your search, and
you show only 20 results at a page, and provide [previos] and [next] links
so that users could navigate over your pages. Neat, isn't it?

Cahpter 8, "Session Management" was the one I have been wating for so long.
It goes over some "State Maintenance Techqniques" used in web applications, then
introduces the most favorite one, "Active Client Identification" method.
The sections the chapter covers are: "State Maintenance Techqniques", "Implementing
Session Support", "Expiring Sessions", "Storing User Prefernces", "Implementing Resumable
Sessions" and "When Sessions aren't enough"

Chapter 9, "Security and Privacy" teaches you the ways of precaution you could
take against "bad guys" ( hackers? ) to insure the security of your site/database.
Also shows you how to write a login page to provide access to some sensitive information
using the techniques he just mentioned.

Chapter 10, "E-Commerce Applications" covers such topics as Shopping carts,
credit card validation and in the end of the chapter completed a fully operating
commercial web-site.

Although the book concentrates on MySQL, I wrote several applications that make use of
Berkeley Database using the same techniques as Paul suggested. I tell you, I lerned a lot....

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
11 of 11 people found the following review helpful:
4.0 out of 5 stars Mysql and Perl for the Web --fills a gap, November 15, 2001
Mysql and Perl for the Web by Paul Dubois gives you the tools and concepts needed to transit from a basic knowledge of Perl and Mysql to actually getting the two working together in harmony.

Most of what is covered in this book can be found on the web and in mail archives BUT be prepared for many many hours of scouring obscure sites, trying not-so-hot code and out dated examples. I began working with Perl many years ago, but only in the last 2 years have I been using Perl and Mysql in production web sites.

The first thought that came to mind when I thumbed through this book was 'Man I wish I had seen this book a year and a half a go'. Most of the solutions presented I have figured out myself, but after a long time of head banging and trial and error. I've been going through my code and comparing it the methods and examples found in this book and have been able to make many improvements.

The writing is clear and code examples evolve with the concepts presented.

You should have a basic understanding of Perl before digging into this book, or at least have a good Perl reference book handy. You can also download (and try out) scripts and libraries (...)

I do wish I'd seen this book a year or so ago. It would have saved me a lot of time and effort.

-Z

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
7 of 7 people found the following review helpful:
5.0 out of 5 stars Excellent reference for MySQL and Perl, December 18, 2001
By Matt Flaig (Milwaukee, WI) - See all my reviews
MySQL and Perl for the Web by Paul DuBois is one of those slap your forehead, "I wish I had this X months ago" books. A splendid book that fills a real void.

Though not for total beginners - have Paul's excellent previous book "MySQL", as well as the some reference like the Camel book handy if you have little or no background in MySQL or Perl - it is written in a concise, easy to read manner that allows one to fully understand what each application does and how the examples could be the basis for use in their own code.

In addition, it's a fine repository of tips, and not all are limited to MySQL and Perl. For example, the section on configuring Apache for secure connections using mod_ssl and OpenSSL, could easily save a newbie seeking SSL knowledge hours of research over many sites and through many README's.

Each chapter builds on the examples of the previous, from the simple to the complex. The book covers, amongst other subjects ...

Form generation and design
Processing forms
Using e-mail to enhance your web site
Storing and retrieving images
The use of MySQL to power your forms
Effective MySQL table design
Automating form handling
Generating form elements from tables
Forms navigation
Forms error handling
Advanced MySQL statements
Indexing and searching your data
Intermediate to advanced Perl usage
Session Management
Maintenance techniques with sessions
Security and privacy, both remotely and locally
Writing secure applications
E-commerce applications
Implementing different payment collection techniques

In other words, it touches on just about every aspect someone looking to leverage MySQL and Perl for web development could want, all in a single source. I learned a lot from this book and think it's easily worth the price.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

5.0 out of 5 stars A great book to get you up to speed
Disclaimer: I was given a copy of this book on the condition that I would write a review of it. That said, what follows is my opinion. Read more
Published on April 23, 2005 by Joshua J. Kugler

5.0 out of 5 stars An excellent book on both MySQL and Perl.
There are plenty of books about MySQL and PHP in bookstores. Yet, I still prefer Perl as my web page languages, thanks to its powerful regex and the similarity to C grammar (Some... Read more
Published on September 13, 2004 by Xu Qiang

5.0 out of 5 stars This is the most important book in my library (of over 300)
Like many others, I wish I'd seen this book long ago.

The attention to detail and accuracy of the examples is just incredible! Read more

Published on January 29, 2004 by David M. Roberts

5.0 out of 5 stars Clear explanations and excellent examples
This is an excellent book. I knew my way around Perl and had done a few relatively simple CGIs before being handed a project to build an application that would allow 50 or 60... Read more
Published on November 3, 2003 by Stan Burkes

3.0 out of 5 stars MySQL and Perl but no templates?
This isn't a complete review but readers should be aware that this book does NOT cover templates (it doesn't appear in the contents or the index). Read more
Published on August 20, 2003 by David Howorth

4.0 out of 5 stars very good intermediate book
As I emailed Paul DuBois, I wish there was a MySQL-PHP as good as this one. I prefer to write in PHP. Read more
Published on November 13, 2002 by ieee488

5.0 out of 5 stars MySQL + Perl = Wonderful tool
Paul, another wonderfully written book. Both open source technologies are very widely used these days. Read more
Published on January 16, 2002 by Isystek, Inc.

5.0 out of 5 stars Another Must Have by Paul DuBois
I found Mysql and Perl for the Web to be a great companion for Paul's MySQL book. After reading through Mysql and Perl for the Web, I finally feel I have enough working knowledge... Read more
Published on January 3, 2002 by Dennis Rasey

4.0 out of 5 stars THE companion to MySQL by Paul DuBois
If you would like to use MySQL on you webpage you can use this book to get started and going. The book handles all initial setup and gives good descriptins on how to get relevant... Read more
Published on January 3, 2002 by Jane Larsen

4.0 out of 5 stars a solid practicum for beginners
This book covers timely material in a casual, conversational style. I'd recommend it to the working programmer with basic knowledge of Perl and exposure to web and database... Read more
Published on January 2, 2002

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
  Discussion Replies Latest Post
C# or Java? 32 11 days ago
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


$15 Off Olay, Pantene, and More

$15 Off Olay, Pantene, and More
This July, enjoy an extra $15 off select skin and hair care from favorite brands such as Olay, Pantene, Secret, and Ivory.

Shop this offer now

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Buy Three Books, Get a Fourth Free

4-for-3 Books
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.
 

Best Books

Best of the Month
See our editors' picks and more of the best new books on our Best of the Month page.
 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
My Soul to Lose
My Soul to Lose by Rachel Vincent
Glenn Beck's Common Sense

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates