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
Inside Network Security Assessment: Guarding Your IT Infrastructure
Four Ways in Which You Can Respond to Risk
Understanding the Attacker
Introducing the Assessment Process
Building the Final Report
Conclusions
A Practitioners Guide to Software Test Design
Pairwise Testing
Use Case Testing
Data Flow Testing
Exploratory Testing
Defect Taxonomies
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an Authorization Object to Control User Access to the InfoCube Data
InfoCube Design Alternative III Time-Dependent Entire Hierarchies
Business Content
Performance Tuning
Object Transport
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #2: Improve Your Processes
When Companies Start Using Lean Six Sigma
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Six Things Managers Must Do: How to Support Lean Six Sigma
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Transmission Lines
The OSI Reference Model and the TCP/IP Reference Model
The IP+Optical Control Plane
Wireless WANs
Mobile Content
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Files and Directories
Reflection
Windows Controls
ADO.NET
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