Perl Database Programming
Perl Database Programming
ISBN: 0764549561
EAN: 2147483647
EAN: 2147483647
Year: 2001
Pages: 175
Pages: 175
Authors: Curtis Ovid Poe
- Table of Contents
- Back Cover
- Perl Database Programming
- Preface
- How This Book Is Organized
- Databases Used in This Book
- Database Concepts Simplified
- Conventions Used in This Book
- Companion Web Site
- Part I: Perl and Database Fundamentals
- Chapter 1: Database Basics
- Relational Databases
- Database Operations
- Designing a Database
- Summary
- Chapter 2: Working with a Database
- Connecting to a Database
- The Data Source Name (DSN)
- Oracle Connections
- DBI s Error Handling
- Summary
- Program Listings
- Chapter 3: Working with Database Tables
- Data Types
- Creating Tables
- Altering Tables
- Deleting Tables
- Program Example
- Summary
- Program Listings
- Chapter 4: Fetching Data from the Database (Basics)
- Simple SELECT Statement
- Counting Your Matches
- Grouping Your Output
- Other DBI Data-Retrieval Functions
- Simple Data-Retrieval Wrap-up
- Summary
- Program Listings
- Chapter 5: Making Changes to Your Data
- Using ADD
- Using UPDATE
- Using DELETE
- Putting the Pieces Together
- Summary
- Program Listings
- Part II: Advanced Database Programming
- Chapter 6: Web Database Programming
- HTML Form Tags
- Interface Design
- Program Examples
- Summary
- Program Listings
- Chapter 7: Fetching Data from the Database (Advanced)
- Auction Database Tables
- The Auction Application
- Summary
- Program Listings
- Chapter 8: Working with Binary (BLOB) Data
- Getting BLOB Data into the Database
- Summary
- Program Listings
- Chapter 9: Session Management with Tied Hashes
- Using Tied Hashes
- Program Example
- Summary
- Program Listings
- Chapter 10: Using Database Transactions
- Transactions and Perl
- Transactions in Practice
- Transaction Caveats
- Summary
- Program Listing
- Part III: Perl and Web Services
- Chapter 11: Perl, XML, and Databases
- The Photo Dumper Application
- Summary
- Program Listing
- Chapter 12: Creating a SOAP-Based Catalog
- What Is SOAP?
- Building a SOAP Server
- Listing All Items
- Showing Item Details
- Summary
- Program Listings
- Chapter 13: Sending Automatic E-mail Reports
- Sending E-mail Automatically
- Creating a Simple Report
- Creating a More Complex Report
- Creating Graphical Reports
- Summary
- Program Listings
- Part IV: Perl and General Web Programming
- Chapter 14: Creating a Phonebook
- Understanding the Program Table Structure
- Creating a Phonebook from the Command Line
- Creating a Phone Number Lookup Program
- Creating a Graphical Phonebook Application
- Summary
- Program Listings
- Chapter 15: Creating a Web-Based Shopping Cart
- Building the Shopping Cart
- Summary
- Program Listings
- Chapter 16: Creating a Web-Based Photo Album
- Building the Photo Album Application
- Summary
- Program Listings
- Appendix A: Configuring Your System
- Installing Perl on Windows
- Installing Perl on Linux (and nix) Systems
- Installing Apache on Windows
- Installing Apache on Linux (and nix) Systems
- Installing MySQL on Windows
- Installing MySQL on Linux (and nix) Systems
- Installing DBI on Windows Systems
- Installing DBI on Linux (and nix) Systems
- Installing MyODBC on Windows Systems
- Appendix B: Common SQL Reference
- CREATE
- DELETE
- DROP
- INSERT
- SELECT
- UPDATE
- Appendix C: MySQL Command Reference
- MySQL Prompt Commands
- MySQL Administration Commands
- The mysqldump Program
- Appendix D: DBI Reference
- bind_col
- bind_columns
- commit
- connect
- ::errstr
- disconnect
- do
- dump_results
- execute
- fetch
- fetchall_arrayref
- fetchrow_array
- fetchrow_hashref
- prepare
- quote
- rollback
- index__Symbols and Numerics
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- index_X
- index_Y
- List of Figures
- List of Tables
- List of Listings
- List of Sidebars
Perl Database Programming
ISBN: 0764549561
EAN: 2147483647
EAN: 2147483647
Year: 2001
Pages: 175
Pages: 175
Authors: Curtis Ovid Poe