Class: db_simple

Quellcode Position: Program_Root/sys_db_simple.php

Class db_simple

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

DB - abstraction layer

Implementiert in Program_Root/sys_db_simple.php [Zeile 53] 

base_object
   |
   --db_simple
Author(s): Information Tags:

Properties

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

Abgeleitet von base_object

base_object::$msgs

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 ]
Properties Summary
Class Overview | Inherited Properties And Methods | Properties Summary | Property Details | Method Summary | Method Details
string   $dbconf   database configuratuion
$dbcon_obj   $dbcon_obj   database connection
string   $dbsyntax_arr   database
string   $dburi   database URI

[ Seitenanfang ]
Method Summary
Class Overview | Inherited Properties And Methods | Properties Summary | Property Details | Method Summary | Method Details
boolean   addField()   Add field
boolean   addIndex()   Add index
boolean   changeField()   Change field
boolean   changeIndex()   Change index
void   compareFieldStructure()  
void   compareKeyStructure()  
dbcon_base   connect()   connect to database
boolean   createConnection()   establish connection
boolean   createTable()   Create given table
integer   deleteRecord()   Delete data set
integer   deleteRecords()   delete data sets
boolean   dropField()   Delete field
boolean   dropIndex()   Delete index
mixed   getBacktrace()   Get back trace
mixed   getSQLSource()   DBMS spezific SQL source
integer   insertRecord()   create new record, return id, set default values
boolean   insertRecords()   insert records
array   parseURI()   Parse URI contains connection data
void   printError()   error message in browser
integer   query()   Process a query
array   queryTableNames()   Get all table names
array   queryTableStructure()   Return table structur as arrays
void   setError()   Place error ,dump error, log error
integer   updateRecord()   change data set
integer   updateRecords()   change data sets

[ Seitenanfang ]
Properties
Class Overview | Inherited Properties And Methods | Properties Summary | Property Details | Method Summary | Method Details
string   $dbconf [Zeile 64]

database configuratuion


[ Seitenanfang ]
$dbcon_obj   $dbcon_obj = NULL [Zeile 70]

database connection


[ Seitenanfang ]
string   $dbsyntax_arr = array('mysql', 'mysqli', 'pgsql') [Zeile 77]

database


[ Seitenanfang ]
string   $dburi [Zeile 58]

database URI


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

  boolean addField( object &$object, string $table, array &$fielddata  )

Add field

Parameters:
object   &$object:  base_db
string   $table: 
array   &$fielddata: 

API Tags:
Access:  public


[ Seitenanfang ]
addIndex  [Zeile 596]

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

Add index

Parameters:
object   &$object:  base_db
string   $table: 
array   &$index: 

API Tags:
Access:  public


[ Seitenanfang ]
changeField  [Zeile 550]

  boolean changeField( object &$object, string $table, array &$fielddata  )

Change field

Parameters:
object   &$object:  base_db
string   $table: 
array   &$fielddata: 

API Tags:
Access:  public


[ Seitenanfang ]
changeIndex  [Zeile 614]

  boolean changeIndex( object &$object, string $table, array &$index  )

Change index

Parameters:
object   &$object:  base_db
string   $table: 
array   &$index: 

API Tags:
Access:  public


[ Seitenanfang ]
compareFieldStructure  [Zeile 659]

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



[ Seitenanfang ]
compareKeyStructure  [Zeile 666]

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



[ Seitenanfang ]
connect  [Zeile 83]

  dbcon_base connect( mixed &$object  )

connect to database



[ Seitenanfang ]
createConnection  [Zeile 100]

  boolean createConnection( mixed &$object  )

establish connection


API Tags:
Return:  Success


[ Seitenanfang ]
createTable  [Zeile 504]

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

Create given table

Parameters:
string   &$tabledata: 
string   $tableprefix: 

API Tags:
Access:  public


[ Seitenanfang ]
deleteRecord  [Zeile 427]

  integer deleteRecord( object &$object, string $table, string $idfield, string $value  )

Delete data set

Parameters:
object   &$object:  BASE_DB calling object
string   $table:  table
string   $idfield:  Index column
string   $value:  Index

API Tags:
Return:  deleted record


[ Seitenanfang ]
deleteRecords  [Zeile 450]

  integer deleteRecords( object &$object, string $table, [string $filter = 1]  )

delete data sets

Parameters:
object   &$object:  BASE_DB calling objekt
string   $table:  table
string   $filter:  condition

API Tags:
Return:  number deleted records


[ Seitenanfang ]
dropField  [Zeile 573]

  boolean dropField( object &$object, string $table, string &$field  )

Delete field

Parameters:
object   &$object:  base_db
string   $table: 
string   $field: 

API Tags:
Access:  public


[ Seitenanfang ]
dropIndex  [Zeile 649]

  boolean dropIndex( object &$object, string $table, string $name  )

Delete index

Parameters:
object   &$object:  base_db
string   $table: 
string   $name: 

API Tags:
Access:  public


[ Seitenanfang ]
getBacktrace  [Zeile 710]

  mixed getBacktrace( )

Get back trace


API Tags:
Return:  false or string
Access:  public


[ Seitenanfang ]
getSQLSource  [Zeile 631]

  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


[ Seitenanfang ]
insertRecord  [Zeile 315]

  integer insertRecord( object &$object, string $table, string $idfield, [array $values = NULL]  )

create new record, return id, set default values

Parameters:
object   &$object:  BASE_DB calling object
string   $table:  table
string   $idfield:  fields with ID
array   $values:  default values

API Tags:
Return:  data sets number


[ Seitenanfang ]
insertRecords  [Zeile 338]

  boolean insertRecords( object &$object, string $table, array $values  )

insert records

Parameters:
object   &$object:  BASE_DB calling object
string   $table:  table
array   $values:  default values


[ Seitenanfang ]
parseURI  [Zeile 142]

  array parseURI( mixed $dsn  )

Parse URI contains connection data

Parameters:
mixed   $dsn:  Verbindungsdaten


[ Seitenanfang ]
printError  [Zeile 735]

  void printError( )

error message in browser


API Tags:
Access:  public


[ Seitenanfang ]
query  [Zeile 262]

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

Process a query

Parameters:
string   $sql: 
object   &$object:  base_db calling object
integer   $max:  limit data sets
integer   $offset:  limit data sets - Start

API Tags:
Return:  Result Index


[ Seitenanfang ]
queryTableNames  [Zeile 472]

  array queryTableNames( object &$object  )

Get all table names

Parameters:
object   &$object:  base_db

API Tags:
Access:  public


[ Seitenanfang ]
queryTableStructure  [Zeile 488]

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

Return table structur as arrays

Parameters:
object   &$object:  base_db
string   $tablename:  table name
string   $tableprefix:  Prefix

API Tags:
Access:  public


[ Seitenanfang ]
setError  [Zeile 680]

  void setError( mixed &$object, integer $errlevel, [array $error = NULL], [boolean $log = true]  )

Place error ,dump error, log error

Parameters:
integer   $errlevel:  error priority
array   $error:  error detail
boolean   $log:  send error message tolog object


[ Seitenanfang ]
updateRecord  [Zeile 363]

  integer updateRecord( object &$object, string $table, array &$values, string $idfield, string $value  )

change data set

Parameters:
object   &$object:  BASE_DB calling object
string   $table:  table
array   $values:  default values
string   $idfield:  index column
string   $value:  index

API Tags:
Return:  number change records


[ Seitenanfang ]
updateRecords  [Zeile 395]

  integer updateRecords( object &$object, string $table, array &$values, [string $filter = '1=1']  )

change data sets

Parameters:
object   &$object:  BASE_DB calling object
string   $table:  table
array   $values:  default values
string   $filter:  condition

API Tags:
Return:  number changed records


[ Seitenanfang ]