<?php include('atas.php'); ?>
<!-- INI BATASNYA DATA AWAL -->
<?php if(isset($_GET['data'])){ ?>
<br />
<a href="?tambah";>
	<button type="button" class="btn btn-default">
		<span class="glyphicon glyphicon-plus"></span> Tambah Data
	</button>
</a>
<br /><br />
<table  class="table table-striped table-bordered table-hover" id="example">
	<thead>
		<tr align="center">
			<td>No</td>
			<td>Nama</td>
			<td>Alamat</td>
			<td>Action</td>
			<td>No</td>
			<td>Nama</td>
			<td>Alamat</td>
			<td>Action</td>
			<td>No</td>
			<td>Nama</td>
			<td>Alamat</td>
			<td>Action</td>
			<td>No</td>
			<td>Nama</td>
			<td>Alamat</td>
			<td>Action</td>
			<td>No</td>
			<td>Nama</td>
			<td>Alamat</td>
			<td>Action</td>
		</tr>
	</thead>
	<tbody>
<?php
	$sql="select * from kategori order by id desc"; //'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
	$rs=mysql_query($sql);
	$no=1;
	while($row=mysql_fetch_array($rs)){
?>
<tr>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['1']; ?></td>
	<td align="center"><?php echo $row['2']; ?></td>
	<td align="center"><?php echo $no; ?></td>

<!-- edit dan hapus ini jangan di rubah, biar enak, usahakan setiap nama id pakai id saja, jangan ada embel2 lain -->
	<td>
		<a href="?edit&id=<?php echo $row['0']; ?>" class="btn btn-success"><span class="glyphicon glyphicon-edit"></span> Edit</a>
		<a href="?hapus&id=<?php echo $row['0']; ?>" onclick="return confirm('Yakin Mau Hapus?');" class="btn btn-danger"><span class="glyphicon glyphicon-trash"></span> Hapus</a>
	</td>
<!-- INI BATASNYA -->
</tr>
<?php $no++; } ?>
	</tbody>
</table>
<?php } ?>
<!-- INI BATASNYA DATANYA -->

<!-- INI KALAU MAU HAPUS -->
<?php
	if(isset($_GET['hapus'])){
		$id=$_GET['id'];
		$sql="delete from kategori where id='$id'"; //'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
		mysql_query($sql);
		echo '<script type="text/javascript">
			//<![CDATA[
			window.location="?data"
			//]]>
		</script>';
	}
?>

<!-- INI BATASNYA HAPUS -->

<!-- INI KALAU MAU EDIT -->
<?php if(isset($_GET['edit'])){ ?>
<?php
$sql="select * from kategori where id='$_GET[id]'";//'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
$rs=mysql_query($sql);
$row=mysql_fetch_array($rs);
 { ?>
<form action="" method="post" class="niceform" enctype="multipart/form-data">
<table class="table table-hover">
	<tr class="info">
		<td colspan="2" >Edit Data</td>
	</tr>
	<tr>
			<td>Nama</td>
			<td><input type="text" name="nama" size="54" value="<?php echo $row['1'];?>" required class="form-control"/></td>
	</tr>
	<tr>
			<td>Alamat</td>
			<td><input type="text" name="alamat" size="54" value="<?php echo $row['2'];?>" required class="form-control"/></td>
	</tr>
	<tr>
			<td>&nbsp;</td>
			<td><input type="submit" name="submit" value="EDIT" class="btn btn-primary"/></td>
	</tr>
</table>
</form>
<?php	} if(isset($_POST['submit'])){
		$id=$_GET['id'];
		$nama=$_POST['nama'];
		$alamat=$_POST['alamat'];
		$sql="update kategori set nama='$nama', alamat='$alamat' where id='$id'";//'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
	if(mysql_query($sql)){
	echo '<script type="text/javascript">
		//<![CDATA[
		alert ("Berhasil Edit");
		window.location="?data";
		//]]>
	</script>';
	} else {
	echo '<script type="text/javascript">
		//<![CDATA[
		alert ("Gagal Simpan");
		window.location="?data";
		//]]>
	</script>';}
		}
 ?>

<!-- INI BATASNYA EDIT -->

<!-- INI KALAU MAU NAMBAH -->

<?php } ?>

<?php if(isset($_GET['tambah'])){ ?>
<form action="" method="post" class="niceform" enctype="multipart/form-data">
<table class="table table-hover">
	<tr class="info">
		<td colspan="2" >New Data</td>
	</tr>
		<tr>
			<td>Nama</td>
			<td><input type="text" name="nama" class="form-control" size="54" required/></td>
		</tr>
		<tr>
			<td>Alamat</td>
			<td><input type="text" name="alamat" class="form-control" size="54" required/></td>
		</tr>
		<tr>
			<td>&nbsp;</td>
			<td><input type="submit" name="submit" value="SIMPAN" class="btn btn-primary"/></td>
		</tr>
	</table>
</form>
<?php
if(isset($_POST['submit'])){
		$nama=$_POST['nama'];
		$alamat=$_POST['alamat'];
	$sql="insert into kategori VALUES ('','$nama','$alamat')";//'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
	if(mysql_query($sql)){
	echo '<script type="text/javascript">
		//<![CDATA[
		alert ("Berhasil Simpan");
		window.location="?data";
		//]]>
	</script>';
	} else {
	echo '<script type="text/javascript">
		//<![CDATA[
		alert ("Gagal Simpan");
		window.location="?data";
		//]]>
	</script>';}
		}
?>
<?php } ?>

<!-- INI BATASNYA NAMBAH -->

<!-- INCLUDE ATAS.PHP DAN BAWAH.PHP JANGAN PERNAH DI HAPUS MESKIPUN BUAT BARU INGAT2 TING -->
<?php include('bawah.php'); ?>