במ12[aspddfsdfsdfdfnggsd g ggk ffghaskjjsaddddkdasdasd asdaioioidgh;';';'

]][ahhhhhhhfhfasdasoioasdsdkksdadddsddfgh במ12[aspddfsdfsdfdfnggsd g ggk ffghaskjjsaddddkdasdasd asdaioioidgh;';';'

<?php
				include('header.php');
				?>
					<div role="main" class="main">
					<section class="page-header page-header-custom-background" style="background-image: url(img/custom-header-bg.jpg);">
					<div class="container">
						<div class="row">
							<div class="col-md-12">
								<h1><b>Our Blog</b></h1>
							</div>
						</div>
					</div>
				</section>
				<div class="container">
					<div class="row">
						<div class="col-md-12">
							<div class="blog-posts">
							<?php
							include('admin/connection.php');
							$stmt=$con->query("SELECT `id`, `title`, `content`, `small`, `datee`, `name`, `tag`, `isPopular`, `isImage`, `filee`, `tagUrl`, `imageSecond` FROM `blog` ORDER BY `id` desc");
							while($row=$stmt->fetch())
							{
							$blogId=$row['id'];
							$stmt3=$con->query("SELECT count(`id`) as sumId FROM `comment` where `fkBlogId`='$blogId'");
							$row3=$stmt3->fetch();
							$sumCount=$row3['sumId'];
								?>
								<article class="post post-medium">
									<div class="row">
										<div class="col-md-5">
											<div class="post-image">
												<div class="owl-carousel owl-theme" data-plugin-options="{'items':1}">
													<div>
													<div class="embed-responsive embed-responsive-16by9">
													<?php
                                                if($row['isImage']==1)
                                                {
                                                    ?>
                                                    <td>
														<iframe frameborder="0" allowfullscreen="" src="<?php echo $row['filee']; ?>"></iframe>
                                                    <?php
                                                }
                                                else
                                                {
                                                    ?>
												<img class="img-responsive" src="admin/<?php echo $row['filee']; ?>" alt="">				
												<?php
                                                }
                                                ?>
												</div>
												</div>
												</div>
											</div>
										</div>
										<div class="col-md-7">
											<div style="text-align: justify" class="post-content">
											<h4><font color="black"><a href="blog-post.php?link=<?php echo $row['id']; ?>"><?php echo $row['title']; ?></a></font></h4>
												<span align="justify" class="claimedRight" maxlength="400">
												<font color="black">
												<?php
												echo str_replace(array("\n"),array("<br />"),$row['content']);
												?>
												</font>
												</span>
												
												<a href="blog-post.php?link=<?php echo $row['id']; ?>" class="btn btn-xs btn-primary pull-right"> Read more...</a>
												<hr>	
												<div class="post-meta">
													<?php
													$original_date = $row['datee'];
													// Creating timestamp from given date
													$timestamp = strtotime($original_date);
													// Creating new date format from that timestamp
													$new_date = date("d-m-Y", $timestamp);
													?>
												<span><i class="fa fa-calendar"></i><?php echo $new_date; ?> </span>
												<span><i class="fa fa-user"></i> By <a href><?php echo $row['name']; ?></a> </span>
												<span><i class="fa fa-tag"></i> <a href="<?php echo $row['tagUrl']; ?>"><?php echo $row['tag']; ?></a> </span>
												<span><i class="fa fa-comments"></i> <a><?php echo $sumCount; ?> Comments</a></span>
												</div>
											</div>
										</div>
									</div>
								</article>
								<?php
								}
								?>
						</div>
						</div></div>
				</div>
			</div>
<?php
include('footer.php');
?>