Public Member Functions | |
__construct () | |
__destruct () | |
connectDB ($sHost, $sPort, $sDBName, $sUser, $sPassword) | |
connectDBAdmin () | |
connectDBUser ($sUser, $sPassword) | |
closeDB () | |
executeTransaction ($pQueryArray) | |
executeSQL ($sQuery) | |
getNextRecord () | |
hasMoreFields () | |
getNextField () | |
getNextFieldDescription () | |
getAffectedRows () | |
getNumberRows () | |
getNumberFields () | |
getLastError () | |
getLastErrorNo () | |
escapeString ($sString) |
pgsql::__construct | ( | ) |
Constructor
pgsql::__destruct | ( | ) |
Destructor
pgsql::connectDB | ( | $ | sHost, | |
$ | sPort, | |||
$ | sDBName, | |||
$ | sUser, | |||
$ | sPassword | |||
) |
Connects to the database server.
$sHost | Hostname or IP adress of database server. | |
$sPort | Port of database server. | |
$sDBName | Database instance name. | |
$sUser | User name to connect. | |
$sPassword | Password to user name. |
Implements iDatabase.
pgsql::connectDBAdmin | ( | ) |
pgsql::connectDBUser | ( | $ | sUser, | |
$ | sPassword | |||
) |
Connect user to database.
$sUser | User name. | |
$sPassword | Password. |
Implements iDatabase.
pgsql::closeDB | ( | ) |
Frees result and close the database connection.
Implements iDatabase.
pgsql::executeTransaction | ( | $ | pQueryArray | ) |
Executes a transaction (array with SQL statements).
$pQueryArray |
Implements iDatabase.
pgsql::executeSQL | ( | $ | sQuery | ) |
Executes a single query.
$sQuery |
Implements iDatabase.
pgsql::getNextRecord | ( | ) |
Get next record, free result set if no more recors are available.
Implements iDatabase.
pgsql::hasMoreFields | ( | ) |
Check if there are more fields in the result set.
Implements iDatabase.
pgsql::getNextField | ( | ) |
pgsql::getNextFieldDescription | ( | ) |
Get next field description.
Implements iDatabase.
pgsql::getAffectedRows | ( | ) |
Get number of affected rows by insert, update a.s.o.
Implements iDatabase.
pgsql::getNumberRows | ( | ) |
pgsql::getNumberFields | ( | ) |
pgsql::getLastError | ( | ) |
pgsql::getLastErrorNo | ( | ) |
pgsql::escapeString | ( | $ | sString | ) |
Escapes string for security reasons.
$sString | String to escape. |
Implements iDatabase.