function insertRole($data)
{
$connection = connect();
$role = new Role();
echo dump($data);
$role->setRole(mysqli_real_escape_string($connection, $data['role']));
$role->setDescription(mysqli_real_escape_string($connection, $data['description']));
$query = "insert into role (";
$query .= " role,description ";
$query .= ") values( ";
$query .= " '{$role->getRole()}','{$role->getDescription()}'";
$query .= ")";
$result = mysqli_query($connection, $query);
if ($result) {
$id = mysqli_insert_id($connection);
return $id;
}
colse_connection($connection);
return null;
}
public function getDescription()
{
$this->_load();
return parent::getDescription();
}
public function addRole(Role $inRole)
{
// check permissions
if (!PermissionEngine::getInstance()->currentUserCanDo('userCanCreateRoles')) {
return false;
}
$db = Database::getInstance();
if (!$db->isConnected()) {
return false;
}
$roleName = $db->escapeString($inRole->getName());
$roleDesc = $db->escapeString($inRole->getDescription());
if ($roleDesc === '') {
$results = $db->insertData('role', 'roleName', '\'' . $roleName . '\'');
} else {
$results = $db->insertData('role', 'roleName, description', '\'' . $roleName . '\',\'' . $roleDesc . '\'');
}
if (!$results) {
return false;
}
return true;
}
