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; }