/**
* @param $roleName
* @return int
*/
function getRoleId(string $roleName) : int
{
$db = SimpleDB::getInstance("conference_scheduler");
$result = $db->prepare("SELECT id FROM roles WHERE name = ?");
$result->execute([$roleName]);
if ($result->affectedRows() === 0) {
throw new \Exception("Role {$roleName} doesn't exist in the database.");
}
return intval($result->fetch()["id"]);
}
/**
* @param int $userId
* @return ProfileViewModel
*/
function getUserInfo(int $userId) : ProfileViewModel
{
$db = SimpleDB::getInstance('conference_scheduler');
$result = $db->prepare("SELECT\r\n username, email\r\n FROM users\r\n WHERE id = ?");
$result->execute([$userId]);
$userRow = $result->fetch();
$user = new ProfileViewModel($userRow['username'], $userRow['email']);
return $user;
}
