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
Planning a Project
Principles of an Effective Budget
Powerful Techniques for Minimizing Project Changes
Why Do This? Its Too Much Work
Twelve Tips for Buyers
Snort Cookbook
Capturing and Viewing Packets
Logging to the Windows Event Viewer
Optimizing Logging
Keeping the Rules Up to Date
Detecting and Normalizing HTTP Traffic
Systematic Software Testing (Artech House Computer Library)
Analysis and Design
Test Implementation
Appendix A Glossary of Terms
Appendix B Testing Survey
Appendix E Simplified Unit Test Plan
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 11. How Far? How Fast? Geo-Enabling Your Spreadsheet
Hacks 22-34
Hack 70. Import Your GPS Waypoints and Tracklogs into GRASS
Hack 71. Turn Your Tracklogs into ESRI Shapefiles
Hack 99. Map Your Friend-of-a-Friend Network
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
The AJAX Control Toolkit
Remote Method Calls with ASP.NET AJAX
Building AJAX Applications with ASP.NET
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Starting Diagrams by Using Templates
Adding Text to Shapes and the Drawing Page
Working with Groups
Key Points
Creating Organization Charts
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