<?php
require_once '../database_access.php';
//use session on this page
if (!isset($_SESSION)) {
session_start();
}
if (isset($_GET["event_id"])) {
$event_id = $_GET["event_id"];
} else {
echo '<p class="error_message">Need an event ID</p>';
}
//get event from event id
$q = new EventQuery();
$event = $q->findPk($event_id);
//get interests
$interests = EventInterestQuery::create()->find();
//check if current user is interested in this event
$interested = FALSE;
foreach ($interests as $interest) {
if ($interest->getInterestedUserID() == $_SESSION['uid']) {
$interested = TRUE;
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<?php
include_once '../basic_includes/sheets_and_scripts.php';
?>
<?php
require_once 'database_access.php';
$q = new EventQuery();
$events = $q->orderByStartTime()->find();
?>
<!DOCTYPE html>
<html>
<head>
<?php
include_once 'basic_includes/sheets_and_scripts.php';
?>
<title>RPI Wanna Hangout</title>
</head>
<body>
<div id="index">
<?php
include 'basic_includes/navbar.php';
?>
<div class="jumbotron jBack">
<div class="container">
<h1>Let's Hangout!</h1>
<p>Easily find and share events occuring on or off campus. Connect with your classmates.</p>
<p>Live. Learn. Experience.</p>
<div class="btn-group" role="group" aria-label="...">
<a class="btn btn-info" type="button" href="explore.php">Learn More</a>
<a class="btn btn-info" type="button" href="events/create.php">Create an Event</a>
</div>
</div>
<?php
require_once '../database_access.php';
$ei = new EventInterestQuery();
if (isset($_GET['event_id'])) {
$event = EventQuery::create()->findPk($_GET['event_id']);
if ($event) {
$ei->filterByTarget_Event($event);
} else {
// TODO: throw error instead of blank page
echo "<p>tried to filter by nonexistent event</p>";
}
}
$ei->join('EventInterest.Interested');
$ei->withColumn('Interested.FirstName', 'authorFirstName');
$ei->withColumn('Interested.LastName', 'authorLastName');
echo $ei->find()->toJson();
