Flylib.com
Perl Database Programming
Perl Database Programming
ISBN: 0764549561
EAN: 2147483647
Year: 2001
Pages: 175
Authors:
Curtis Ovid Poe
BUY ON AMAZON
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
Year: 2001
Pages: 175
Authors:
Curtis Ovid Poe
BUY ON AMAZON
Absolute Beginner[ap]s Guide to Project Management
Project Management Overview
Trends in Project Management
Unique Aspects of Managing Project Quality
Proven Techniques
Proven Techniques for Leading Cross-Cultural Projects
Strategies for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
Managing IT Functions
Governing Information Technology Through COBIT
The Evolution of IT Governance at NB Power
Governance Structures for IT in the Health Care Industry
Metrics and Models in Software Quality Engineering (2nd Edition)
The Iterative Development Process Model
Ishikawas Seven Basic Tools
In-Process Metrics and Quality Management
Object-Oriented Concepts and Constructs
Satisfaction with Company
Building Web Applications with UML (2nd Edition)
Modeling Secure Systems
Architecture Activities
Requirements and Use Cases
Overview
Use Case View
Twisted Network Programming Essentials
Running an HTTP Proxy Server
Calling XML-RPC Functions
Downloading Mail from a POP3 Server
Listing the Newsgroups on a Server
Using Public Keys for Authentication
InDesign Type: Professional Typography with Adobe InDesign CS2
Threading Text Frames
Type Classification
Tracking
Up Next
How InDesign Justifies Type
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies