if (isset($_GET['key'])) { $view_election_id = $_GET['key']; $election_id = unwrap($view_election_id); $_SESSION['election_id_view'] = $election_id; } //querying for news $view_posted_news = ""; $row1 = getAllMembers("users", ["fname", "lname", "picture_name"], ["user_id", "=", $user_id])[0]; $view_news_query = $connection1->prepare("SELECT * FROM news WHERE election_id = '{$election_id}' ORDER BY date_created DESC"); $view_news_query->execute(); $view_news_query->setFetchMode(PDO::FETCH_ASSOC); $row = $view_news_query->fetchAll(); for ($i = 0; $i < count($row); $i++) { $adminPhoto = $images_dir . $row1['picture_name']; $date_time1 = explode(" ", $row[$i]['date_created']); $date1 = getDateInterval($date_time1[0]); $time1 = timeString($date_time1[1]); $view_posted_news .= "<div class='me' style='margin-bottom:10px; ' >" . "<br>\n <label style='overflow:hidden;text-overflow:ellipsis;'>" . $row[$i]['news'] . "</label>\n <br>" . $date1 . " " . $time1 . "<br></div>"; } //querying for election name $election_name = $election_details_test = ""; $row = getElectionDetails($election_id)[0]; $election_name .= $row['election_name']; $_SESSION['election_name'] = $election_name; $election_details_test .= "<label>Start Date:</label> " . dateString($row['election_start_date']) . "<br>\n <label>Start Time:</label> " . timeString($row['election_time_from']) . "<br><label>End Date:</label>  " . dateString($row['election_end_date']) . "<br><label>End Time:</label> " . timeString($row['election_time_to']) . "<br>\n <label>Number of Voters: </label> " . count(getAllMembers("joined", ['election_id'], ['election_id', '=', $election_id])) . "<br><label>Number of Contestants: </label> " . count(getAllMembers("contestants", ['contestant_id'], ['election_id', '=', $election_id])); //getting the user_id for a particular election $election_admin_details = $election_admin_detail = ""; $images_dir = "../images/users/"; $user_id_result = $row["user_id"]; //querying to get the admin email $row = getAllMembers("users", ["*"], ["user_id", "=", $user_id_result])[0];
function getEndTime($startDateTime, $p_files) { foreach ($p_files as $file) { $startDateTime->add(getDateInterval($file['length'])); } return $startDateTime; }