$query = "select hak_akses from profile where nik='".$_SESSION['username']."'"; $hasil = mysqli_query($koneksi, $query) or die("Kesalahan pada query!"); list($hak_akses) = mysqli_fetch_row($hasil); if (strtoupper($hak_akses)=="ADMIN"){ ?>
List Data User
Cari Nik/Nama :
No
Username/NIK
Nama
Hak Akses
if (isset($_POST['submit'])) { } else { require("connect.inc.php"); // tambahan if (!$_POST['cari']) $_POST['cari']=$_GET['cari']; $query = "select nik,nama,hak_akses from profile where nik like '%".$_POST['cari']."%' or nama like '%".$_POST['cari']."%'" ; //echo $query; $hasil = mysqli_query($koneksi, $query) or die("Kesalahan pada query!"); $no=1; while (list($nik,$nama,$hak_akses) = mysqli_fetch_row($hasil)) { if ($no % 2==0){ $warna="#D4D4D4"; } else { $warna="#E8E6F7"; } ?>
$no++; } mysqli_free_result($hasil); } } else { echo "Maaf anda bukan Admin"; } ?>