index

<?php
$conn = mysql_connect('localhost','root','','tutorial_1');
$no = mysql_query($conn,"SELECT kode_anggota From tb_anggota");
$kd_anggota = mysql_fetch_array($no);
$kode = $kd_anggota['kode_anggota'];

$urut = substr($kode, 6, 3);
$tambah = (int) $urut + 1;
$bln = date ("m");
$thn = date ("y");

if (strlen($tambah)===1) {
	$format = "BW".$bln.$thn."00".$tambah;
} else if (strlen($tambah)===2) {
	$format = "BW".$bln.$thn."0".$tambah;
} else {
	$format = "BW".$bln.$thn.$tambah;
}

if(isset($_POST['submit'])){
	$no_urut = $_POST['no_urut'];
	$nama =$_POST['nama'];
	mysql_query($conn,"INSERT INTO tb_anggota(kode_anggota, nama_anggota) VALUES($no_urut','$nama')");
	header("location:index.php?success");
}
?>
<!DOCTYPE html>
<html>
<head>
	<title>no. urut</title>
</head>
<body>
<?php
if(isset($_GET['success'])){
echo"<h4>Data Berhasil Disimpan!</h4>";
}
?>
<form method="post" action="">
	<table>
	<tr>
		<td>No. urut</td>
		<td><input type="text" name="no_urut" value="<?php echo $format; ?>" readonly></td>
	</tr>
	<tr>
		<td>Nama</td>
		<td><input type="text" name="nama" value=""></td>
	</tr>
	<tr>
		<td></td>
		<td><input type="submit" name="submit" value="Simpan"></td>
	</tr>

	</table>
</form>
</body>
</html>