<?php
$host	="localhost";
$user 	="root";
$pass	="";
$db		="crud";
$koneksi= mysqli_connect($host,$user,$pass,$db) or die(mysqli_error($koneksi));
?>


<!--Index-->
<?php include "config.php"; ?>
<html>
<head>Simpel</head>
<body>
	<br>
	<br>
	<a href="add.php">add</a>
	<table border="1">
			<thead>
			<th>No</th>
			<th>Nama</th>
			<th>Jabatan</th>
			<th>Aksi</th>
		</thead>
		<tbody>
			<?php

	        include'config.php';

	        $query = mysqli_query($koneksi,"SELECT * FROM karyawan");

	        if(mysqli_num_rows($query) == 0){
	            echo '<tr><td colspan="6">Tidak Ada data!</td></tr>';
	        }else{
	            $no = 1;
	            while($data = mysqli_fetch_assoc($query)){
	                echo '<tr>';
	                echo '<td>'.$no.'</td>';
	               // echo '<td>'.$data['id'].'</td>';
	                echo '<td>'.$data['nama'].'</td>';
	                echo '<td>'.$data['jabatan'].'</td>';

	                echo '<td><a href="update.php?id='.$data['id'].'">Edit</a> / <a href="hapus.php?id='.$data['id'].'" onclick="return confirm(\'Yakin?\')">Hapus</a></td>';
	                echo '</tr>';
	                $no++;
	            }
	        }

	        ?>

		</tbody>
 	</table>
</body>
</html>


<!--add-->

<html>
<head>Add</head>
<body>
	<?php
	if(isset($_POST['submit'])){
		include 'config.php';
		$nama = $_POST['nama'];
		$jabatan = $_POST['jabatan'];
		$query = "INSERT INTO karyawan(nama,jabatan) VALUE ('$nama','$jabatan')";
		$hasil = mysqli_query($koneksi,$query);

		if($query){
			echo"<script>alert('data berhasil');window.location='index.php'</script>";
		}
		else{
			echo"<script>alert('data gagal dimasukan');window.location='index.php'</script>";
		}
		//header ("Location: index.php");
	}
	?>
	<form method="POST" action="">
		<label>Nama</label> &nbsp;
		<input type="text" name="nama">
		<br>
		<label>jabatan</label>
		<!--input type="text" name="jabatan"-->
		<select name="jabatan" required>
            <option value="">Pilih Jabatan</option>
            <option value="Manager">Manager</option>
            <option value="Staff">Staff</option>
            <option value="Operator">Operator</option>
        </select></td>
		<input type="submit" value="tambah" name="submit"/>
	</form>
</body>
</html>

<!--update-->
<html>
<head>Add</head>
<body>
	<?php
	include 'config.php';
	$id = $_GET['id'];
	if (!isset($_GET['id'])){
		header("Location:index.php");
	}
	if(isset($_POST['submit'])){
		$nama = $_POST['nama'];
		$jabatan = $_POST['jabatan'];
		$query = "UPDATE karyawan SET nama = '$nama', jabatan = '$jabatan' WHERE id = $id";
		$hasil = mysqli_query($koneksi,$query);
		if($query){
				echo"<script>alert('data berhasil');window.location='index.php'</script>";
			}
			else{
				echo"<script>alert('data gagal dimasukan');window.location='index.php'</script>";
			}
		//header("Location:index.php");
	}
	$query = "SELECT * FROM Karyawan WHERE id=$id";
	$hasil = mysqli_query($koneksi,$query);
	?>
	<form method="POST" action="">
		<?php while ($tampil = mysqli_fetch_assoc($hasil)) { ?>
		<label>Nama</label> &nbsp;
		<input type="text" name="nama" value="<?=$tampil['nama']; ?>">
		<br>
		<label>jabatan</label>
		<input type="text" name="jabatan" value="<?=$tampil['jabatan']; ?>">
		<input type="submit" value="update" name="submit"/>
		<?php }?>
	</form>
</body>
</html>

<!--delete-->
<?php
include "config.php";
$id = $_GET['id'];
$query = "DELETE FROM karyawan WHERE id = '$id'";
$hasil = mysqli_query($koneksi,$query);
if($query){
	echo"<script>alert('Data berhasil dihapus');window.location='index.php'</script>";
}
else{
	echo"<script>alert('data gagal di hapus');windown.location=index.php'</script>";
}
//header ("Location: index.php");
?>