Ejemplo n.º 1
0
function outputPostRows($dbAdapter)
{
    $gateTravelPost = new TravelPostTableGateway($dbAdapter);
    $gateTravelImage = new TravelImageTableGateway($dbAdapter);
    $gateTravelUserDetails = new TravelUserDetailsTableGateway($dbAdapter);
    $gateTravelPostImage = new TravelPostImagesTableGateway($dbAdapter);
    $result = $gateTravelPost->findAll();
    foreach ($result as $row) {
        $postId = $row->PostID;
        $userId = $row->UID;
        $imageId = $gateTravelPostImage->findById($postId)->ImageID;
        $thumb = $gateTravelImage->findById($imageId)->Path;
        $title = $row->Title;
        $firstName = $gateTravelUserDetails->findById($userId)->FirstName;
        $lastName = $gateTravelUserDetails->findById($userId)->LastName;
        $userName = utf8_encode($firstName . $lastName);
        $excerpt = substr($row->Message, 0, 200) . "...";
        $date = substr($row->PostTime, 0, 10);
        echo utf8_encode('<div class="row">
		               <div class="col-md-2">
								<a href="single-image.php?id=' . $imageId . '" class="">
								<img src="travel-images/square-medium/' . $thumb . '" alt="' . $title . '" class="img-thumbnail"/>
								</a>
		               </div>
		              <div class="col-md-10">
		                  <h2>' . $title . '</h2>
		                  <div class="details">
		                    Posted by <a href="single-user.php?id=' . $userId . '" class="">' . $userName . '</a>
		                    <span class="pull-right">' . $date . '</span>
		                  </div>
		                  <p class="excerpt">' . $excerpt . '</p>
						  <p><a href="single-post.php?id=' . $postId . '" class="btn btn-primary btn-sm">Read more</a></p>
		               </div>
		           </div>
		           <hr/>');
    }
}
Ejemplo n.º 2
0
if (isset($_GET['favorite_image_id']) && is_numeric($_GET['favorite_image_id']) && $_GET['favorite_image_id'] >= 0) {
    $gateTravelImageDetails = new TravelImageDetailsTableGateway($dbAdapter);
    $gateTravelImage = new TravelImageTableGateway($dbAdapter);
    $imageID = $_GET['favorite_image_id'];
    $path = $gateTravelImage->findById($imageID)->Path;
    $title = $gateTravelImageDetails->findById($imageID)->Title;
    $favoriteImage = new FavoriteImage(FavoriteImage::getFieldNames(), false);
    $favoriteImage->imageID = $imageID;
    $favoriteImage->path = $path;
    $favoriteImage->title = $title;
    $favoriteImageList[] = $favoriteImage;
    $_SESSION['favoriteImageList'] = $favoriteImageList;
    header('Location: single-image.php?id=' . $_GET['favorite_image_id']);
} elseif (isset($_GET['favorite_post_id']) && is_numeric($_GET['favorite_post_id']) && $_GET['favorite_post_id'] >= 0) {
    $gateTravelPost = new TravelPostTableGateway($dbAdapter);
    $gateTravelPostImage = new TravelPostImagesTableGateway($dbAdapter);
    $gateTravelImage = new TravelImageTableGateway($dbAdapter);
    $postID = $_GET['favorite_post_id'];
    $imageID = $gateTravelPostImage->findById($postID)->ImageID;
    $path = $gateTravelImage->findById($imageID)->Path;
    $title = $gateTravelPost->findById($postID)->Title;
    $favoritePost = new FavoritePost(FavoritePost::getFieldNames(), false);
    $favoritePost->postID = $postID;
    $favoritePost->path = $path;
    $favoritePost->title = $title;
    $favoritePostList[] = $favoritePost;
    $_SESSION['favoritePostList'] = $favoritePostList;
    header('Location: single-post.php?id=' . $_GET['favorite_post_id']);
} else {
    header("Location: error.php");
    die;