예제 #1
0
                <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"];
예제 #2
0
<?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();