Docs For Class P4A

Description

author: Fabrizio Balliano <fabrizio.balliano@crealabs.it>
author: Andrea Giardina <andrea.giardina@crealabs.it>
copyright: CreaLabs SNC

Located in /p4a/p4a_db.php (line 40)

Variable Summary

string $db_type

Method Summary

static void singleton ([ $DSN = ""])

void beginTransaction ()

void commit ()

void connect ([ $DSN = ""])

array fetchAll (string $query, [array $bind = array()])

array fetchCol (string $query, [array $bind = array()])

string fetchOne (string $query, [array $bind = array()])

array fetchRow (string $query, [array $bind = array()])

array getAll (string $query, [array $bind = array()])

string getCaseInsensitiveLikeSQL (string $column_name, string $search_pattern)

array getCol (string $query, [array $bind = array()])

string getDBType ()

string getOne (string $query, [array $bind = array()])

array getRow (string $query, [array $bind = array()])

integer nextSequenceId (string $sequence_name)

unknown query (string $query, [array $bind = array()])

array queryAll (string $query, [array $bind = array()])

array queryCol (string $query, [array $bind = array()])

string queryOne (string $query, [array $bind = array()])

array queryRow (string $query, [array $bind = array()])

mixed quote (mixed $value, [boolean $autoquote = false])

void rollback ()

Zend_Db_Select select ()

Variables

string $db_type = null (line 45)

access: protected

Methods

static singleton (line 52)

Connects to the configured database.

Database is configured by setting P4A_DSN constant.

throws: onDBConnectionError
access: public

void singleton ([ $DSN = ""])

$DSN

beginTransaction (line 182)

access: public

void beginTransaction ()

commit (line 187)

access: public

void commit ()

connect (line 108)

Connects to the configured database.

Database is configured by setting P4A_DSN constant.

access: private

void connect ([ $DSN = ""])

$DSN

fetchAll (line 224)

access: public

array fetchAll (string $query, [array $bind = array()])

string $query
array $bind

fetchCol (line 288)

access: public

array fetchCol (string $query, [array $bind = array()])

string $query
array $bind

fetchOne (line 320)

access: public

string fetchOne (string $query, [array $bind = array()])

string $query
array $bind

fetchRow (line 256)

access: public

array fetchRow (string $query, [array $bind = array()])

string $query
array $bind

getAll (line 203)

deprecated:
access: public

array getAll (string $query, [array $bind = array()])

string $query
array $bind

getCaseInsensitiveLikeSQL (line 340)

access: public

string getCaseInsensitiveLikeSQL (string $column_name, string $search_pattern)

string $column_name
string $search_pattern

getCol (line 267)

deprecated:
access: public

array getCol (string $query, [array $bind = array()])

string $query
array $bind

getDBType (line 116)

access: public

string getDBType ()

getOne (line 299)

deprecated:
access: public

string getOne (string $query, [array $bind = array()])

string $query
array $bind

getRow (line 235)

deprecated:
access: public

array getRow (string $query, [array $bind = array()])

string $query
array $bind

nextSequenceId (line 125)

access: public

integer nextSequenceId (string $sequence_name)

string $sequence_name

query (line 330)

access: public

unknown query (string $query, [array $bind = array()])

string $query
array $bind

queryAll (line 214)

deprecated:
access: public

array queryAll (string $query, [array $bind = array()])

string $query
array $bind

queryCol (line 278)

deprecated:
access: public

array queryCol (string $query, [array $bind = array()])

string $query
array $bind

queryOne (line 310)

deprecated:
access: public

string queryOne (string $query, [array $bind = array()])

string $query
array $bind

queryRow (line 246)

deprecated:
access: public

array queryRow (string $query, [array $bind = array()])

string $query
array $bind

quote (line 363)

Quotes a value for an SQL statement.

If an array is passed as the value, all values are quoted and returned as a comma-separated string.

access: public

mixed quote (mixed $value, [boolean $autoquote = false])

mixed $value
boolean $autoquote: Ecloses the returned string single in quotes if the value need to be enclosed

rollback (line 192)

access: public

void rollback ()

select (line 177)

access: public

Zend_Db_Select select ()

P4A_DB