List of Listings

Chapter 2: Working with a Database

Listing 2-1: connect_multi.pl

Chapter 3: Working with Database Tables

Listing 3-1: Table Add

Chapter 4: Fetching Data from the Database (Basics)

Listing 4-1: select.pl

Listing 4-2: select2.pl

Listing 4-3: select3.pl

Listing 4-4: select4.pl

Listing 4-5: select5.pl

Listing 4-6: select6.pl

Listing 4-7: select7.pl

Listing 4-8: select8.pl

Listing 4-9: select9.pl

Chapter 5: Making Changes to Your Data

Listing 5-1: Simple add

Listing 5-2: Simple update

Listing 5-3: Simple delete

Listing 5-4: Comprehensive example

Chapter 6: Web Database Programming

Main HTML page

Add record HTML page

phonebook.cgi

index.html

admin.html

create_test.html

create_test.cgi

add_question.cgi

test_chooser.cgi

take_test.cgi

score_test.cgi

Quizzer.pm

Listing 6-1: Web Phonebook Application

Listing 6-2: Database tables for Quizzer application

Listing 6-3: add_question.cgi

Listing 6-4: create_test.cgi

Listing 6-5: score_test.cgi

Listing 6-6: take_test.cgi

Listing 6-7: test_chooser.cgi

Listing 6-8: Quizzer.pm

Chapter 7: Fetching Data from the Database (Advanced)

index.cgi

view_all.cgi

view_item.cgi

SmallAuction.pm

Listing 7-1: MySQL tables

Listing 7-2: index.cgi

Listing 7-3: view_all.cgi

Listing 7-4: view_item.cgi

Listing 7-5: SmallAuction.pm

Chapter 8: Working with Binary (BLOB) Data

Listing 8-1: auction_up.cgi

Listing 8-2: upload.cgi

Listing 8-3: display_image.cgi

Chapter 9: Session Management with Tied Hashes

signup.cgi

index.tmpl

index.cgi

BasicSession.pm

Listing 9-1: signup.cgi

Listing 9-2: index.cgi

Listing 9-3: BasicSession.pm

Listing 9-4: header.tmpl

Listing 9-5: index.tmpl

Listing 9-6: footer.tmpl

Chapter 10: Using Database Transactions

Listing 10-1: Transactions in practice

Chapter 11: Perl, XML, and Databases

photo_dumper.pl

Listing 11-1: photo_dumper.pl

Chapter 12: Creating a SOAP-Based Catalog

Listing 12-1: soap_server.cgi

Listing 12-2: catalog.cgi

Listing 12-3: Item_details.cgi

Chapter 13: Sending Automatic E-mail Reports

template_2.txt

template_2.html

template_3.html

Listing 13-1: Plain-text report

Listing 13-2: HTML report

Listing 13-3: Graphical report

Chapter 14: Creating a Phonebook

Listing 14-1: Command-line phonebook code

Listing 14-2: Phone number lookup program

Listing 14-3: Graphical phonebook code

Chapter 15: Creating a Web-Based Shopping Cart

catalog.cgi

item_details.cgi

cart.cgi

invoice.cgi

Listing 15-1: catalog.cgi

Listing 15-2: item_details.cgi

Listing 15-3: cart.cgi

Listing 15-4: invoice.cgi

Listing 15-5: cart_total.tmpl

Listing 15-6: catalog_footer.tmpl

Listing 15-7: catalog_header.tmpl

Listing 15-8: header.tmpl

Listing 15-9: invoice_body.tmpl

Listing 15-10: invoice_footer.tmpl

Listing 15-11: invoice_header.tmpl

Listing 15-12: item_details.tmpl

Chapter 16: Creating a Web-Based Photo Album

generate.pl

index.cgi

admin.cgi

Listing 16-1: generate.pl

Listing 16-2: index.cgi

Listing 16-3: admin.cgi

Listing 16-4: admin_album_end.tmpl

Listing 16-5: admin_album_row.tmpl

Listing 16-6: admin_album_top.tmpl

Listing 16-7: admin_footer.tmpl

Listing 16-8: admin_list_row.tmpl

Listing 16-9: admin_main.tmpl

Listing 16-10: album_end.tmpl

Listing 16-11: album_row.tmpl

Listing 16-12: album_top.tmpl

Listing 16-13: footer.tmpl

Listing 16-14: header.tmpl

Listing 16-15: list_end.tmpl

Listing 16-16: list_row.tmpl

Listing 16-17: list_top.tmpl

Listing 16-18: photo_footer.tmpl

Listing 16-19: photo_main.tmpl