Untitled

<?php
$link=mysqli_connect("localhost","root","qwerty");
include_once 'dbconnect.php';
if(isset($_POST['btn-signup']))
{
 $firstname = mysqli_real_escape_string($link,$_POST['firstname']);
 $lastname = mysqli_real_escape_string($link,$_POST['lastname']);
 $email = mysqli_real_escape_string($link,$_POST['email']);
 $phone = mysqli_real_escape_string($link,$_POST['phone']);
 $obatbeli = mysqli_real_escape_string($link,$_POST['obatbeli']);
 $jumlah = mysqli_real_escape_string($link,$_POST['jumlah']);
 //$total = mysqli_real_escape_string($link,$_POST['total']);
 //$upass = md5(mysqli_real_escape_string($link,$_POST['pass']));
 $sql="SELECT harga FROM tbl_obat WHERE namaobat='$obatbeli'";
 $hargasatuan=mysqli_query($link,$sql);
 $total=$hargasatuan*$jumlah;
if(mysqli_query($link,"INSERT INTO tbl_konsumen(`first_name`, `last_name`, `email_id`, `phone`, `obat`, `jumlah`, `total`) VALUES('$firstname','$lastname','$email','$phone','$obatbeli','$jumlah','$total')"))
 {
  ?>
        <script>alert('transaksi konsumen berhasil didaftarkan');</script>
        <?php
 }
 else
 {
  ?>
        <script>alert('transaksi konsumen gagal didaftarkan');</script>
        <?php
 }
}


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
	<head>
		<meta http-equiv="Content-Type" content="html; charset=utf-8" />
			<title>Input Data Konsumen</title>
				<link rel="stylesheet" href="style.css" type="text/css" />

	</head>
<body>
	<center>
		<div id="login-form">
			<form method="post">
				<table align="center" width="30%" border="0">
					<tr><td><input type="text" name="firstname" placeholder="first name" required /></td></tr>
					<tr><td><input type="text" name="lastname" placeholder="last name" required /></td></tr>
					<tr><td><input type="text" name="email" placeholder="email" required /></td></tr>
					<tr><td><input type="text" name="phone" placeholder="phone" required /></td></tr>
					<tr><td><input type="text" name="obatbeli" placeholder="obat yang dibeli" required /></td></tr>
					<tr><td><input type="text" name="jumlah" placeholder="berapa yang dibeli?" required /></td></tr>

					<tr><td><button type="submit" name="btn-signup">Input</button></td></tr>
					<tr><td><a href="tabelkonsumen.php">Home</a></td></tr><tr><td><a href="tabelkonsumen.php">Daftar Konsumen</a></td></tr>
					</tr>
				</table>
			</form>
		</div>
	</center>
</body>
</html>