$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/>');

}