PHP Class Pop\Db\Adapter\Pgsql

Author: Nick Sagona, III ([email protected])
Inheritance: extends AbstractAdapter
ファイルを表示 Open project: nicksagona/PopPHP

Protected Properties

Property Type Description
$parameters array Prepared statement parameters
$sql string Prepared SQL string
$statement resource Prepared statement
$statementIndex integer Statement index
$statementName string Prepared statement name

Public Methods

Method Description
__construct ( array $options ) : Pgsql Constructor
bindParams ( string | array $params ) : Pgsql Bind parameters to for a prepared SQL query.
disconnect ( ) : void Close the DB connection.
escape ( string $value ) : string Return the escaped string value.
execute ( ) : void Execute the prepared SQL query.
fetch ( ) : array Return the results array from the results resource.
fetchResult ( ) : array Fetch and return the values.
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.
prepare ( string $sql ) : Pgsql Prepare a SQL query.
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.

Protected Methods

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

Method Details

__construct() public method

Instantiate the PostgreSQL database connection object.
public __construct ( array $options ) : Pgsql
$options array
return Pgsql

bindParams() public method

Bind parameters to for a prepared SQL query.
public bindParams ( string | array $params ) : Pgsql
$params string | array
return Pgsql

disconnect() public method

Close the DB connection.
public disconnect ( ) : void
return void

escape() public method

Return the escaped string value.
public escape ( string $value ) : string
$value string
return string

execute() public method

Execute the prepared SQL query.
public execute ( ) : void
return void

fetch() public method

Return the results array from the results resource.
public fetch ( ) : array
return array

fetchResult() public method

Fetch and return the values.
public fetchResult ( ) : array
return array

lastId() public method

Return the auto-increment ID of the last query.
public lastId ( ) : integer
return integer

loadTables() protected method

Get an array of the tables of the database.
protected loadTables ( ) : array
return array

numFields() public method

Return the number of fields in the result.
public numFields ( ) : integer
return integer

numRows() public method

Return the number of rows in the result.
public numRows ( ) : integer
return integer

prepare() public method

Prepare a SQL query.
public prepare ( string $sql ) : Pgsql
$sql string
return Pgsql

query() public method

Execute the SQL query and create a result resource, or display the SQL error.
public query ( string $sql ) : void
$sql string
return void

showError() public method

Throw an exception upon a database error.
public showError ( ) : void
return void

version() public method

Return the database version.
public version ( ) : string
return string

Property Details

$parameters protected_oe property

Prepared statement parameters
protected array $parameters
return array

$sql protected_oe property

Prepared SQL string
protected string $sql
return string

$statement protected_oe property

Prepared statement
protected resource $statement
return resource

$statementIndex protected_oe static_oe property

Statement index
protected static int $statementIndex
return integer

$statementName protected_oe property

Prepared statement name
protected string $statementName
return string