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
SQL Tips & Techniques (Miscellaneous)
Working with Queries, Expressions, and Aggregate Functions
Understanding SQL Transactions and Transaction Logs
Working with Comparison Predicates and Grouped Queries
Understanding Triggers
Working with SQL Database Data Across the Internet
Building Web Applications with UML (2nd Edition)
Security
Technical Risk
Overview of Software Development
Glossary Application Tag Libraries
HTML to UML
Network Security Architectures
Emerging Security Technologies
Applied Knowledge Questions
References
Medium Network Campus Security Design
Guidelines on Antivirus Process
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Point-to-Point Protocol (PPP)
Internet Protocol (IP) Addressing
Internet Control Message Protocol (ICMP)
Transmission Control Protocol (TCP) Data Flow
Programming Microsoft ASP.NET 3.5
The Web Forms Model
Web Forms Internals
Creating Bindable Grids of Data
Design-Time Support for Custom Controls
Hosting ASP.NET Outside IIS
Java Concurrency in Practice
Summary
Lock and ReentrantLock
Performance Considerations
Nonblocking Algorithms
Initialization Safety
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