PHP and PostgreSQL Advanced Web Programming / Edition 1

PHP and PostgreSQL Advanced Web Programming / Edition 1

by Ewald Geschwinde
ISBN-10:
0672323826
ISBN-13:
2900672323828
Pub. Date:
06/18/2002
Publisher:
Sams
Select a Purchase Option (NE)
  • purchase options

    Temporarily Out of Stock Online

    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options
    $27.77 $49.99 Save 44% Current price is $27.77, Original price is $49.99. You Save 44%.
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.

Overview

PHP and PostgreSQL Advanced Web Programming / Edition 1

PHP and PostgreSQL are free open-source products that are ideally suited for creating sophisticated Web applications and services. PHP is an efficient and easy-to-learn programming language that is used on an estimated seven million Web domains. PostgreSQL is considered to be the most advanced opensource relational database management system. It competes with costly commercial products such as Oracle and IBM's DB2. PHP and PostgreSQL Advanced Web Programming is aimed at developers and programmers with basic knowledge of databases and Web scripting languages who want to develop powerful, secure, and inexpensive Web applications for themselves and their clients. Beginning with the necessary instructions for installing and setting up PHP and PostgreSQL, this book quickly covers the basic features of PHP and PostgreSQL before moving into indepth coverage of using PHP and PostgreSQL in tandem and related advanced topics. Beyond the coverage of just syntax and function, this book provides a complete picture of developing Web applications and services using PHP and PostgreSQL. This includes practical discussions on performance tuning, security, session management, regular expressions, and much more.

Product Details

ISBN-13: 2900672323828
Publisher: Sams
Publication date: 06/18/2002
Series: Developer's Guide Series
Edition description: NE
Pages: 800
Product dimensions: 6.00(w) x 1.25(h) x 9.00(d)

Table of Contents

Introduction1
Part IGetting Started3
1Getting Started5
1.1Why Use PHP and PostgreSQL as a Team?6
1.2What You Can Do with PHP and PostgreSQL7
1.3Web Sites Built on PHP and PostgreSQL11
1.4Summary14
2Setting Up PHP15
2.1About PHP15
2.2Installing Apache with PHP from Source16
2.3Installing Binaries on Linux38
2.4Configuring PHP39
2.5Summary42
3PHP Basics43
3.1Getting Started43
3.2Control Structures and Operators50
3.3Data Types and Functions65
3.4Building Functions89
3.5Exception Handling92
3.6Working with Files94
3.7Variables and Scope104
3.8Building Packages108
3.9Working with Forms110
3.10Debugging PHP118
3.11Summary120
4Object-Oriented PHP121
4.1The Concepts of Object Orientation121
4.2Building Classes123
4.3Working with Inheritance131
4.4Summary135
Part IIGetting Started with PostgreSQL137
5Relational and Object-Relational Database Concepts139
5.1Normalization140
5.2Basic Operations in the Relational Model142
5.3PostgreSQL as an Object Relational Database143
5.4Modeling Techniques144
5.5Components of Relational Databases and Technical Terms147
5.6Summary148
6Installing PostgreSQL149
6.1Installing PostgreSQL on Unix150
6.2Installing PostgreSQL on Windows163
6.3Creating and Removing Databases164
6.4The User Interface167
6.5The Architecture of PostgreSQL174
6.6License175
6.7Summary176
7Basic SQL177
7.1Data Types178
7.2Building Tables180
7.3Building Simple SQL Statements184
7.4Updates and Deletes199
7.5Writing Joins201
7.6Aggregating Data206
7.7Inserting Huge Amounts of Data210
7.8Indexes213
7.9Modifying Objects217
7.10Mathematical Functions and Operators222
7.11Summary223
8Advanced SQL225
8.1Advanced Data Types225
8.2Working with Views242
8.3Working with Subselects252
8.4Working with Aliases and Self-Joins255
8.5Object-Oriented SQL259
8.6Transactions and Locking267
8.7Constraints277
8.8Basic Optimizations Using EXPLAIN289
8.9Sophisticated Joins295
8.10Working with Arrays298
8.11Combining Queries and Ranges of Values303
8.12Summary305
9Embedded Languages307
9.1Writing SQL Functions308
9.2PL/pgSQL315
9.3Writing Triggers333
9.4Embedded Languages Versus PHP Functions346
9.5Summary347
10PostgreSQL Administration349
10.1User Administration and User Rights349
10.2Maintenance and Database Internals358
10.3Configuring PostgreSQL363
10.4Preparing the Database for the Web375
10.5Summary378
Part IIPHP/PostgreSQL Interaction379
11Writing Database-Driven Applications381
11.1Connecting to the Database381
11.2Inserting and Retrieving Data385
11.3Error Handling and Monitoring392
11.4Handling Huge Amounts of Data395
11.5Retrieving Objects from the Database397
11.6Tracing a PostgreSQL Connection398
11.7Locking400
11.8PHP and Transactions402
11.9Summary404
12Working with BLOBs405
12.1Working with PostgreSQL BLOBs Using SQL405
12.2Working with PostgreSQL BLOBs Using PHP409
12.3Managing File Uploads412
12.4Storing Files as Toasted Text414
12.5An Example of a Simple Image Management Tool417
12.6Summary421
13Working with Persistent Database Connections423
13.1The Concept of Persistent Database Connections423
13.2An Example424
13.3Persistent Connections and Performance425
13.4Dangers and Hardware Issues429
13.5Summary431
Part IIIAdvanced Technologies433
14Managing Regular Expressions435
14.1Perl Style436
14.2POSIX Style449
14.3Regular Expressions and SQL452
14.4Summary461
15Session Management463
15.1Managing Sessions with Cookies463
15.2Session Management467
15.3Summary473
16Working with Dynamic Documents, Images, and Movies475
16.1Creating Dynamic Images475
16.2Using Geometric Data Types492
16.3Creating Dynamic Flash Movies499
16.4Generating PDF Files504
16.5Summary520
17Working with Dates and Time521
17.1Dates and Time in SQL521
17.2Dates and Time in PHP537
17.3Summary550
18Tuning551
18.1Tuning PostgreSQL551
18.2Tuning PHP571
18.3Summary571
19XML573
19.1The Basic Concepts573
19.2Building a Simple XML-Based Application576
19.3XML and PostgreSQL577
19.4Summary583
20Security Issues585
20.1Potential Threats586
20.2Securing Your System587
20.3User Authentication with Apache and PHP591
20.4Summary596
Part IVPractical Examples597
21Web Applications599
21.1Mail Systems599
21.2Building a Web Shop615
21.3Building a Content Management System640
21.4Creating Stock Charts654
21.5PHP for Application Servers660
21.6Summary668
22Extending PostgreSQL669
22.1A User-Defined Data Type669
22.2Building Substring Indexes679
22.3Tolerant Search Algorithms682
22.4Summary694
23High-Availability Systems695
23.1An Introduction to High Availability695
23.2Building Failsafe Applications697
23.4Summary707
Part VMigration709
24Migration711
24.1Migrating from MySQL to PostgreSQL711
24.2Migrating from Oracle to PostgreSQL718
24.3Summary719
Index721

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews