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 |