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
FileMaker Pro 8: The Missing Manual
Creating a New Database
Format the Number/Date/Time/Graphic
Creating Related Records
Date and Time Calculations
Logical Functions
A Practitioners Guide to Software Test Design
Equivalence Class Testing
Section III - Testing Paradigms
Exploratory Testing
Section V - Some Final Thoughts
Appendix B Stateless University Registration System Case Study
SQL Hacks
Hack 18. Sort Your Email
Hack 21. Report on Any Date Criteria
Hack 48. Prevent an SQL Injection Attack
Hack 49. Keep Track of Infrequently Changing Values
Hack 83. Find the Top n in Each Group
MySQL Clustering
Ensuring That MySQL Cluster Works
Restarting a Cluster
Storage Nodes
SQL Nodes
B Management Commands
The Java Tutorial: A Short Course on the Basics, 4th Edition
Summary
And the Rest…
General Programming Problems
Interoperability
POSIX Conventions for Command Line Arguments
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Why this book is important
Service descriptions (with WSDL)
Choreography
Notification and eventing
Service-Oriented Analysis (Part II: Service Modeling)
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