function getProfilebyname($username)
{
$user_id = getAccountid($username);
$sql = "SELECT * FROM user_details WHERE user_id = :user_id AND isdeleted = 0";
$params = array(':user_id' => $user_id);
$result = DatabaseHandler::GetAll($sql, $params);
return $result;
}
<?php
$user = $_SESSION['user'];
$userid = getAccountid($user);
$regval = "";
$registerscs = "";
$stuff = "";
$categorywise = "";
$eventdetails = array();
$categories = array();
$events = array();
$count = array();
if (isset($_GET['eventid'])) {
$eventdetails = getEventbyid(addslashes(htmlentities($_GET['eventid'])));
if ($eventdetails && count($eventdetails)) {
$stuff = "<div class='box'>\n\t\t\t\t\t<div class='box-head'>\n\t\t\t\t\t\t<h2 class='left'> " . $eventdetails[0]['event_name'] . ": </h2>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'><br>\n\t\t\t\t\t\t<h3><b><u>About: </u></b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px; font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['about']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Rules:</u> </b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px;font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['rules']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Contest Link:</u></b> </h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px;font-size:14px; line-height:18px;'><a href='" . stripslashes($eventdetails[0]['clink']) . "' target='new'>" . stripslashes($eventdetails[0]['clink']) . "</a></p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Contact Details:</u> </b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px; font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['contacts']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t";
}
}
if (isset($_POST['register'])) {
$regval = addslashes(htmlentities($_POST['regval']));
if (!alreadyRegistered($userid, $regval)) {
if (isProfileComplete($user)) {
registerEvent($regval, $userid, $user);
$registerscs = "<p style='color:#74a446; font-size:15px;' > You have successfully registered to the Event! </p>";
} else {
$registerscs = "<p style='color:red; font-size:15px;' > First you need to complete your profile information to apply for Events.<p>";
}
} else {
$registerscs = "<p style='color:#74a446; font-size:15px;' > You are already registered to the Event! </p>";
}
$eventdetails = getEventbyid($regval);
<?php
$username = $_SESSION['user'];
$userid = getAccountid($username);
$eventlist = "";
$eventname = "";
$upcoming = "";
$ongoing = "";
$registered = "";
$events = array();
$categories = array();
$news = array();
$timezone = "Asia/Calcutta";
date_default_timezone_set($timezone);
$eventlist = getRegisteredEvents($userid);
for ($i = 0; $i < count($eventlist); $i++) {
$eventname = getEventbyid($eventlist[$i]['event_id']);
$registered .= "<tr>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>{$eventname[0]['event_name']}</p></td>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>" . format_date($eventname[0]['start']) . "</p></td>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>" . format_date($eventname[0]['end']) . "</p></td>\n\t\t </tr>\n\t ";
}
$categories = getEventCategories();
$events = getAllEvents();
for ($i = 0; $i < count($categories); $i++) {
$eventcat = $categories[$i]['id'];
for ($j = 0; $j < count($events); $j++) {
if ($eventcat == $events[$j]['event_category_id']) {
if (strtotime($events[$j]['start']) <= time() && time() < strtotime($events[$j]['end'])) {
$ongoing .= "<tr><td>{$events[$j]['event_name']}</td><td>" . ucFirst($categories[$i]['name']) . "</td><td>" . format_date($events[$j]['end']) . "</td></tr>";
}
}
}
}
