<select name="selectedtrips" id="selectedtrips"> <option value="latest">Latest Trips</option> <option value="favorite">Favorite Trips</option> </select> <div class="content-wrapper-content big-block type-3" id="postList"> <?php if (isset($_POST["newTrip"])) { $result = searchNewestTripPost($_POST["newTrip"]); } else { if (isset($_POST["favoriteTrip"])) { $result = searchFavoritedTripPost($_POST["favoriteTrip"]); } else { if (isset($_POST["keyword"])) { $result = searchTripPostByKeyword($_POST["keyword"]); } else { $result = getAllTrips(); } } } foreach ($result as $trip) { ?> <div id="<?php echo "trip_" . $trip["trip_id"]; ?> " class="row"> <div class="col-md-8 col-md-push-2"> <div class="simple-article-block"> <div class="article-title"> <div class="row"> <span class="date pull-left"><?php echo $trip["username"];
<?php session_start(); require_once "ldap.php"; require_once "userhelper.php"; function getAllTrips() { if (!isLoggedIn()) { $response = array("status" => 1, "error" => "Invalid session"); echo json_encode($response); return; } include "config.php"; $query = "SELECT * FROM " . $db_mysql_table_name . " WHERE userid='" . getUid() . "' ORDER BY id DESC"; $success = mysqli_query($link, $query); if ($success) { $rows = array(); while ($row = mysqli_fetch_assoc($success)) { $rows[] = $row; } $response = array("status" => 0, "data" => $rows); echo json_encode($response); } else { $response = array("status" => 1, "error" => "Unable to run select in DB"); echo json_encode($response); } } getAllTrips();