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