COMP3311 Week 07 Lecture
User-defined Aggregates
Aggregates
User-defined Aggregates
Exercise: Defining Aggregates
Catalogs
Catalogs
PostgreSQL Catalog
Exercise: Exploring the Catalog (1)
Exercise: Exploring the Catalog (2)
Exercise: Size of each Table
Exercise: Deleting all Tables
Exercise: Test-bed for Views
Database Programming
Programming with Databases
PL/DB Interaction
PHP
PHP
PHP Language
PHP Scripts
Exercise: PHP Hello World
Variables
Constants
Types
Strings
Arrays
Other PHP Types
Variable Checking
Debugging-related Functions
Control Structures
Functions
PHP and PostgreSQL
COMP3311 Library Functions
COMP3311 Database Library
PHP DB Access
Exercise: Different DB Access Methods
Exercise: List of Enrolled Students
Exercise: Phone Lists
Produced: 30 Apr 2009