Class: dbcon_base

Quellcode Position: Program_Root/db/base.php

Class dbcon_base

Class Overview

DB-abstraction layer - connection objekt

Implementiert in Program_Root/db/base.php [Zeile 35]

base_object
   |
   --dbcon_base

Author(s):

Thomas Weinert <weinert@papaya-cms.com>

Information Tags:

Properties

Methods

[ Seitenanfang ]

Direct Derivates

Abgeleitete Class	Description
dbcon_mysql	DB-abstraction layer - connection object MySQLDB
dbcon_mysqli	DB-abstraction layer - connection object MySQL Improved
dbcon_pgsql	DB-abstraction layer - connection object PostgreSQL Improved

[ Seitenanfang ]

Inherited Properties And Methods

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

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

array	$dbcon
string	$lastquery
dbresult_base	$lastresult

[ Seitenanfang ]

Method Summary

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

[ Seitenanfang ]

Properties

array $dbcon = NULL [Zeile 46]

API Tags:

Access:

public

[ Seitenanfang ]

string $lastquery [Zeile 58]

API Tags:

Access:

public

[ Seitenanfang ]

dbresult_base $lastresult [Zeile 52]

API Tags:

Access:

public

[ Seitenanfang ]

Methods

Constructor dbcon_base [Zeile 67]

void dbcon_base(
array
&$conf 
)

Constructor

Parameters:

array

&$conf:

Konfiguration

API Tags:

Access:

public

[ Seitenanfang ]

addField [Zeile 248]

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

Add field

Parameters:

string	$table:
array	&$fielddata:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

addIndex [Zeile 284]

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

Add index

Parameters:

string	$table:
array	&$index:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

changeField [Zeile 260]

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

Change field

Parameters:

string	$table:
array	&$fielddata:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::changeField() : Change Field
dbcon_mysqli::changeField() : Change Field
dbcon_pgsql::changeField() : Change Field

[ Seitenanfang ]

changeIndex [Zeile 297]

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

Change index

Parameters:

string	$table:
array	&$index:
boolean	$drop_current:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::changeIndex() : Change Index
dbcon_mysqli::changeIndex() : Change Index
dbcon_pgsql::changeIndex() : Change Index

[ Seitenanfang ]

compareFieldStructure [Zeile 334]

Different compareFieldStructure(
&$xmlfield
&$xmlfield, &$dbfield
&$dbfield 
)

Compare the field structure

Parameters:

&$xmlfield	&$xmlfield:
&$dbfield	&$dbfield:

API Tags:

Return:	true/false
Access:	public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

compareKeyStructure [Zeile 346]

Different compareKeyStructure(
&$xmlkey
&$xmlkey, &$dbkey
&$dbkey 
)

Compare the key/index structure

Parameters:

&$xmlkey	&$xmlkey:
&$dbkey	&$dbkey:

API Tags:

Return:	true/false
Access:	public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

connect [Zeile 77]

boolean connect(
)

connect to Database

API Tags:

Return:	Erfolg
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::connect() : Establish connection to database
dbcon_mysqli::connect() : Establish connection to database
dbcon_pgsql::connect() : Establish connection to database

[ Seitenanfang ]

createTable [Zeile 236]

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

Create table

Parameters:

string	&$tabledata:
string	$tableprefix:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::createTable() : Create given table
dbcon_mysqli::createTable() : Create given table
dbcon_pgsql::createTable() : Create given table

[ Seitenanfang ]

deleteRecord [Zeile 190]

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

delete database record

Parameters:

string	$table:	table
string	$idfield:	Index column
string	$value:	Index

API Tags:

Return:	false or number of affected_rows or database result object
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::deleteRecord() : Delete record
dbcon_mysqli::deleteRecord() : Delete record
dbcon_pgsql::deleteRecord() : Delete record

[ Seitenanfang ]

deleteRecords [Zeile 202]

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

delete database records

Parameters:

string	$table:	table
string	$filter:	condition

API Tags:

Return:	false or number of affected_rows or database result object
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::deleteRecords() : Delete records by filter
dbcon_mysqli::deleteRecords() : Delete records by filter
dbcon_pgsql::deleteRecords() : Delete records by filter

[ Seitenanfang ]

dropField [Zeile 272]

boolean dropField(
string
$table, string
$field 
)

Delete field

Parameters:

string	$table:
string	$field:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

dropIndex [Zeile 309]

boolean dropIndex(
string
$table, string
$name 
)

Delete index

Parameters:

string	$table:
string	$name:

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

getError [Zeile 87]

array getError(
)

Supply error

API Tags:

Return:	error data
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::getError() : Provides error messages of last database connection
dbcon_mysqli::getError() : Provides error messages of last database connection
dbcon_pgsql::getError() : Provides error messages of last database connection

[ Seitenanfang ]

getSQLCondition [Zeile 129]

void getSQLCondition(
mixed
$filter 
)

[ Seitenanfang ]

getSQLSource [Zeile 321]

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

Neu definiert in folgenden Ableitungen:

dbcon_mysql::getSQLSource() : DBMS spezific SQL source
dbcon_mysqli::getSQLSource() : DBMS spezific SQL source
dbcon_pgsql::getSQLSource() : DBMS spezific SQL source

[ Seitenanfang ]

insertRecord [Zeile 113]

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

Insert new record

Parameters:

string	$table:	table
string	$idfield:	Index column
array	$values:	values

API Tags:

Return:	false or Id of new record
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::insertRecord() : Insert record into table
dbcon_mysqli::insertRecord() : Insert record into table
dbcon_pgsql::insertRecord() : Insert record into table

[ Seitenanfang ]

insertRecords [Zeile 125]

mixed insertRecords(
string
$table, array
$values 
)

Insert many records at once

Parameters:

string	$table:	tablen
array	$values:	values

API Tags:

Return:	false or Id of new record
Access:	public

Neu definiert in folgenden Ableitungen:

[ Seitenanfang ]

query [Zeile 100]

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

Database request

Parameters:

string	$sql:	SQL-string
integer	$max:	data record limit
integer	$offset:	startindex - data record limit

API Tags:

Return:	false or number of affected_rows or database result object
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::query() : Execute MySQL-query
dbcon_mysqli::query() : Execute MySQL-query
dbcon_pgsql::query() : Execute PostgreSQL-query

[ Seitenanfang ]

queryTableNames [Zeile 212]

array queryTableNames(
)

Get all table names

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::queryTableNames() : Get table names
dbcon_mysqli::queryTableNames() : Get table names
dbcon_pgsql::queryTableNames() : Get table names

[ Seitenanfang ]

queryTableStructure [Zeile 224]

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

table structur as array

Parameters:

string	$tablename:	table name
string	$tableprefix:	Prefix

API Tags:

Access:

public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::queryTableStructure() : Query table structure
dbcon_mysqli::queryTableStructure() : Query table structure
dbcon_pgsql::queryTableStructure() : Query table structure

[ Seitenanfang ]

updateRecord [Zeile 164]

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

Change database record

Parameters:

string	$table:	table
array	$values:	values
string	$idfield:	Index column
string	$value:	Index

API Tags:

Return:	false or number of affected_rows or database result object
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::updateRecord() : Update record
dbcon_mysqli::updateRecord() : Update record
dbcon_pgsql::updateRecord() : Update record

[ Seitenanfang ]

updateRecords [Zeile 177]

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

Change database records

Parameters:

string	$table:	Table
array	$values:	values
string	$filter:	condition

API Tags:

Return:	false or number of affected_rows or database result object
Access:	public

Neu definiert in folgenden Ableitungen:

dbcon_mysql::updateRecords() : Update records via filter
dbcon_mysqli::updateRecords() : Update records via filter
dbcon_pgsql::updateRecords() : Update records via filter

[ Seitenanfang ]