user.php

<?php include('../header_footer/atas.php'); ?>
<!-- INI BATASNYA DATA AWAL -->
<?php if(isset($_GET['data'])){ ?>
<br />

<script src="js/datatable.js"></script>
<script src="js/dataTables.bootstrap.js"></script>

<script type="text/javascript">

$(document).ready(function() {
    $('#example').DataTable( {
        "scrollX": true
    } );
} );

</script>

<style type="text/css">
</style>
<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-responsive display nowrap" id="example">
	<thead>
		<tr align="center">
			<td>No</td>
			<td>Id User</td>
			<td>Username</td>
			<td>Fullname</td>
			<td>Password</td>
			<td>Level</td>
			<td>Aksi</td>
		</tr>
	</thead>
	<tbody>
<?php
	include "../config/koneksi.php";
	$sql="select * from user"; //'KATEGORI' adalah nama tabel ubahlah jika nama tabel berbeda
	$no=1;
	$rs=mysql_query($sql);
	while($row=mysql_fetch_array($rs)){
?>
<tr>
	<td align="center"><?php echo $no; ?></td>
	<td align="center"><?php echo $row['id_user']; ?></td>
	<td align="center"><?php echo $row['username']; ?></td>
	<td align="center"><?php echo $row['fullname']; ?></td>
	<td align="center"><?php echo $row['password']; ?></td>
	<td align="center"><?php echo $row['level']; ?></td>
<!-- edit dan hapus ini jangan di rubah, biar enak, usahakan setiap nama id pakai id saja, jangan ada embel2 lain -->
	<td style="text-align: center;">
		<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 user where id_user='$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 user where id_user='$_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>Id User</td>
			<td><input type="text" name="id_user" size="54" value="<?php echo $row['id_user'];?>" required class="form-control"/ readonly></td>
	</tr>
	<tr>
			<td>Username</td>
			<td><input type="text" name="username" size="54" value="<?php echo $row['username'];?>" required class="form-control"/></td>
	</tr>
	<tr>
			<td>Fullname</td>
			<td><input type="text" name="fullname" size="54" value="<?php echo $row['fullname'];?>" required class="form-control"/></td>
	</tr>
	<tr>
			<td>Password</td>
			<td><input type="text" name="password" size="54" value="<?php echo $row['password'];?>" required class="form-control"/></td>
	</tr>
	<tr>
			<td>Level</td>
			<td><input type="text" name="level" size="54" value="<?php echo $row['level'];?>" 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>
  <script>
                $('#example').dataTable();
  </script>
</form>
<?php	} if(isset($_POST['submit'])){
		$id=$_GET['id'];
		$id_user=$_POST['id_user'];
		$username=$_POST['username'];
		$fullname=$_POST['fullname'];
		$password=$_POST['password'];
		$level=$_POST['level'];
		$sql="update user set id_user='$id_user', username='$username', fullname='$fullname', password='$password', level='$level' where id_user='$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>Id User</td>
			<td><input type="text" name="id_user" class="form-control" size="54" readonly placeholder="Otomatis" /></td>
		</tr>
		<tr>
			<td>Username</td>
			<td><input type="text" name="username" class="form-control" size="54" required/></td>
		</tr>
		<tr>
			<td>Fullname</td>
			<td><input type="text" name="fullname" class="form-control" size="54" required/></td>
		</tr>
		<tr>
			<td>Password</td>
			<td><input type="text" name="password" class="form-control" size="54" required/></td>
		</tr>
				<tr>
			<td>Level</td>
			<td><input type="text" name="level" 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'])){
		$id_user=$_POST['id_user'];
		$username=$_POST['username'];
		$fullname=$_POST['fullname'];
		$password=$_POST['password'];
		$level=$_POST['level'];
	$sql="insert into user VALUES ('','$username','$fullname','$password','$level')";//'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('../header_footer/bawah.php'); ?>