function listall() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("cont", $obj->select("tblclientuser")); $this->assign("type", $obj->select("tblusertype")); }
function listall() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("forumcategory", $obj->select("tblforumcategory")); $this->assign("topic", $obj->select("tbltopic")); }
function listall() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("cont", $obj->select("tblcompanyuser join tblusertype on userTypeID=typeID")); $this->assign("type", $obj->select("tblusertype")); }
function display() { include_once "../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("forumcategory", $obj->select("tblforumcategory")); $this->assign("topic", $obj->select("tbltopic")); $this->assign("latest", $obj->select("tbltopic limit 8")); }
function display() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("topic", $obj->selectById("tbltopic", "topicID", $_GET["topicid"])); $this->assign("posts", $obj->select("tblpost")); }
function edit() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("clientinfo", $obj->selectById("tblclientuser", "userID", $_GET["id"])); $this->assign("type", $obj->select("tblusertype")); }
function listall() { include_once "../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("cont", $obj->select("tblnews order by datePosted desc")); }
function listall() { include_once "../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("activities", $obj->select("tblactivity where activityStatus=1 order by datePosted desc ")); }
function listall() { include_once "../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("activities", $obj->select("tblactivity ")); }
function checkAdmin() { include_once "../../data-access/mysql-db.php"; $obj = new DataAccessLayer(); $this->assign("checkAdmin", $obj->select("tbladminaccounts")); }