| Server IP : 2.57.91.155 / Your IP : 216.73.217.80 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/berita/webadmin/ |
Upload File : |
<?php include 'header.php'; ?>
<?php
$limit = 5;
if(isset($_GET['p']))
{
$noPage = $_GET['p'];
}
else $noPage = 1;
$offset = ($noPage - 1) * $limit;
$sql = "SELECT
berita.id_berita,
berita.judul,
admin.id_admin,
berita.gambar,
berita.tgl_posting,
admin.nama_lengkap,
kategori.kategori
FROM
berita
INNER JOIN admin ON berita.id_admin = admin.id_admin
INNER JOIN kategori ON kategori.id_kategori = berita.id_kategori
ORDER BY berita.tgl_posting DESC
LIMIT ".$offset.",". $limit;
$qry = $mysqli->query($sql);
$sql_rec = "SELECT id_berita FROM berita";
$total_rec = $mysqli->query($sql_rec);
$total_rec_num = $total_rec->num_rows;
$total_page = ceil($total_rec_num/$limit);
?>
<div class="container-fluid body">
<div class="row">
<div class="col-lg-2 sidebar">
<?php include 'sidebar.php'; ?>
</div>
<div class="col-lg-10 main-content">
<div class="panel panel-default">
<div class="panel-body">
<div class="row">
<div class="col-md-12">
<h2 class="page-header"><i class="fa fa-newspaper-o"></i> Berita</h2>
</div>
</div>
<div class="row">
<div class="col-md-12">
<a href="tambah-berita.php" class="btn btn-sm btn-primary">
<i class="fa fa-plus-circle"></i> Tambah Berita
</a>
<div class="clear"></div>
<table class="table table-hover">
<thead>
<tr>
<th width="30%">Judul</th>
<th width="5%">Gambar</th>
<th width="20%">Kategori</th>
<th width="15%">Tgl. Posting</th>
<th width="15%">Penulis</th>
<th width="15%">Pilihan</th>
</tr>
</thead>
<tbody>
<?php while ($news_list = $qry->fetch_assoc()) { ?>
<tr>
<td><strong><?php echo $news_list['judul']; ?></strong></td>
<td>
<img src="../images/<?php echo $news_list['gambar']; ?>" height="75" width="75">
</td>
<td><?php echo $news_list['kategori']; ?></td>
<td><?php echo $news_list['tgl_posting']; ?></td>
<td><?php echo $news_list['nama_lengkap']; ?></td>
<td align="center">
<?php if ($news_list['id_admin'] == $_SESSION['id_admin'] or $_SESSION['level']=='admin') { ?>
<a class="btn btn-sm btn-primary" target="_blank" href="<?php echo $base_url.'detail.php?id='.$news_list['id_berita']; ?>">
<i class="fa fa-eye"></i>
</a>
<a href="edit-berita.php?id=<?=$news_list['id_berita']?>" class="btn btn-sm btn-success">
<i class="fa fa-edit"></i>
</a>
<a onclick="return confirm('Anda Yakin Ingin Menghapus Data Ini?');" href="hapus-berita.php?id=<?=$news_list['id_berita']?>" class="btn btn-sm btn-danger">
<i class="fa fa-trash"></i>
</a>
<?php } else { ?>
<a class="btn btn-sm btn-primary" target="_blank" href="<?php echo $base_url.'detail.php?id='.$news_list['id_berita']; ?>">
<i class="fa fa-eye"></i>
</a>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<div class="col-md-12">
<ul class="pagination">
<?php if ($noPage > 1) { ?>
<li>
<a href="<?php echo "berita.php?p=".($noPage-1);?>">
<i class="glyphicon glyphicon-chevron-left"></i>
</a>
</li>
<?php } ?>
<?php for ($page=1; $page <= $total_page ; $page++) { ?>
<?php if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $total_page)) { ?>
<?php
$showPage = $page;
if ($page==$total_page && $noPage <= $total_page-5) echo "<li class='active'><a>...</a></li>";
if ($page == $noPage) echo "<li class='active'><a href='#'>".$page."</a></li> ";
else echo " <li><a href='".$_SERVER['PHP_SELF']."?p=".$page."'>".$page."</a></li> ";
if ($page == 1 && $noPage >=6) echo "<li class='active'><a>...</a></li>";
?>
<?php } ?>
<?php } ?>
<?php if ($noPage < $total_page) { ?>
<li>
<a href="<?php echo "berita.php?p=".($noPage+1); ?>">
<i class="glyphicon glyphicon-chevron-right"></i>
</a>
</li>
<?php } ?>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>