# Buat Aplikasi Sederhana - CREATE

---

## File database.php

<?php 	
	
$db_host = "localhost";
$db_username = "pma";
$db_password = "pma021";
$db_name = "sekola";

$db_connection = mysqli_connect($db_host,$db_username,$db_password,$db_name);

if(mysqli_connect_errno()){
	echo 'Database connection failed: '.mysqli_connect_error();
	exit();
} else {
	echo "Database connection succeed";
}

 ?>

## File index.php

<form action="proses.php" method="POST">
	<table border="0">
		<tr>
			<td>
				<input type="text" name="nama" placeholder="Nama Lengkap" required>
			</td>
		</tr>
		<tr>
			<td>
				<input type="radio" name="jk" required value="1"> Laki-laki
				<br>
				<input type="radio" name="jk" required value="0"> Perempuan
			</td>
		</tr>
		<tr>
			<td>
				<input type="text" name="tempatLahir" placeholder="Kota Lahir" required>
			</td>
		</tr>
		<tr>
			<td>
				<input type="date" name="tanggalLahir" required>
			</td>
		</tr>
		<tr>
			<td>
				<textarea required name="alamat" placeholder="Alamat Lengkap"></textarea>
			</td>
		</tr>
		<tr>
			<td>
				<input type="submit" name="submit" value="Input">
			</td>
		</tr>					
	</table>		
</form>

<?php 

require_once "database.php";

$select_query = "SELECT * FROM `murid` ORDER BY `id_murid` DESC;";
$result = mysqli_query($db_connection, $select_query);
?>

<table border="1">
	<tr>
		<td>ID Murid</td>
		<td>Nama Murid</td>
		<td>Jenis Kelamin</td>
		<td>Tempat Lahir</td>
		<td>Tanggal Lahir</td>
		<td>Alamat</td>
		<td>Edit / Hapus</td>
	</tr>
	
<?php while ($row = mysqli_fetch_array($result)): ?>

	<tr>
		<td><?=$row['id_murid']; ?></td>
		<td><?=$row['nama_murid']; ?></td>
		<td><?= ($row['jk_murid']=='1') ? 'Laki-laki' : 'Perempuan'?></td>
		<td><?=$row['tempatLahir_murid']; ?></td>
		<td><?=$row['tanggalLahir_murid']; ?></td>
		<td><?=$row['alamat']; ?></td>
		<td>
            <input type="button" onclick="location.href='edit.php?idMurid=<?=$row['id_murid']?>';" value="Edit" />
            
            /
            
			<input type="button" onclick="location.href='proses_hapus.php?idMurid=<?=$row['id_murid']?>';" value="Hapus" />
		</td>
	</tr>

<?php endwhile; ?>
    
</table>		

---
## File proses.php

<?php 	

	require_once "database.php";

	// var_dump($_POST);
	// die();


	$nama = $_POST['nama'];
	$jk = $_POST['jk'];
	$tempatLahir = $_POST['tempatLahir'];
	$tanggalLahir = $_POST['tanggalLahir'];
	$alamat = $_POST['alamat'];

	//syntax sql

	/*
	Format SQL sql insert

	INSERT INTO nama_table(nama_column1, nama_column2, . . .) VALUES ('nilai_column1', 'nilai_column2', . . .);

	*/

	$sql_insert = "INSERT INTO `murid` (`nama_murid`, `jk_murid`, `tempatLahir_murid`, `tanggalLahir_murid`, `alamat`) VALUES ('$nama', '$jk', '$tempatLahir', '$tanggalLahir', '$alamat')";

	//proses syntax sql

	if (mysqli_query($db_connection, $sql_insert)) {
		echo "New record created successfully";
	} else {
		echo "Error: " . $sql_insert . "<br>" . mysqli_error($db_connection);
	}

header('Location: index.php');
?>

---

## File proses_hapus.php

<?php 
require_once "database.php";

$id_murid = $_GET['idMurid'];

$query_delete = "DELETE FROM murid WHERE id_murid = $id_murid;";

mysqli_query($db_connection, $query_delete);

header('Location: index.php');
 ?>

---

## File edit.php

<?php 
require_once "database.php";

$id_murid = $_GET['idMurid'];

$select_query = "SELECT * FROM `murid` WHERE id_murid = '$id_murid';";
$result = mysqli_query($db_connection, $select_query);

$row = mysqli_fetch_assoc($result);

 ?>

<form action="proses_edit.php" method="POST">
	<table border="0">
		<tr>
			<td>
				<input type="hidden" name="id_murid" value="<?=$row['id_murid'];?>">

				<input type="text" name="nama" placeholder="Nama Lengkap" required value="<?https://hackmd.io/Ae2yBmw6Qx6MlTd0Lvvt7Q#=$row['nama_murid'];?>">
			</td>
		</tr>
		<tr>
			<td>
				<input type="radio" name="jk" required value="1" <?=($row['jk_murid']==1)? "checked" : "" ?>> Laki-laki
				<br>
				<input type="radio" name="jk" required value="0" <?=($row['jk_murid']==0)? "checked" : "" ?>> Perempuan
			</td>
		</tr>
		<tr>
			<td>
				<input type="text" name="tempatLahir" placeholder="Kota Lahir" required value="<?=$row['tempatLahir_murid'];?>">
			</td>
		</tr>
		<tr>
			<td>
				<input type="date" name="tanggalLahir" required value=<?=$row['tanggalLahir_murid'];?>>
			</td>
		</tr>
		<tr>
			<td>
				<textarea required name="alamat" placeholder="Alamat Lengkap">
					<?=$row['alamat'];?>
				</textarea>
			</td>
		</tr>
		<tr>
			<td>
				<input type="submit" name="submit" value="Edit">
			</td>
		</tr>					
	</table>		
</form>

---

## File proses_edit.php

<?php 	

	require_once "database.php";

	// var_dump($_POST);
	// die();


	$id = $_POST['id_murid'];
	$nama = $_POST['nama'];
	$jk = $_POST['jk'];
	$tempatLahir = $_POST['tempatLahir'];
	$tanggalLahir = $_POST['tanggalLahir'];
	$alamat = $_POST['alamat'];

	//syntax sql

	/*
	Format SQL sql UPDATE

	UPDATE murid SET column1=value1, column2=value2 WHERE id = id;

	*/

	$sql_update = "UPDATE murid SET nama_murid='$nama', jk_murid='$jk', tempatLahir_murid='$tempatLahir', tanggalLahir_murid='$tanggalLahir', alamat='$alamat' WHERE id_murid='$id';";

	//proses syntax sql

	if (mysqli_query($db_connection, $sql_update)) {
		echo "New record created successfully";
	} else {
		echo "Error: " . $sql_update . "<br>" . mysqli_error($db_connection);
	}


	header('Location: index.php');
?>