LOADING . . .
Pada posting kali ini saya akan membuat Halaman Blog (untuk menampilkan post loop) dan Single Post (detail dari artikel), bagi yang baru mengikuti seri Membuat Website Professional dengan PHP & MySql silahkan lihat beberapa artikel dibawah ini:
#1 Membuat Halaman Blog
<?php include "header.php"; ?>
<!-- bradcam_area_start -->
<div class="bradcam_area breadcam_bg bradcam_overlay">
<div class="container">
<div class="row">
<div class="col-xl-12">
<div class="bradcam_text">
<h3>Blog</h3>
<p><a href="<?php echo $base_url;?>">Home /</a> Blog</p>
</div>
</div>
</div>
</div>
</div>
<!-- bradcam_area_end -->
<!--================Blog Area =================-->
<section class="blog_area section-padding">
<div class="container">
<div class="row">
<div class="col-lg-8 mb-5 mb-lg-0">
<div class="blog_left_sidebar">
<?php
$halaman = 2;
$page = isset($_GET["halaman"]) ? (int)$_GET["halaman"] : 1;
$mulai = ($page>1) ? ($page * $halaman) - $halaman : 0;
$result = mysqli_query($koneksi,"SELECT * FROM post WHERE status='1'");
$total = mysqli_num_rows($result);
$pages = ceil($total/$halaman);
$query = mysqli_query($koneksi,"select * from post LIMIT $mulai, $halaman");
$no =$mulai+1;
while ($row = mysqli_fetch_assoc($query)) { ?>
<article class="blog_item">
<div class="blog_item_img">
<img class="card-img rounded-0" src="<?php echo $base_url; ?>admin/<?php echo $row['gambar_utama']?>" alt="">
<a href="#" class="blog_item_date">
<?php $tanggal = $row['publish_date'];?>
<?php $pecah = explode("/", $tanggal); ?>
<h3><?php echo $pecah[0] ?></h3>
<p><?php echo $pecah[1] ?></p>
</a>
</div>
<?php $slug = preg_replace('~[^\pL\d]+~u', '-', $row['judul']);?>
<div class="blog_details">
<a class="d-inline-block" href="<?php echo $base_url;?>post/<?php echo $row['id']?>/<?php echo strtolower($slug);?>">
<h2><?php echo $row['judul']?></h2>
</a>
<?php echo substr($row['content'], 0, 200) .((strlen($row['content']) > 200) ? '...' : '');?>
<?php $sqlkat = mysqli_query($koneksi, "SELECT * FROM kategori WHERE id='".$row['id_kategori']."'");?>
<ul class="blog-info-link">
<?php $rowkat = mysqli_fetch_array($sqlkat);?>
<li><a href="<?php echo $base_url; ?>kategori/<?php echo $rowkat['id']?>"><i class="fa fa-user"></i> <?php echo $rowkat['judul']?></a></li>
</ul>
</div>
</article>
<?php } ?>
<nav class="blog-pagination justify-content-center d-flex">
<ul class="pagination">
<?php for ($i=1; $i<=$pages ; $i++){ ?>
<li class="page-item"><a href="?halaman=<?php echo $i; ?>" class="page-link"><?php echo $i; ?></a></li>
<?php } ?>
</ul>
</nav>
</div>
</div>
<?php include ('blog-sidebar.php');?>
</div>
</section>
<!--================Blog Area =================-->
<?php include "footer.php";?>
$halaman = 2;
<ul class="pagination">
<?php for ($i=1; $i<=$pages ; $i++){ ?>
<li class="page-item"><a href="?halaman=<?php echo $i; ?>" class="page-link"><?php echo $i; ?></a></li>
<?php } ?>
</ul>
<?php $slug = preg_replace('~[^\pL\d]+~u', '-', $row['judul']);?>
<a class="d-inline-block" href="<?php echo $base_url;?>post/<?php echo $row['id']?>/<?php echo strtolower($slug);?>">
<h2><?php echo $row['judul']?></h2>
</a>
#2 Membuat Sidebar
<div class="col-lg-4">
<div class="blog_right_sidebar">
<aside class="single_sidebar_widget search_widget">
<form action="<?php echo $base_url; ?>search" method="get">
<div class="form-group">
<div class="input-group mb-3">
<input type="text" name="cari" class="form-control" placeholder='Search Keyword'
onfocus="this.placeholder = ''"
onblur="this.placeholder = 'Search Keyword'">
<div class="input-group-append">
<button class="btn" type="button"><i class="ti-search"></i></button>
</div>
</div>
</div>
<button class="button rounded-0 primary-bg text-white w-100 btn_1 boxed-btn"
type="submit">Search</button>
</form>
</aside>
<aside class="single_sidebar_widget post_category_widget">
<h4 class="widget_title">Category</h4>
<ul class="list cat-list">
<?php $sqlkc = mysqli_query($koneksi, "select * from kategori WHERE status='1' ORDER BY id DESC");
while($rowkc = mysqli_fetch_array($sqlkc)){
?>
<li>
<a href="<?php echo $base_url;?>kategori/<?php echo $rowkc['id']?>" class="d-flex">
<p><?php echo $rowkc['judul']?></p>
<?php $sqlkcount = mysqli_query($koneksi, "select COUNT(judul) as count from post WHERE id_kategori='".$rowkc['id']."' ORDER BY id DESC");
while($rowkcount = mysqli_fetch_array($sqlkcount)){ ?>
<p>(<?php echo $rowkcount['count'];?>)</p>
<?php } ?>
</a>
</li>
<?php } ?>
</ul>
</aside>
<aside class="single_sidebar_widget popular_post_widget">
<h3 class="widget_title">Recent Post</h3>
<?php $sqlrp = mysqli_query($koneksi, "select * from post WHERE status='1' ORDER BY id DESC LIMIT 5");
while($rowrp = mysqli_fetch_array($sqlrp)){
?>
<div class="media post_item">
<img style="max-width:100px;" src="<?php echo $base_url;?>admin/<?php echo $rowrp['gambar_utama']?>" alt="post">
<div class="media-body">
<?php $slug = preg_replace('~[^\pL\d]+~u', '-', $rowrp['judul']);?>
<a href="<?php echo $base_url;?>post/<?php echo $rowrp['id']?>/<?php echo strtolower($slug);?>">
<h3><?php echo $rowrp['judul']?></h3>
</a>
<p><?php echo $rowrp['publish_date']?></p>
</div>
</div>
<?php } ?>
</aside>
</div>
</div>
</div>
<aside class="single_sidebar_widget search_widget">
<form action="<?php echo $base_url; ?>search" method="get">
<div class="form-group">
<div class="input-group mb-3">
<input type="text" name="cari" class="form-control" placeholder='Search Keyword'
onfocus="this.placeholder = ''"
onblur="this.placeholder = 'Search Keyword'">
<div class="input-group-append">
<button class="btn" type="button"><i class="ti-search"></i></button>
</div>
</div>
</div>
<button class="button rounded-0 primary-bg text-white w-100 btn_1 boxed-btn"
type="submit">Search</button>
</form>
</aside>
<form action="<?php echo $base_url; ?>search" method="get">
<aside class="single_sidebar_widget post_category_widget">
<h4 class="widget_title">Category</h4>
<ul class="list cat-list">
<?php $sqlkc = mysqli_query($koneksi, "select * from kategori WHERE status='1' ORDER BY id DESC");
while($rowkc = mysqli_fetch_array($sqlkc)){
?>
<li>
<a href="<?php echo $base_url;?>kategori/<?php echo $rowkc['id']?>" class="d-flex">
<p><?php echo $rowkc['judul']?></p>
<?php $sqlkcount = mysqli_query($koneksi, "select COUNT(judul) as count from post WHERE id_kategori='".$rowkc['id']."' ORDER BY id DESC");
while($rowkcount = mysqli_fetch_array($sqlkcount)){ ?>
<p>(<?php echo $rowkcount['count'];?>)</p>
<?php } ?>
</a>
</li>
<?php } ?>
</ul>
</aside>
<aside class="single_sidebar_widget popular_post_widget">
<h3 class="widget_title">Recent Post</h3>
<?php $sqlrp = mysqli_query($koneksi, "select * from post WHERE status='1' ORDER BY id DESC LIMIT 5");
while($rowrp = mysqli_fetch_array($sqlrp)){
?>
<div class="media post_item">
<img style="max-width:100px;" src="<?php echo $base_url;?>admin/<?php echo $rowrp['gambar_utama']?>" alt="post">
<div class="media-body">
<?php $slug = preg_replace('~[^\pL\d]+~u', '-', $rowrp['judul']);?>
<a href="<?php echo $base_url;?>post/<?php echo $rowrp['id']?>/<?php echo strtolower($slug);?>">
<h3><?php echo $rowrp['judul']?></h3>
</a>
<p><?php echo $rowrp['publish_date']?></p>
</div>
</div>
<?php } ?>
</aside>
ORDER BY id DESC LIMIT 5
#3 Membuat Halaman Single Post (Artikel)
RewriteRule ^post/(\d+)/([A-Za-z]+) ./post.php?id=$1&$url=$2
<?php include "header.php"; ?>
<!-- bradcam_area_start -->
<?php $id=$_GET['id'];?>
<?php $sql = mysqli_query($koneksi, "select * from post where id='$id'");?>
<?php while ($row=mysqli_fetch_array($sql)){ ?>
<div class="bradcam_area breadcam_bg bradcam_overlay">
<div class="container">
<div class="row">
<div class="col-xl-12">
<div class="bradcam_text">
<h3><?php echo $row['judul']?></h3>
<p><a href="blog.php">Blog /</a> <?php echo $row['judul']?></p>
</div>
</div>
</div>
</div>
</div>
<!-- bradcam_area_end -->
<!-- welcome_docmed_area_start -->
<div class="welcome_docmed_area">
<div class="container">
<div class="row">
<?php echo $row['content']?>
</div>
</div>
</div>
<!-- welcome_docmed_area_end -->
<?php } ?>
<?php include "footer.php"; ?>
<?php $id=$_GET['id'];?>
<?php $sql = mysqli_query($koneksi, "select * from post where id='$id'");?>
Sekian dulu posting Membuat Website Professional dengan PHP MySql - PART #11 : Halaman Blog & Single Post,silahkan download file untuk tutorial "download disini". Sampai bertemu lagi di posting selanjutnya, Stay Save & Healthy.