Ister PHP Documentation - Docs For Class IsterSqlDriverPostgresql

constructor IsterSqlDriverPostgresql

IsterSqlDriverPostgresql IsterSqlDriverPostgresql(
)

[ Top ]

method asyncQuery

boolean asyncQuery(
mixed
$query)

Send an asynchronous query.

return:

true on success, false on error

[ Top ]

method close

boolean close(
)

Close the current connection.

[ Top ]

method connect

boolean connect(
[boolean
$newlink = true])

Establish a connection.

For PostgreSQL the $newlink parameter does not force the creation of a new link since the pgsql extension does not allow this. Instead the connection will be reset.

Parameters:

boolean

$newlink

[ Top ]

method countRows

integer countRows(
)

Count the rows in the current result set.

The method returns 0 without any warning if the current result ressource is invalid.

return:

Number of rows in current result set

[ Top ]

method escapeString

string escapeString(
string
$string, [boolean
$binary = false])

Parameters:

string	$string
boolean	$binary

[ Top ]

method fetchObject

object IsterSqlRow fetchObject(
)

Fetch the next IsterSqlRow object of the current result set.

return:	object, null on error or if no more rows are left.
see:	IsterSqlRow

[ Top ]

method free

resource free(
)

Free the current result set.

see:

IsterSqlDriverPostgresql::asyncQuery()

[ Top ]

method getLastError

string getLastError(
)

Get the last PostgreSQL or driver error.

[ Top ]

method info

array info(
)

This function returns useful information about the active driver.

 array( 'driver_name'       => $str // name of the driver
                'driver_version'    => $str // dotted version number
                'host'              => $str // name or IP of the servers host
                'dbname'            => $str // current used database
                'port'              => $int // port number
                'client_encoding'   => $str // client encoding
                'server_pid'        => $str // backend PID
                'options'           => $str // options specified on the connection
                'tty'               => $str // version of used protokoll
                );

[ Top ]

method isConnected

boolean isConnected(
)

Check whether a connection is established.

[ Top ]

method lastWasRead

boolean lastWasRead(
)

Check whether the last query was a read (SELECT) operation or not.

[ Top ]

method pconnect

boolean pconnect(
[mixed
$newlink = true])

Establish a persistent connection.

[ Top ]

method query

boolean query(
mixed
$query)

Send a query.

return:

true on success, false on error

[ Top ]

method setLink

boolean setLink(
resource
$link)

Set the current connection resource.

return:

true on success, false on failure

Parameters:

resource

$link

[ Top ]

method unescapeString

string unescapeString(
string
$string, [boolean
$binary = false])

Unescape a previously escaped string.

For binary strings the method is expensive in time and memory consumption. This is because pg_unescape_bytea() returns a string containing an octal representation of the binary data, which must be parsed by this method to become binary again.

Parameters:

string	$string
boolean	$binary

[ Top ]

Class: IsterSqlDriverPostgresql

Class Overview

Methods

Inherited Constants

Inherited Variables

Class: IsterSqlDriver

Inherited Methods

Class: IsterSqlDriver

Class: IsterObject

Class Details

Class Methods

constructor IsterSqlDriverPostgresql

method asyncQuery

method close

method connect

method countRows

method escapeString

method fetchObject

method free

method getLastError

method info

method isConnected

method lastWasRead

method pconnect

method query

method setLink

method unescapeString

	sql
	[ doc home ] [ class tree: sql ] [ index: sql ] [ all elements ]