---

Pgdb Class Reference

this class is used to interface Pgtable class to postgresql, More...

List of all members.

Public Methods
	Pgdb ($dbConn)
	check_pg_errors ()
	get_table_attributes ($tbSchema='public',$tbName)
	get_foreign_keys ($tbSchema='public',$tbName)
	get_inh_tables ($tbSchema='public',$tbName)
	set_value_from_pkey ($tbSchema='public',$table,$pkeyVal='',$pkey='oid',$query=false)
	select ($query)
	whereClause ($tbSchema,$tbName,$field,$val,$operator='=')
	orderClause ($tbSchema,$tbName,$field,$order='ASC')
	limitClause ($limit=10,$offset=0)
	selectClause ($tbSchema,$tbName,$field="*",$inherits)
	numRecords ($tbSchema,$tbName,$inherits=true,$where='')
	delete ($tbSchema='public',$tbName,$pkey,$pkeyField='oid',$num=0)
	update ($tbSchema='public',$tbName,$val,$pkey,$pkeyField='oid',$num)
	insert ($tbSchema='public',$tbName,&$val,$pkeyfield,$num=0)
	not_null ($tbSchema,$tbName)
	is_expression ($tbSchema,$tbName)
	parse_geometry ($tbSchema,$tbName,&$val,$field=' ')
	filesEnd ()
	filesRollback ()
	newFileName ($oldName='')
	checkUploadedFile ($schema,$table,$num,$field)
	fupload ($tbSchema,$tbName,$num,$field,&$arr)
	fdelete ($tbSchema,$tbName,$pkeyField,$pkeyVal,$field,&$arr)
	readExif ($file)
	clean_exif (&$arr)
	export ($query)
Public Attributes
	SQL_DEBUG
	dbConn
	pgVersion
	useSchema
	attribs
	notNull
	isExpression
	errors
	warnings
	files
	filesDir
	STRINGS

---

Detailed Description

this class is used to interface Pgtable class to postgresql,

Definition at line 28 of file pgdb.php.

---

Constructor & Destructor Documentation

Pgdb::Pgdb (  $    dbConn )

Definition at line 50 of file pgdb.php. References dbConn, errors, files, filesDir, pgVersion, SQL_DEBUG, STRINGS, useSchema, and warnings.

---

Member Function Documentation

Pgdb::check_pg_errors (    )

Definition at line 73 of file pgdb.php.

Pgdb::checkUploadedFile (  $    schema, $    table, $    num, $    field )

Definition at line 497 of file pgdb.php. References table.

Pgdb::clean_exif (  &$    arr )

Definition at line 779 of file pgdb.php.

Pgdb::delete (  $    tbSchema = 'public', $    tbName, $    pkey, $    pkeyField = 'oid', $    num = 0 )

Definition at line 248 of file pgdb.php. References pg_affected_rows(), and where_sql().

Pgdb::export (  $    query )

Definition at line 795 of file pgdb.php.

Pgdb::fdelete (  $    tbSchema, $    tbName, $    pkeyField, $    pkeyVal, $    field, &$    arr )

Definition at line 633 of file pgdb.php.

Pgdb::filesEnd (    )

Definition at line 462 of file pgdb.php.

Pgdb::filesRollback (    )

Definition at line 473 of file pgdb.php.

Pgdb::fupload (  $    tbSchema, $    tbName, $    num, $    field, &$    arr )

Definition at line 543 of file pgdb.php.

Pgdb::get_foreign_keys (  $    tbSchema = 'public', $    tbName )

Definition at line 109 of file pgdb.php. References table.

Pgdb::get_inh_tables (  $    tbSchema = 'public', $    tbName )

Definition at line 136 of file pgdb.php.

Pgdb::get_table_attributes (  $    tbSchema = 'public', $    tbName )

Definition at line 81 of file pgdb.php.

Pgdb::insert (  $    tbSchema = 'public', $    tbName, &$    val, $    pkeyfield, $    num = 0 )

Definition at line 343 of file pgdb.php. References insert_sql(), and pg_affected_rows().

Pgdb::is_expression (  $    tbSchema, $    tbName )

Definition at line 420 of file pgdb.php.

Pgdb::limitClause (  $    limit = 10, $    offset = 0 )

Definition at line 207 of file pgdb.php.

Pgdb::newFileName (  $    oldName = '' )

Definition at line 485 of file pgdb.php.

Pgdb::not_null (  $    tbSchema, $    tbName )

Definition at line 409 of file pgdb.php.

Pgdb::numRecords (  $    tbSchema, $    tbName, $    inherits = true, $    where = '' )

Definition at line 227 of file pgdb.php.

Pgdb::orderClause (  $    tbSchema, $    tbName, $    field, $    order = 'ASC' )

Definition at line 199 of file pgdb.php.

Pgdb::parse_geometry (  $    tbSchema, $    tbName, &$    val, $    field = ' ' )

Definition at line 431 of file pgdb.php.

Pgdb::readExif (  $    file )

Definition at line 765 of file pgdb.php. References exif_read_data().

Pgdb::select (  $    query )

Definition at line 175 of file pgdb.php.

Pgdb::selectClause (  $    tbSchema, $    tbName, $    field = "*", $    inherits )

Definition at line 216 of file pgdb.php.

Pgdb::set_value_from_pkey (  $    tbSchema = 'public', $    table, $    pkeyVal = '', $    pkey = 'oid', $    query = false )

Definition at line 150 of file pgdb.php. References table.

Pgdb::update (  $    tbSchema = 'public', $    tbName, $    val, $    pkey, $    pkeyField = 'oid', $    num )

Definition at line 293 of file pgdb.php. References pg_affected_rows(), update_sql(), and where_sql().

Pgdb::whereClause (  $    tbSchema, $    tbName, $    field, $    val, $    operator = '=' )

Definition at line 189 of file pgdb.php.

---

Member Data Documentation

Pgdb::attribs

Definition at line 35 of file pgdb.php.

Pgdb::dbConn

Definition at line 31 of file pgdb.php. Referenced by Pgdb().

Pgdb::errors

Definition at line 39 of file pgdb.php. Referenced by Pgdb().

Pgdb::files

Definition at line 42 of file pgdb.php. Referenced by Pgdb().

Pgdb::filesDir

Definition at line 43 of file pgdb.php. Referenced by Pgdb().

Pgdb::isExpression

Definition at line 37 of file pgdb.php.

Pgdb::notNull

Definition at line 36 of file pgdb.php.

Pgdb::pgVersion

Definition at line 32 of file pgdb.php. Referenced by Pgdb().

Pgdb::SQL_DEBUG

Definition at line 29 of file pgdb.php. Referenced by Pgdb().

Pgdb::STRINGS

Definition at line 45 of file pgdb.php. Referenced by Pgdb().

Pgdb::useSchema

Definition at line 33 of file pgdb.php. Referenced by Pgdb().

Pgdb::warnings

Definition at line 40 of file pgdb.php. Referenced by Pgdb().

---

The documentation for this class was generated from the following file:

• pgdb.php

---