API Documentation
\
Pop
Acl
Assertion
Resource
Role
Archive
Adapter
Compress
Auth
Adapter
Cache
Adapter
Code
Generator
Config
Console
Input
Controller
Cookie
Crypt
Data
Type
Db
Adapter
Gateway
Parser
Record
Sql
Dom
Event
Feed
Format
File
Form
Element
Input
Template
Ftp
Http
Client
I18n
Format
Image
Adjust
Draw
Effect
Factory
Filter
Layer
Type
Loader
Log
Writer
Mail
Module
Nav
Paginator
Payment
Adapter
Pdf
Build
Font
TrueType
Table
Cmap
Image
Object
Document
Page
Annotation
Color
Field
Router
Match
Service
Session
Shipping
Adapter
Validator
Version
View
Template

\Pop\Db\AdapterAbstractAdapter

Db abstract adapter class

Summary

Methods
Properties
Constants
getAvailableAdapters()
isAvailable()
__construct()
showError()
prepare()
bindParams()
execute()
query()
fetch()
escape()
lastId()
numberOfRows()
numberOfFields()
getStatement()
hasResult()
getResult()
isConnected()
getConnection()
disconnect()
getTables()
version()
isPdo()
No public properties found
No constants found
loadTables()
$result
$connection
$statement
$tables
N/A
No private methods found
No private properties found
N/A

Properties

$result

$result : resource

Database results

Type

resource

$connection

$connection : resource

Default database connection

Type

resource

$statement

$statement : mixed

Prepared statement

Type

mixed

$tables

$tables : array

Database tables

Type

array

Methods

getAvailableAdapters()

getAvailableAdapters() : array

Get the available database adapters

Returns

array

isAvailable()

isAvailable(string  $adapter) : boolean

Get the available image library adapters

Parameters

string $adapter

Returns

boolean

__construct()

__construct(array  $options) : \Pop\Db\Adapter\AbstractAdapter

Constructor

Instantiate the database adapter object.

Parameters

array $options

Returns

\Pop\Db\Adapter\AbstractAdapter

showError()

showError() : void

Throw an exception upon a database error.

Throws

\Pop\Db\Adapter\Exception

bindParams()

bindParams(array  $params) : \Pop\Db\Adapter\AbstractAdapter

Bind parameters to a prepared SQL query.

Parameters

array $params

Returns

\Pop\Db\Adapter\AbstractAdapter

execute()

execute() : void

Execute the prepared SQL query.

Throws

\Pop\Db\Adapter\Exception

query()

query(string  $sql) : void

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

Parameters

string $sql

fetch()

fetch() : array

Return the results array from the results resource.

Throws

\Pop\Db\Adapter\Exception

Returns

array

escape()

escape(string  $value) : string

Return the escaped string value.

Parameters

string $value

Returns

string

lastId()

lastId() : integer

Return the auto-increment ID of the last query.

Returns

integer

numberOfRows()

numberOfRows() : integer

Return the number of rows in the result.

Throws

\Pop\Db\Adapter\Exception

Returns

integer

numberOfFields()

numberOfFields() : integer

Return the number of fields in the result.

Throws

\Pop\Db\Adapter\Exception

Returns

integer

getStatement()

getStatement() : resource

Get the statement resource

Returns

resource

hasResult()

hasResult() : boolean

Determine whether or not an result resource exists

Returns

boolean

getResult()

getResult() : resource

Get the result resource

Returns

resource

isConnected()

isConnected() : boolean

Determine whether or not connected

Returns

boolean

getConnection()

getConnection() : resource

Get the connection resource

Returns

resource

disconnect()

disconnect() : void

Disconnect from the database

getTables()

getTables() : array

Get an array of the tables of the database.

Returns

array

version()

version() : string

Return the database version.

Returns

string

isPdo()

isPdo() : boolean

Return if the adapter is a PDO adapter

Returns

boolean

loadTables()

loadTables() : array

Load the tables of the database into an array.

Returns

array