database connection resource
protected $conn
database name
protected $db
DataAccessError
private $error
DataAccessMysql class constructor
public function __construct( $host, $user, $pass, $db )
given a hostname, username, password and database name makes a connection to the database and selects the database if the connection cannot be made or the database cannot be selected, throws DAOExcpetion
public function connect( $host, $user, $pass, $db )
given an SQL string, queries the database and returns the result or throws DAOException
public function query( $sql )
escape a value before using it in a query string
public function escape( $val )
returns the number of rows affected by an insert, update or delete query
public function getAffectedRows()
disconnect database connection
public function disconnect()