Ister PHP Documentation - Docs For Class IsterSqlDriverMysql

constructor IsterSqlDriverMysql

IsterSqlDriverMysql IsterSqlDriverMysql(
)

Constructor

[ Top ]

method asyncQuery

boolean asyncQuery(
mixed
$query)

Send an asynchronous query.

Note: for MySQL this is not really asynchronous like with PostgreSQL; you must fetch all rows before you can send the next query.

return:

true on success, false on error

[ Top ]

method close

boolean close(
)

Close the current connection.

[ Top ]

method connect

boolean connect(
[boolean
$newlink = false])

Establish a connection.

Parameters:

boolean

$newlink

Force a new link to be created.

[ 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 or link are invalid.

return:

Number of rows in current result set, false on error

[ Top ]

method escapeString

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

Escape a string.

Parameters:

string	$string
boolean	$binary	ignored by MySQL driver

[ Top ]

method fetchObject

object IsterSqlRow fetchObject(
)

Fetch the next IsterSqlRow object of the current result set.

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

[ Top ]

method free

resource free(
)

Free the current result set.

If the last query was an asyncQuery(), the connection will be reopened.

see:

IsterSqlDriverMysql::asyncQuery()

[ Top ]

method getLastError

string getLastError(
)

Get the last MySQL 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
                'socket'            => $str // socket
                'client_encoding'   => $str // client encoding
                'server_version'    => $str // version of MySQL server
                'client_version'    => $str // version of MySQL client library
                'protokoll_version' => $str // version of used protokoll
                'link'              => $str // info about the current connection
                );

[ 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 = false])

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 string.

Parameters:

string	$string
boolean	$binary	trigger use of stripcslashes() instead of stripslashes()

[ Top ]

Class: IsterSqlDriverMysql

Class Overview

Methods

Inherited Constants

Inherited Variables

Class: IsterSqlDriver

Inherited Methods

Class: IsterSqlDriver

Class: IsterObject

Class Details

Class Methods

constructor IsterSqlDriverMysql

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 ]