[DB] element index

Package indexes

All elements
a c d e f g i l m n p q r s t u _
_
top
Variable $_conn
PhpFunk_DB_DAO::$_conn in DAO.php
Variable $_conn
PhpFunk_DB_TableDataGateway::$_conn in TableDataGateway.php
Variable $_pkey
PhpFunk_DB_TableDataGateway::$_pkey in TableDataGateway.php
Variable $_pkey
PhpFunk_DB_DAO::$_pkey in DAO.php
Column in table that is pkey for DTO
Variable $_table
PhpFunk_DB_DAO::$_table in DAO.php
Name of table DTO maps to
Variable $_table
PhpFunk_DB_TableDataGateway::$_table in TableDataGateway.php
Variable $_vendor
PhpFunk_DB_DAO::$_vendor in DAO.php
Prefixed in front of pkg_class by get_dto_class()
Method _create_from_array
PhpFunk_DB_DAO::_create_from_array() in DAO.php
Method _disableQueryCache
PhpFunk_DB_MySQLDriver::_disableQueryCache() in MySQLDriver.php
Method _enableQueryCache
PhpFunk_DB_MySQLDriver::_enableQueryCache() in MySQLDriver.php
Method _find
PhpFunk_DB_DAO::_find() in DAO.php
Generic find using any SQL statement
Method _get_vars
PhpFunk_DB_DTO::_get_vars() in DTO.php
This instance method would really be package-private access
Method _insert
PhpFunk_DB_DAO::_insert() in DAO.php
Insert a DTO object
Method _update
PhpFunk_DB_DAO::_update() in DAO.php
Update a DTO object
a
top
Method affectedRows
PhpFunk_DB_MySQLDriver::affectedRows() in MySQLDriver.php
Method affectedRows
PhpFunk_DB_DBWrapper::affectedRows() in DBWrapper.php
c
top
Method commit
PhpFunk_DB_MySQLDriver::commit() in MySQLDriver.php
mysql will always return TRUE even if engine is not transaction-safe
Method commit
PhpFunk_DB_DBWrapper::commit() in DBWrapper.php
Returns FALSE if unable to commit
Method connect
PhpFunk_DB_MySQLDriver::connect() in MySQLDriver.php
Method connect
PhpFunk_DB_DBWrapper::connect() in DBWrapper.php
Returns TRUE on successful connection
d
top
Variable $db
PhpFunk_DB_MySQLDriver::$db in MySQLDriver.php
Variable $dto_class
PhpFunk_DB_DAO::$dto_class in DAO.php
Class name of DTO this DAO manages. You must include it!
Page DAO.php
DAO.php in DAO.php
Page DBWrapper.php
DBWrapper.php in DBWrapper.php
Page DTO.php
DTO.php in DTO.php
Method delete
PhpFunk_DB_TableDataGateway::delete() in TableDataGateway.php
Returns number of rows deleted or FALSE on error
Method delete
PhpFunk_DB_DAO::delete() in DAO.php
Method delete_by_pkey
PhpFunk_DB_DAO::delete_by_pkey() in DAO.php
Like delete() but only requires the pkey value
Method disconnect
PhpFunk_DB_MySQLDriver::disconnect() in MySQLDriver.php
Method disconnect
PhpFunk_DB_DBWrapper::disconnect() in DBWrapper.php
e
top
Method escape
PhpFunk_DB_DBWrapper::escape() in DBWrapper.php
Escape an argument so it can be safely inserted into database
Method escape
PhpFunk_DB_MySQLDriver::escape() in MySQLDriver.php
Method escapeString
PhpFunk_DB_MySQLDriver::escapeString() in MySQLDriver.php
Method execute
PhpFunk_DB_MySQLDriver::execute() in MySQLDriver.php
Perform an sql query (non-select)
Method execute
PhpFunk_DB_DBWrapper::execute() in DBWrapper.php
Method executePrepared
PhpFunk_DB_MySQLDriver::executePrepared() in MySQLDriver.php
Method executePrepared
PhpFunk_DB_DBWrapper::executePrepared() in DBWrapper.php
Execute a prepared statement.
f
top
Method find
PhpFunk_DB_DAO::find() in DAO.php
Same as find_by_pkey
Method find
PhpFunk_DB_TableDataGateway::find() in TableDataGateway.php
Method findAll
PhpFunk_DB_TableDataGateway::findAll() in TableDataGateway.php
Method find_all
PhpFunk_DB_DAO::find_all() in DAO.php
Find all records matching criteria. If you need group and order by clauses better to use _find() with your own sql.
Method find_by_pkey
PhpFunk_DB_DAO::find_by_pkey() in DAO.php
Returns a DTO or FALSE on DB error or NULL if not found
Method find_one
PhpFunk_DB_DAO::find_one() in DAO.php
Preferred method to find one using a where clause
Method find_where
PhpFunk_DB_DAO::find_where() in DAO.php
Like find_all but only finds ONE object (even if more match)
Method from_array
PhpFunk_DB_DTO::from_array() in DTO.php
Updates ivars of this DTO with values from assoc array $arr
g
top
Method get_dto_class
PhpFunk_DB_DAO::get_dto_class() in DAO.php
Instance method to encapsulate the class to table naming convention
i
top
Method insert
PhpFunk_DB_TableDataGateway::insert() in TableDataGateway.php
Returns the id of the inserted row or FALSE on error
Method isConnected
PhpFunk_DB_MySQLDriver::isConnected() in MySQLDriver.php
Method isConnected
PhpFunk_DB_DBWrapper::isConnected() in DBWrapper.php
l
top
Method lastError
PhpFunk_DB_MySQLDriver::lastError() in MySQLDriver.php
Method lastError
PhpFunk_DB_DBWrapper::lastError() in DBWrapper.php
Returns last error msg or FALSE if there was none
Method lastInsertID
PhpFunk_DB_MySQLDriver::lastInsertID() in MySQLDriver.php
Method lastInsertID
PhpFunk_DB_DBWrapper::lastInsertID() in DBWrapper.php
The driver will attempt to return the last insert ID.
m
top
Page MySQLDriver.php
MySQLDriver.php in MySQLDriver.php
Method MySQLDriver
PhpFunk_DB_MySQLDriver::MySQLDriver() in MySQLDriver.php
n
top
Method numRecords
PhpFunk_DB_TableDataGateway::numRecords() in TableDataGateway.php
p
top
Variable $prepared
PhpFunk_DB_MySQLDriver::$prepared in MySQLDriver.php
Class PhpFunk_DB_DAO
PhpFunk_DB_DAO in DAO.php
The DAO reads and writes DTO to database
Method PhpFunk_DB_DAO
PhpFunk_DB_DAO::PhpFunk_DB_DAO() in DAO.php
Class PhpFunk_DB_DBWrapper
PhpFunk_DB_DBWrapper in DBWrapper.php
DB abstraction layer
Method PhpFunk_DB_DTO
PhpFunk_DB_DTO::PhpFunk_DB_DTO() in DTO.php
Create instance passing in assoc array
Class PhpFunk_DB_DTO
PhpFunk_DB_DTO in DTO.php
Data Transfer Object is literally dumb data object
Class PhpFunk_DB_MySQLDriver
PhpFunk_DB_MySQLDriver in MySQLDriver.php
Interface to MySQL databases
Class PhpFunk_DB_TableDataGateway
PhpFunk_DB_TableDataGateway in TableDataGateway.php
Method prepare
PhpFunk_DB_DBWrapper::prepare() in DBWrapper.php
Prepare a statement for execution w/ executePrepared()
Method prepare
PhpFunk_DB_MySQLDriver::prepare() in MySQLDriver.php
q
top
Variable $queryCacheSize
PhpFunk_DB_MySQLDriver::$queryCacheSize in MySQLDriver.php
r
top
Method rollback
PhpFunk_DB_DBWrapper::rollback() in DBWrapper.php
Returns FALSE if unable to rollback!
Method rollback
PhpFunk_DB_MySQLDriver::rollback() in MySQLDriver.php
mysql will always return TRUE even if engine is not transaction-safe
s
top
Method save
PhpFunk_DB_DAO::save() in DAO.php
Insert or update a DTO object
Method selectColumn
PhpFunk_DB_MySQLDriver::selectColumn() in MySQLDriver.php
Method selectColumn
PhpFunk_DB_DBWrapper::selectColumn() in DBWrapper.php
Get first column of each row in result set.
Method selectOne
PhpFunk_DB_DBWrapper::selectOne() in DBWrapper.php
Method selectOne
PhpFunk_DB_MySQLDriver::selectOne() in MySQLDriver.php
Fetches a row or a single value from database.
Method selectRows
PhpFunk_DB_MySQLDriver::selectRows() in MySQLDriver.php
Method selectRows
PhpFunk_DB_DBWrapper::selectRows() in DBWrapper.php
Returns rows of assoc array or NULL if no matches are found.
Method startTransaction
PhpFunk_DB_MySQLDriver::startTransaction() in MySQLDriver.php
mysql will always return TRUE even if engine is not transaction-safe
Method startTransaction
PhpFunk_DB_DBWrapper::startTransaction() in DBWrapper.php
Returns FALSE if unable to start transaction
t
top
Page TableDataGateway.php
TableDataGateway.php in TableDataGateway.php
Method TableDataGateway
PhpFunk_DB_TableDataGateway::TableDataGateway() in TableDataGateway.php
Method to_array
PhpFunk_DB_DTO::to_array() in DTO.php
Return ivars of this DTO as assoc array
u
top
Variable $useQueryCache
PhpFunk_DB_MySQLDriver::$useQueryCache in MySQLDriver.php
Method update
PhpFunk_DB_TableDataGateway::update() in TableDataGateway.php
Updates $row using $pkey as where clause
a c d e f g i l m n p q r s t u _