halaman.php

<?php
session_start();

//cek apakah user udah login
if (!isset($_SESSION['username'])) {
	header("location:login.php");
}
//cek level admin
if ($_SESSION['level'] != "admin") {
	die("ANDA BUKAN USER");
}

?>
<h3>Selamat Datang <?php echo $_SESSION['username']; ?></h3>



<a href="login_m.php?op=out">Logout</a>


<a href="post.php">Post Berita</a>
<hr>
<form action="halaman.php" method="GET">
	<input type="text" name="s">
	<input type="submit" value="CARI" name="cari">

</form>
<hr>
<?php
error_reporting(E_ALL ^ (E_NOTICE));
$batas = 5;
$halaman = $_GET['halaman'];

if (empty($halaman)) {
	$posisi = 0;
	$halaman = 1;
}else{
	$posisi = ($halaman - 1) * $batas;
}

//koneksi ke database
$konek = mysqli_connect("localhost", "root", "", "berita");

if (isset($_GET['cari'])) {
	$q = $_GET['s'];
	$tampil = "SELECT * FROM konten WHERE judul LIKE '%$q%' ORDER BY judul LIMIT $posisi, $batas";
}else{
	//query menampilkan data
	$tampil = "SELECT * FROM konten LIMIT $posisi, $batas";
}


$hasil = mysqli_query($konek,$tampil);

$jmlhasil = mysqli_num_rows($hasil);

?>

<?php

if ($jmlhasil < 1) {

	echo "<td colspan='5'>data yang ada cari tidak ada</td>";

}else{
	//penomoran
	$no = $posisi + 1;

	//tampil nama, email dan pesan
	while($data=mysqli_fetch_array($hasil)){
		echo "judul : $data[judul]<br>";
		echo "isi : $data[isi]<br>";
		echo "<img src='img/$data[photo]' width='100px'><br>";
		echo "<a href='hapus_b.php?id=$data[id]'>hapus</a> | 
				<a href='edit_b.php?id=$data[id]'>edit</a>|
				<a href='berita_a.php?id=$data[id]'>detail</a><hr>";
		
		$no++;

	}

}


?>


<?php
//untuk pagging
$tampil2 = "SELECT * FROM konten";
$hasil2 = mysqli_query($konek, $tampil2);
$jmldata = mysqli_num_rows($hasil2);
$jmlhalaman = ceil($jmldata / $batas);

echo " jumlah data : $jmldata <br>";

for ($i=1; $i <= $jmlhalaman; $i++) { 
	if ($i != $halaman) {
		echo "<a href=$_SERVER[PHP_SELF]?halaman=$i> $i </a>";
	}else{
		echo " <b> $i </b>";
	}
}

?>