Table of content


   
•  Table of Contents
•  Index
PHP and PostgreSQL: Advanced Web Programming
By Ewald Geschwinde, Hans-Jürgen Schönig
   
Publisher : Sams Publishing
Pub Date : June 04, 2002
ISBN : 0-672-32382-6
Pages : 800
Copyright
    About the Authors
      Ewald Geschwinde
      Hans-Jürgen Schönig
   
    Acknowledgments
    Tell Us What You Think!
    Reader Services
    Introduction
      Why You Should Read This Book
      Finally
   
    Part I.  Getting Started
      Chapter 1.  Getting Started
      Section 1.1.  Why Use PHP and PostgreSQL as a Team?
      Section 1.2.  What You Can Do with PHP and PostgreSQL
      Section 1.3.  Web Sites Built on PHP and PostgreSQL
      Section 1.4.  Summary
   
      Chapter 2.  Setting Up PHP
      Section 2.1.  About PHP
      Section 2.2.  Installing Apache with PHP from Source
      Section 2.3.  Installing Binaries on Linux
      Section 2.4.  Configuring PHP
      Section 2.5.  Summary
   
      Chapter 3.  PHP Basics
      Section 3.1.  Getting Started
      Section 3.2.  Control Structures and Operators
      Section 3.3.  Data Types and Functions
      Section 3.4.  Building Functions
      Section 3.5.  Exception Handling
      Section 3.6.  Working with Files
      Section 3.7.  Variables and Scope
      Section 3.8.  Building Packages
      Section 3.9.  Working with Forms
      Section 3.10.  Debugging PHP
      Section 3.11.  Summary
   
      Chapter 4.  Object-Oriented PHP
      Section 4.1.  The Concepts of Object Orientation
      Section 4.2.  Building Classes
      Section 4.3.  Working with Inheritance
      Section 4.4.  Summary
   
   
    Part II.  Getting Started with PostgreSQL
      Chapter 5.  Relational and Object-Relational Database Concepts
      Section 5.1.  Normalization
      Section 5.2.  Basic Operations in the Relational Model
      Section 5.3.  PostgreSQL as an Object Relational Database
      Section 5.4.  Modeling Techniques
      Section 5.5.  Components of Relational Databases and Technical Terms
      Section 5.6.  Summary
   
      Chapter 6.  Installing PostgreSQL
      Section 6.1.  Installing PostgreSQL on Unix
      Section 6.2.  Installing PostgreSQL on Windows
      Section 6.3.  Creating and Removing Databases
      Section 6.4.  The User Interface
      Section 6.5.  The Architecture of PostgreSQL
      Section 6.6.  License
      Section 6.7.  Summary
   
      Chapter 7.  Basic SQL
      Section 7.1.  Data Types
      Section 7.2.  Building Tables
      Section 7.3.  Building Simple SQL Statements
      Section 7.4.  Updates and Deletes
      Section 7.5.  Writing Joins
      Section 7.6.  Aggregating Data
      Section 7.7.  Inserting Huge Amounts of Data
      Section 7.8.  Indexes
      Section 7.9.  Modifying Objects
      Section 7.10.  Mathematical Functions and Operators
      Section 7.11.  Summary
   
      Chapter 8.  Advanced SQL
      Section 8.1.  Advanced Data Types
      Section 8.2.  Working with Views
      Section 8.3.  Working with Subselects
      Section 8.4.  Working with Aliases and Self-Joins
      Section 8.5.  Object-Oriented SQL
      Section 8.6.  Transactions and Locking
      Section 8.7.  Constraints
      Section 8.8.  Basic Optimizations Using EXPLAIN
      Section 8.9.  Sophisticated Joins
      Section 8.10.  Working with Arrays
      Section 8.11.  Combining Queries and Ranges of Values
      Section 8.12.  Summary
   
      Chapter 9.  Embedded Languages
      Section 9.1.  Writing SQL Functions
      Section 9.2.  PL/pgSQL
      Section 9.3.  Writing Triggers
      Section 9.4.  Embedded Languages Versus PHP Functions
      Section 9.5.  Summary
   
      Chapter 10.  PostgreSQL Administration
      Section 10.1.  User Administration and User Rights
      Section 10.2.  Maintenance and Database Internals
      Section 10.3.  Configuring PostgreSQL
      Section 10.4.  Preparing the Database for the Web
      Section 10.5.  Summary
   
   
    Part III.  PHP/PostgreSQL Interaction
      Chapter 11.  Writing Database-Driven Applications
      Section 11.1.  Connecting to the Database
      Section 11.2.  Inserting and Retrieving Data
      Section 11.3.  Error Handling and Monitoring
      Section 11.4.  Handling Huge Amounts of Data
      Section 11.5.  Retrieving Objects from the Database
      Section 11.6.  Tracing a PostgreSQL Connection
      Section 11.7.  Locking
      Section 11.8.  PHP and Transactions
      Section 11.9.  Summary
   
      Chapter 12.  Working with BLOBs
      Section 12.1.  Working with PostgreSQL BLOBs Using SQL
      Section 12.2.  Working with PostgreSQL BLOBs Using PHP
      Section 12.3.  Managing File Uploads
      Section 12.4.  Storing Files as Toasted Text
      Section 12.5.  An Example of a Simple Image Management Tool
      Section 12.6.  Summary
   
      Chapter 13.  Working with Persistent Database Connections
      Section 13.1.  The Concept of Persistent Database Connections
      Section 13.2.  An Example
      Section 13.3.  Persistent Connections and Performance
      Section 13.4.  Dangers and Hardware Issues
      Section 13.5.  Summary
   
   
    Part IV.  Advanced Technologies
      Chapter 14.  Managing Regular Expressions
      Section 14.1.  Perl Style
      Section 14.2.  POSIX Style
      Section 14.3.  Regular Expressions and SQL
      Section 14.4.  Summary
   
      Chapter 15.  Session Management
      Section 15.1.  Managing Sessions with Cookies
      Section 15.2.  Session Management
      Section 15.3.  Summary
   
      Chapter 16.  Working with Dynamic Documents, Images, and Movies
      Section 16.1.  Creating Dynamic Images
      Section 16.2.  Using Geometric Data Types
      Section 16.3.  Creating Dynamic Flash Movies
      Section 16.4.  Generating PDF Files
      Section 16.5.  Summary
   
      Chapter 17.  Working with Dates and Time
      Section 17.1.  Dates and Time in SQL
      Section 17.2.  Dates and Time in PHP
      Section 17.3.  Summary
   
      Chapter 18.  Tuning
      Section 18.1.  Tuning PostgreSQL
      Section 18.2.  Tuning PHP
      Section 18.3.  Summary
   
      Chapter 19.  XML
      Section 19.1.  The Basic Concepts
      Section 19.2.  Building a Simple XML-Based Application
      Section 19.3.  XML and PostgreSQL
      Section 19.4.  Summary
   
      Chapter 20.  Security Issues
      Section 20.1.  Potential Threats
      Section 20.2.  Securing Your System
      Section 20.3.  User Authentication with Apache and PHP
      Section 20.4.  Summary
   
   
    Part V.  Practical Examples
      Chapter 21.  Web Applications
      Section 21.1.  Mail Systems
      Section 21.2.  Building a Web Shop
      Section 21.3.  Building a Content Management System
      Section 21.4.  Creating Stock Charts
      Section 21.5.  PHP for Application Servers
      Section 21.6.  Summary
   
      Chapter 22.  Extending PostgreSQL
      Section 22.1.  A User-Defined Data Type
      Section 22.2.  Building Substring Indexes
      Section 22.3.  Tolerant Search Algorithms
      Section 22.4.  Summary
   
      Chapter 23.  High-Availability Systems
      Section 23.1.  An Introduction to High Availability
      Section 23.2.  Building Failsafe Applications
      Section 23.4.  Summary
   
   
    Part VI.  Migration
      Chapter 24.  Migration
      Section 24.1.  Migrating from MySQL to PostgreSQL
      Section 24.2.  Migrating from Oracle to PostgreSQL
      Section 24.3.  Summary
   
   
    Index


PHP and PostgreSQL. Advanced Web Programming2002
PHP and PostgreSQL. Advanced Web Programming2002
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 201

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net