Class: dbcon_pgsql

Quellcode Position: Program_Root/db/pgsql.php

Class dbcon_pgsql

Class Overview
Class Overview | Inherited Properties And Methods | Properties | Method Summary | Method Details

DB-abstraction layer - connection object PostgreSQL Improved

Implementiert in Program_Root/db/pgsql.php [Zeile 20] 

base_object
   |
   --dbcon_base
      |
      --dbcon_pgsql
Author(s): Information Tags:

Methods
[ Seitenanfang ]
Inherited Properties And Methods
Class Overview | Inherited Properties And Methods | Properties | Method Summary | Method Details
Inherited Properties Inherited Methods

Abgeleitet von dbcon_base

dbcon_base::$dbcon
dbcon_base::$lastquery
dbcon_base::$lastresult

Abgeleitet von base_object

base_object::$msgs

Abgeleitet von dbcon_base

dbcon_base::dbcon_base()
Constructor
dbcon_base::addField()
Add field
dbcon_base::addIndex()
Add index
dbcon_base::changeField()
Change field
dbcon_base::changeIndex()
Change index
dbcon_base::compareFieldStructure()
Compare the field structure
dbcon_base::compareKeyStructure()
Compare the key/index structure
dbcon_base::connect()
connect to Database
dbcon_base::createTable()
Create table
dbcon_base::deleteRecord()
delete database record
dbcon_base::deleteRecords()
delete database records
dbcon_base::dropField()
Delete field
dbcon_base::dropIndex()
Delete index
dbcon_base::getError()
Supply error
dbcon_base::getSQLCondition()
dbcon_base::getSQLSource()
DBMS spezific SQL source
dbcon_base::insertRecord()
Insert new record
dbcon_base::insertRecords()
Insert many records at once
dbcon_base::query()
Database request
dbcon_base::queryTableNames()
Get all table names
dbcon_base::queryTableStructure()
table structur as array
dbcon_base::updateRecord()
Change database record
dbcon_base::updateRecords()
Change database records

Abgeleitet von base_object

base_object::addmsg()
Adds a message in the message object.
base_object::createPluginObject()
Create plugin object
base_object::debug()
Show the debug of the variable &$var
base_object::encodeQueryString()
Encode query string
base_object::escapeForFilename()
Escape chars in a string to use it in a filename
base_object::getAbsoluteURL()
Return absolute URL
base_object::getBaseLink()
Get base link
base_object::getBasePath()
get base path to current script
base_object::getLink()
Get link
base_object::getSessionValue()
base_object::getWebLink()
Get web link
base_object::getWebMediaLink()
Get web media link
base_object::includePluginFile()
Include plugin file
base_object::initializeParams()
Parameter initialisation
base_object::initializeSessionParam()
Initialisation of session-parameter
base_object::logMsg()
Log events
base_object::parseRequestURI()
Parse request URI to filter data out of it
base_object::setSessionValue()
base_object::stripslashes()
base_object::_gt()
Phrasetranslator - Fetch translation for all phrase
base_object::_gtf()
Phrasetranslator - Fetch translation of one phrase and insert variable
base_object::_gtfile()
Phrases - Locate files

[ Seitenanfang ]
Method Summary
Class Overview | Inherited Properties And Methods | Properties | Method Summary | Method Details
booblean   addField()   Add Field
boolean   addIndex()   Add index
booblean   changeField()   Change Field
boolean   changeIndex()   Change Index
void   compareFieldStructure()  
void   compareKeyStructure()  
resource   connect()   Establish connection to database
boolean   createTable()   Create given table
mixed   deleteRecord()   Delete record
mixed   deleteRecords()   Delete records by filter
booblean   dropField()   Drop field
boolean   dropIndex()   Drop Index
string   escapeStr()   String ecsaping for PostgreSQL use
array   getError()   Provides error messages of last database connection
mixed   getExplain()   Return an explanation of the last SELECT-SQL-query
void   getFieldInfo()  
void   getIndexInfo()  
void   getSQLFunctionParams()  
mixed   getSQLSource()   DBMS spezific SQL source
mixed   insertRecord()   Insert record into table
void   insertRecords()  
mixed   &query()   Execute PostgreSQL-query
array   queryTableNames()   Get table names
array   queryTableStructure()   Query table structure
mixed   updateRecord()   Update record
mixed   updateRecords()   Update records via filter

[ Seitenanfang ]
Properties
Class Overview | Inherited Properties And Methods | Properties Summary | Property Details | Method Summary | Method Details
Methods
Class Overview | Inherited Properties And Methods | Properties Method Summary | Method Details
addField  [Zeile 604]

  booblean addField( string $table, array &$fielddata  )

Add Field

Parameters:
string   $table: 
array   &$fielddata: 

API Tags:
Access:  public

Neudefinition von:
dbcon_base::addField()
Add field

[ Seitenanfang ]
addIndex  [Zeile 710]

  boolean addIndex( table $table, array &$index  )

Add index

Parameters:
table   $table: 
array   &$index: 

API Tags:
Access:  public

Neudefinition von:
dbcon_base::addIndex()
Add index

[ Seitenanfang ]
changeField  [Zeile 616]

  booblean changeField( string $table, array &$fielddata  )

Change Field

Parameters:
string   $table: 
array   &$fielddata: 

API Tags:
Access:  public

Neudefinition von:
dbcon_base::changeField()
Change field

[ Seitenanfang ]
changeIndex  [Zeile 723]

  boolean changeIndex( atring $table, array &$index, [boolean $drop_current = true]  )

Change Index

Parameters:
atring   $table: 
array   &$index: 
boolean   $drop_current:  optional, default value true

API Tags:
Access:  public

Neudefinition von:
dbcon_base::changeIndex()
Change index

[ Seitenanfang ]
compareFieldStructure  [Zeile 805]

  void compareFieldStructure( mixed &$xmlfield, mixed &$dbfield  )


Neudefinition von:
dbcon_base::compareFieldStructure()
Compare the field structure

[ Seitenanfang ]
compareKeyStructure  [Zeile 823]

  void compareKeyStructure( mixed &$xmlkey, mixed &$dbkey  )


Neudefinition von:
dbcon_base::compareKeyStructure()
Compare the key/index structure

[ Seitenanfang ]
connect  [Zeile 26]

  resource connect( )

Establish connection to database


API Tags:
Return:  $this->dbcon connection ID

Neudefinition von:
dbcon_base::connect()
connect to Database

[ Seitenanfang ]
createTable  [Zeile 534]

  boolean createTable( string &$tabledata, string $tableprefix  )

Create given table

Parameters:
string   $tabledata: 
string   $tableprefix: 

API Tags:
Access:  public

Neudefinition von:
dbcon_base::createTable()
Create table

[ Seitenanfang ]
deleteRecord  [Zeile 279]

  mixed deleteRecord( string $table, string $idfield, array $value  )

Delete record

Parameters:
string   $table:  table name
string   $idfield:  primary key
array   $value:  primary key value

API Tags:
Return:  false or number of affected_rows or database result object

Neudefinition von:
dbcon_base::deleteRecord()
delete database record

[ Seitenanfang ]
deleteRecords  [Zeile 266]

  mixed deleteRecords( string $table, [string $filter = '1=1']  )

Delete records by filter

Parameters:
string   $table:  table name
string   $filter:  Filter string without WHERE condition

API Tags:
Return:  false or number of affected_rows or database result object

Neudefinition von:
dbcon_base::deleteRecords()
delete database records

[ Seitenanfang ]
dropField  [Zeile 653]

  booblean dropField( string $table, string $field  )

Drop field

Parameters:
string   $table: 
string   $field:  fieldname

API Tags:
Access:  public

Neudefinition von:
dbcon_base::dropField()
Delete field

[ Seitenanfang ]
dropIndex  [Zeile 754]

  boolean dropIndex( string $table, string $name  )

Drop Index

Parameters:
string   $table: 
string   $name: 

API Tags:
Access:  public

Neudefinition von:
dbcon_base::dropIndex()
Delete index

[ Seitenanfang ]
escapeStr  [Zeile 100]

  string escapeStr( string $str  )

String ecsaping for PostgreSQL use

Parameters:
string   $str:  String, der Escaped werden soll.

API Tags:
Return:  String, der excaped wurde.


[ Seitenanfang ]
getError  [Zeile 54]

  array getError( )

Provides error messages of last database connection


API Tags:
Return:  error number, error message and last sql query

Neudefinition von:
dbcon_base::getError()
Supply error

[ Seitenanfang ]
getExplain  [Zeile 69]

  mixed getExplain( )

Return an explanation of the last SELECT-SQL-query

Explan the last query, number of lines etc.
API Tags:
Return:  Result or false, if last request wasn't a SELECT query


[ Seitenanfang ]
getFieldInfo  [Zeile 569]

  void getFieldInfo( mixed $table, mixed $fieldname  )



[ Seitenanfang ]
getIndexInfo  [Zeile 659]

  void getIndexInfo( mixed $table, mixed $key  )



[ Seitenanfang ]
getSQLFunctionParams  [Zeile 767]

  void getSQLFunctionParams( mixed $params  )



[ Seitenanfang ]
getSQLSource  [Zeile 787]

  mixed getSQLSource( $function $function, $params $params  )

DBMS spezific SQL source

Parameters:
$function   $function:  sql function
$params   $params:  params

API Tags:
Return:  sql string or false
Access:  public

Neudefinition von:
dbcon_base::getSQLSource()
DBMS spezific SQL source

[ Seitenanfang ]
insertRecord  [Zeile 156]

  mixed insertRecord( string $table, string $idfield, [array $values = NULL]  )

Insert record into table

Parameters:
string   $table:  table
string   $idfield:  primary key value
array   $values:  insert values

API Tags:
Return:  false or Id of new record

Neudefinition von:
dbcon_base::insertRecord()
Insert new record

[ Seitenanfang ]
insertRecords  [Zeile 188]

  void insertRecords( mixed $table, mixed $values  )


Neudefinition von:
dbcon_base::insertRecords()
Insert many records at once

[ Seitenanfang ]
query  [Zeile 112]

  mixed &query( string $sql, [integer $max = NULL], [integer $offset = NULL]  )

Execute PostgreSQL-query

Parameters:
string   $sql:  SQL-String with query
integer   $max:  maximum number of returned records
integer   $offset:  Offset

API Tags:
Return:  false or number of affected_rows or database result object

Neudefinition von:
dbcon_base::query()
Database request

[ Seitenanfang ]
queryTableNames  [Zeile 290]

  array queryTableNames( )

Get table names


API Tags:
Access:  public

Neudefinition von:
dbcon_base::queryTableNames()
Get all table names

[ Seitenanfang ]
queryTableStructure  [Zeile 456]

  array queryTableStructure( string $tablename, [string $tableprefix = '']  )

Query table structure

Parameters:
string   $tablename: 
string   $tableprefix:  optional, default value ''

API Tags:
Access:  public

Neudefinition von:
dbcon_base::queryTableStructure()
table structur as array

[ Seitenanfang ]
updateRecord  [Zeile 229]

  mixed updateRecord( string $table, array $values, string $idfield, array $value  )

Update record

Parameters:
string   $table:  table name
array   $values:  update values
string   $idfield:  primary key
array   $value:  primary key value

API Tags:
Return:  false or number of affected_rows or database result object

Neudefinition von:
dbcon_base::updateRecord()
Change database record

[ Seitenanfang ]
updateRecords  [Zeile 242]

  mixed updateRecords( string $table, array $values, [string $filter = 1]  )

Update records via filter

Parameters:
string   $table:  table name
array   $values:  update values
string   $filter:  Filter string without WHERE condition

API Tags:
Return:  false or number of affected_rows or database result object

Neudefinition von:
dbcon_base::updateRecords()
Change database records

[ Seitenanfang ]