PHP Class Pop\Db\Adapter\Mysql

Author: Nick Sagona, III ([email protected])

Inheritance: extends AbstractAdapter

Public Methods

Method	Description
__construct ( array $options ) : Mysql	Constructor
disconnect ( ) : void	Close the DB connection.
escape ( string $value ) : string	Return the escaped string value.
execute ( string $sql ) : void	Execute the prepared SQL query.
fetch ( ) : array	Return the results array from the results resource.
lastId ( ) : integer	Return the auto-increment ID of the last query.
numFields ( ) : integer	Return the number of fields in the result.
numRows ( ) : integer	Return the number of rows in the result.
query ( string $sql ) : void	Execute the SQL query and create a result resource, or display the SQL error.
showError ( ) : void	Throw an exception upon a database error.
version ( ) : string	Return the database version.

Method	Description
loadTables ( ) : array	Get an array of the tables of the database.

Instantiate the Mysql database connection object.

public __construct ( array $options ) : Mysql
$options	array
return	Mysql

Close the DB connection.

public disconnect ( ) : void
return	void

Return the escaped string value.

public escape ( string $value ) : string
$value	string
return	string

Execute the prepared SQL query.

public execute ( string $sql ) : void
$sql	string
return	void

Return the results array from the results resource.

public fetch ( ) : array
return	array

Return the auto-increment ID of the last query.

public lastId ( ) : integer
return	integer

Get an array of the tables of the database.

protected loadTables ( ) : array
return	array

Return the number of fields in the result.

public numFields ( ) : integer
return	integer

Return the number of rows in the result.

public numRows ( ) : integer
return	integer

Execute the SQL query and create a result resource, or display the SQL error.

Throw an exception upon a database error.

public showError ( ) : void
return	void

Return the database version.

public version ( ) : string
return	string