Home | Classes | Modules | Annotated | Functions | Files

MySQLConnection Class Reference
[Creole::Drivers, Creole::Drivers::MySQL]

Inherits ConnectionCommon.

List of all members.

Public Member Functions

• connect ($dsninfo, $flags=0)
• & getDatabaseInfo ()
• & getIdGenerator ()
• & prepareStatement (&$sql)
• & prepareCall (&$sql)
• & createStatement ()
• close ()
• & executeQuery ($sql, $fetchmode=null)
• & executeUpdate ($sql)
• commit ()
• rollback ()
• getUpdateCount ()

Public Attributes

• $database

---

Detailed Description

MySQL implementation of Connection.

Author Hans Lellelid <hans@xmpl.org>

Stig Bakken <ssb@fast.no>

Lukas Smith

Version 

Revision

1.2

---

Member Function Documentation

MySQLConnection::connect ( $  dsninfo,  $  flags = 0 )

Connect to a database and log in as the specified user. Parameters: $dsn  the data source name (see DB::parseDSN for syntax) $flags  Any conneciton flags. public Returns TRUE on success, SQLException on error Reimplemented from Connection.

& MySQLConnection::getDatabaseInfo ()

See also Connection::getDatabaseInfo() Reimplemented from Connection.

& MySQLConnection::getIdGenerator ()

See also Connection::getIdGenerator() Reimplemented from Connection.

& MySQLConnection::prepareStatement ( &$  sql)

See also Connection::prepareStatement()

& MySQLConnection::prepareCall ( &$  sql)

See also Connection::prepareCall() Reimplemented from ConnectionCommon.

& MySQLConnection::createStatement ()

See also Connection::createStatement() Reimplemented from Connection.

MySQLConnection::close ()

See also Connection::disconnect() Reimplemented from Connection.

& MySQLConnection::executeQuery ( $  sql,  $  fetchmode = null )

See also Connection::executeQuery() Reimplemented from Connection.

& MySQLConnection::executeUpdate ( $  sql)

See also Connection::executeUpdate() Reimplemented from Connection.

MySQLConnection::commit ()

Commit the current transaction. Returns TRUE on success, SQLException on error. See also Connection::commit() Reimplemented from Connection.

MySQLConnection::rollback ()

Roll back (undo) the current transaction. Returns TRUE on success, SQLException on error. Reimplemented from Connection.

MySQLConnection::getUpdateCount ()

Gets the number of rows affected by the data manipulation query. Returns int Number of rows affected by the last query. Reimplemented from Connection.

---

Member Data Documentation

MySQLConnection::$database

Current database (used in mysql_select_db()).

---

This file is part of the Creole[php4] library.