DAO

general purpose data access object meant to handle all communcations with the database through DataAccess and DataResult objects

see

DAOException

Summary
general purpose data access object meant to handle all communcations with the database through DataAccess and DataResult objects
DataAccess object
creates a connection to the database
closes database connection and unsets DataAccess object
runs database select query and returns DataResult object
runs database insert/update/dete/ query and returns DataResult object

Variables

da

protected $da

DataAccess object

Functions

__construct

public function __construct($connStr)

creates a connection to the database

parameters

connStrdatabase connection string

close

public function close()

closes database connection and unsets DataAccess object

retrieve

public function retrieve($sql)

runs database select query and returns DataResult object

parameters

sqlsql string

returns

DataResult object

update

public function update($sql)

runs database insert/update/dete/ query and returns DataResult object

parameters

sqlsql string

returns

DataResult object

protected $da
DataAccess object
public function __construct($connStr)
creates a connection to the database
public function close()
closes database connection and unsets DataAccess object
public function retrieve($sql)
runs database select query and returns DataResult object
public function update($sql)
runs database insert/update/dete/ query and returns DataResult object