public function get($id)
{
$sql = "SELECT * FROM role WHERE id=:id";
$params[':id'] = $id;
$role = $this->daoTemplate->queryForObject($sql, new RoleRowMapper(), $params);
$sql = "SELECT code_right FROM role_right WHERE id_role=:id";
$role->listRight = $this->daoTemplate->simpleQueryToArray($sql, $params);
return $role;
}
/**
*
* @param $id int
* @return UserDto
* @see User_Models_UserDao::get()
*/
public function get($id)
{
$sql = "SELECT * FROM user WHERE id=:id";
$params[':id'] = $id;
return $this->daoTemplate->queryForObject($sql, new UserRowMapper(), $params);
}
public function get($id)
{
$sql = "SELECT * FROM category WHERE id=:id";
return $this->daoTemplate->queryForObject($sql, new CategoryRowMapper(), array(':id' => $id));
}
