function displayResults($a) { //Make all rows clickable //Runs through the search results and displays them echo "<h6 header col s12 light>Distance from " . getLocation()['zipCode'] . "  <a href='postcode.php'>Not your location?</a></h6>"; //Make th elements clickable for sorting echo " <br><br><div id='pager1' class='pager'>\n <form>\n <div class='row'>\n <div class='col s2'>Results Per Page:</div>\n <div class='col s2'>\n <select class=\"pagesize\">\n <option selected=\"selected\" \n value=\"10\">10</option>\n <option value=\"20\">20</option>\n <option value=\"30\">30</option>\n <option value=\"40\">40</option>\n </select>\n </div>\n\t \t</div>\n <img src=\"img/ic_chevron_left_grey600_18dp.png\" \n class=\"first\"/>\n <img src=\"img/ic_arrow_back_grey600_18dp.png\" \n class=\"prev\"/\n <input type=\"text\" class=\"pagedisplay\"/>\n <img src=\"img/ic_arrow_forward_grey600_18dp.png\" \n class=\"next\"/>\n <img src=\"img/ic_chevron_right_grey600_18dp.png\" \n class=\"last\"/>\n\n </form>\n </div>\n <table class='tablesorter hoverable striped ' id='searchResults'>\n <thead>\n <tr>\n <th data-field='name'>Title</th>\n <th data-field='sdate' >Start Date</th>\n <th data-field='edate'>End Date</th>\n <th data-field='loc'>Location</th> \n <th data-field='dist'>Distance</th>\n <th data-field='going'>Add/Remove</th>"; echo "</tr>\n </thead>\n\n <tbody id=\"searchResultsBody\">"; //Run through all results and format them in the table foreach ($a as $row) { echo "<tr>"; echo "<td><a href=event.php?id=" . $row['id'] . ">" . $row['name'] . "</td>"; echo "<td>" . date("d M y", $row['startDate']) . "</td>"; echo "<td>" . date("d M y", $row["endDate"]) . "</td>"; echo "<td>" . $row['location'] . "</td>"; if (isset($row[0])) { echo "<td>" . $row[0] . "</td>"; } else { echo '<td></td>'; } echo "<td>"; if (!goingToEvent($row['id'])) { if (!isset($_SESSION['id'])) { echo "<form method='post' action='chooselogin.php'><input name='id' type='hidden' value='" . $row['id'] . "'>\n <button type='submit' action='userAddEvent.php' class='btn waves-effect waves-light'><i class='mdi-social-person-add'></button>"; } else { echo "<form method='post' action='userAddEvent.php'><input name='id' type='hidden' value='" . $row['id'] . "'>\n <button type='submit' action='userAddEvent.php' class='btn waves-effect waves-light'><i class='mdi-content-add'></button>"; } } else { echo "<form method='post' action='userRmEvent.php'><input name='id' type='hidden' value='" . $row['id'] . "'>\n <button type='submit' action='userRmEvent.php' class='btn waves-effect waves-light'><i class='mdi-content-remove'></button>"; } echo "</form></td>"; echo "</tr></a>"; } echo "</tbody>\n </table>\n <div id='pager' class='pager'>\n <form>\n\n\t\t<img src=\"img/ic_chevron_left_grey600_18dp.png\" class=\"first\"/>\n\t\t<img src=\"img/ic_arrow_back_grey600_18dp.png\" class=\"prev\"/\n\t\t<input type=\"text\" class=\"pagedisplay\"/>\n\t\t<img src=\"img/ic_arrow_forward_grey600_18dp.png\" class=\"next\"/>\n\t\t<img src=\"img/ic_chevron_right_grey600_18dp.png\" class=\"last\"/>\n\t\t<select class=\"pagesize\">\n\t\t\t<option selected=\"selected\" value=\"10\">10</option>\n\t\t\t<option value=\"20\">20</option>\n\t\t\t<option value=\"30\">30</option>\n\t\t\t<option value=\"40\">40</option>\n\t\t</select>\n\t</form>\n </div>\n </div>"; }
require "style/header.php"; echo '<div id="content">'; require "database.php"; //Get variables $con = connect(); $stmt = $con->prepare("SELECT * FROM Events WHERE `Id`=?"); $stmt->bind_param('i', $_GET["id"]); $stmt->execute(); $stmt->bind_result($id, $title, $location, $sdate, $edate, $desc, $postcode, $createdBy); $stmt->fetch(); $sdate = date("d M y", $sdate); $edate = date("d M y", $edate); echo "<br>"; echo '<div class="row"> <div class="container">'; if (!goingToEvent($_GET['id'])) { echo "<form method='post' action='userAddEvent.php'>\n <input name='id' type='hidden' value='" . $_GET['id'] . "'>\n <button type='submit' action='userAddEvent.php' class='right btn waves-effect waves-light'><i class='mdi-content-add'></i>I'm going!</button>"; } else { echo "<form method='post' action='userRmEvent.php'><input name='id' type='hidden' value='" . $_GET['id'] . "'>\n <button type='submit' action='userRmEvent.php' class='right btn waves-effect waves-light'><i class='mdi-content-remove'></i>\n I'm not going any more</button>"; } echo "</form>"; echo '</div> </div>'; echo '<div id="index-banner" class="parallax-container"> <div class="section no-pad-bot"> <div class="container"> <br><br> <h1 class="header center blue-text">' . $title . '</h1> <div class="row center"> <h5 id="evdate" class="header col s12 light">'; if ($sdate != $edate) {