Untitled

lihat
<!DOCTYPE html>
<html>
<head>
	<title>Lihat Data-2062</title>
	<link rel="stylesheet" type="text/css" href="css/sidebar.css">
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
	<?php include("config.php");?>
</head>
<body>
	<div id="container">
		<ul class="nav nav-pills nav-stacked sidebar">
			 <li role="presentation"><a href="index.php">Tambah Mahasiswa</a></li>
			 <li role="presentation"><a href="hapusmhs.php">Hapus Mahasiswa</a></li>
			 <li role="presentation" class="active"><a href="lihatdata.php">Lihat Data</a></li>
			 <li role="presentation"><a href="cari.php">Cari</a></li>
			 <li role="presentation"><a href="update.php">Update</a></li>
		</ul>
		<div id="content">
			<form class="form-horizontal" method="post">
				<div class="form-group">
				    <label for="inputEmail3" class="col-sm-2 control-label">NIM</label>
				    <div class="col-sm-10">
				      <select class="form-control" name="data">
						  <option value="mahasiswa">Data Mahasiswa</option>
						  </select>
				    </div>
				</div>
				<div class="form-group">
				    <div class="col-sm-offset-2 col-sm-10">
				      <button type="submit" class="btn btn-success" name="submit">Lihat Data</button>
					</div>
  				</div>
			</form>
			<?php
				if (isset ($_POST['submit'])) {
					$data = $_POST['data'];
					$query = "select * from $data";
					$hasil = mysqli_query($conn,$query);
					$i = 1;
					if ($_POST['data']=="mahasiswa") {
						?>
						<table class ="table">
						<tr>
						<td>NOMOR</td>
						<td>ID MAHASISWA</td>
						<td>NIM</td>
						<td>NAMA </td>
						</tr>
						<?php
					 	foreach ($hasil as $value){
							$id_mhs = $value['id_mhs'];
							$nim = $value['nim'];
							$namamhs = $value['nama_mhs'];
						?>
						<tr>
						<td><?php  echo "$i";?></td>
						<td><?php  echo "$id_mhs";?></td>
						<td><?php  echo "$nim";?></td>
						<td><?php  echo "$namamhs";?></td>
						</tr>
						<?php
						$i++;
						}?>
						</table>
						<?php
					}
				}
			?>
		</div>
	</div>
</body>
</html>
hapus
<!DOCTYPE html>
<html>
<head>
	<title>Hapus Mahasiswa-2062</title>
	<link rel="stylesheet" type="text/css" href="css/sidebar.css">
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
</head>
<body>
	<div id="container">
		<ul class="nav nav-pills nav-stacked sidebar">
			 <li role="presentation"><a href="index.php">Tambah Mahasiswa</a></li>
			 <li role="presentation" class="active"><a href="hapusmhs.php">Hapus Mahasiswa</a></li>
			 <li role="presentation"><a href="lihatdata.php">Lihat Data</a></li>
			 <li role="presentation"><a href="cari.php">Cari</a></li>
			 <li role="presentation"><a href="update.php">Update</a></li>
		</ul>
		<div id="content">
			<form class="form-horizontal" method="post">
				<div class="form-group">
				    <label for="inputEmail3" class="col-sm-2 control-label">NIM</label>
				    <div class="col-sm-10">
				      <input type="text" class="form-control" id="inputEmail3" placeholder="NIM" name="nim">
				    </div>
				</div>
				<div class="form-group">
				    <div class="col-sm-offset-2 col-sm-10">
				      <button type="submit" class="btn btn-success" name="hapus">Hapus Mahasiswa</button>
					</div>
  				</div>
			</form>
			<?php
				include "config.php";
				if (isset ($_POST['hapus'])) {
					$nim = $_POST ['nim'];
					$query = "Delete from mahasiswa where nim ='$nim'";
					$hapus = mysqli_query($conn,$query);
					if ($hapus == true) {
						?>
						<script type="text/javascript">alert('Data berhasil dihapus');</script>
						<?php
					}else {
						?>
						<script type="text/javascript">alert('Data gagal dihapus');</script>
						<?php
					}
				}
			?>
		</div>
	</div>
</body>
</html>
index
<!DOCTYPE html>
<html>
<head>
	<title>Input Mahasiswa-2062</title>
	<link rel="stylesheet" type="text/css" href="css/sidebar.css">
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
</head>
<body>
	<div id="container">
		<ul class="nav nav-pills nav-stacked sidebar">
			 <li role="presentation" class="active"><a href="index.php">Tambah Mahasiswa</a></li>
			 <li role="presentation"><a href="hapusmhs.php">Hapus Mahasiswa</a></li>
			 <li role="presentation"><a href="lihatdata.php">Lihat Data</a></li>
			 <li role="presentation"><a href="cari.php">Cari</a></li>
			 <li role="presentation"><a href="update.php">Update</a></li>
		</ul>
		<div id="content">
			<form class="form-horizontal" method="post">
				<div class="form-group">
				    <label for="inputEmail3" class="col-sm-2 control-label">NIM</label>
				    <div class="col-sm-10">
				      <input type="text" class="form-control" id="inputEmail3" placeholder="NIM" name="nim">
				    </div>
				</div>
				<div class="form-group">
				    <label for="inputEmail3" class="col-sm-2 control-label">Nama</label>
				    <div class="col-sm-10">
				      <input type="text" class="form-control" id="inputEmail3" placeholder="Nama" name="nama">
				    </div>
				</div>
				<div class="form-group">
				    <div class="col-sm-offset-2 col-sm-10">
				      <button type="submit" class="btn btn-success" name="tambah">Tambah</button>
					</div>
  				</div>
			</form>
			<?php
				include "config.php";
				if (isset ($_POST['tambah'])) {
					$nim = $_POST['nim'];
					$nama = $_POST['nama'];
					$query = "insert into mahasiswa (nim,nama_mhs) values ('$nim','$nama')";
					$tambah = mysqli_query($conn,$query);
					if ($tambah==true) {
						?>
						<script type="text/javascript">alert('Data berhasil ditambahkan!');</script>
					<?php
					}else{
					?>
					<script type="text/javascript">alert('Data gagal ditambahkan!');</script>
					<?php
					}
				}
			?>
		</div>
	</div>
</body>
</html>
config
<?php
	$server="localhost";
	$username="root";
	$pass="";
	$dbname="modul5";
	$conn = mysqli_connect($server,$username,$pass,$dbname);
	if (!$conn) {
		die ("Connection failed".mysqli_connect_error());
	}
?>