Learning Mysql

15. A PHP Application The Wedding Gift Registry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473
Designing and Creating the Wedding Database
474
The Login Form
476
Passing a Message to a Script
478
Logging Users In and Out
480
The db.php Include File
486
Editing the List of Gifts
487
Loading Sample Gifts
497
Listing Gifts for Selection
497
Selecting and Deselecting Gifts
501
Resources
507
Exercises
507
Part V. Interacting with MySQL Using Perl
16. Perl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 511
Writing Your First Perl Program
512
Scripting With Perl
513
Resources
538
Exercises
538
17. Using Perl with MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
Connecting to the MySQL Server and Database
539
Handling Errors When Interacting with the Database
540
Using Queries That Return Answer Sets
542
Using Queries That Don’t Return Answer Sets
545
Binding Queries and Variables
546
Importing and Exporting Data
552
Handling NULL Values
554
Resources
554
Exercises
554
18. Serving Perl Pages to the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557
The Perl CGI Module
560
Processing User Input
562
A Note on mod_perl
566
Perl Security
566
Resources
568
Exercises
568
Table of Contents | ix

Part VI. Appendix
Appendix: The Wedding Registry Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 571

Download 4.24 Mb.

Share with your friends: