Untitled

<?php
require 'db/koneksi.php';
require 'fungsi.php';

$record = array();

	if (!empty($_POST)){
		if(isset($POST['nama_depan'],$_POST['nama_belakang'],$_POST['bio'])){
			$nama_depan      = trim($_POST['nama_depan']);
			$nama_belakang   = trim($_POST['nama_belakang']);
			$bio			 = trim($_POST['bio']);

			if (!empty($nama_depan) && !empty($nama_belakang) && !empty($bio)) {
				$insert      = $db->prepare("INSERT INTO data (nama_depan, nama_belakang, bio, tgl_daftar) VALUES (?, ?, ?, NOW()) ");
				$insert->bind_param('sss',$nama_depan, $nama_belakang, $bio);

				if ($insert->execute()) {
					header('location:index.php');
					die();
				}
			}
		}
	}

	if($result = $db->query("SELECT * FROM data")){
		if ($result->num_rows) {
			while ($row = $result->fetch_object()) {
				$record[] = $row;
			}
			$result->free();
		}
	}

 ?>
 <!DOCTYPE html>
 <html>
 	<head>
 		<meta charset="UTF-8">
 		<title>input data</title>
 	</head>
 	<body>
 		<?php
 		if (!count($record)) {
 			echo 'tidak ada data';
 		} else {


 		 ?>

	 			<table align="center" border="1" cellpadding="1" cellspacing="0">
	 				<thead>
	 					<tr>
	 						<th>nama_depan</th>
	 						<th>nama_belakang</th>
	 						<th>bio</th>
	 						<th>tgl_daftar</th>
	 					</tr>
	 				</thead>
	 				<tbody>
	 					<?php
	 						foreach ($record as $r) {
	  					?>
	 					<tr>
	 						<td><?php echo escape($r->nama_depan);?></td>
		 					<td><?php echo escape($r->nama_belakang);?></td>
		 					<td><?php echo escape($r->bio);?></td>
		 					<td><?php echo escape($r->tgl_daftar);?></td>
		 				</tr>
		 				<?php
		 				}
		 				?>
	 				</tbody>
	 			</table>

 		<?php
 		}
 		?>

 		<hr>
 		<form action="index1.php" method="POST">
 			<table>
 				<tr>
 					<td>Nama depan</td>
 					<td><input type="text" name="nama_depan"></td>
 				</tr>
 				<tr>
 					<td>Nama Belakang</td>
 					<td><input type="text" name="nama_belakang"></td>
 				</tr>
 				<tr>
 					<td>bio</td>
 					<td><textarea name="bio"></textarea></td>
 				</tr>

 				<tr align="right">
 					<td></td>
 					<td><input type="submit" value="kirim"></td>
 				</tr>
 			</table>
 		</form>
 	</body>
 </html>