Untitled

<?php
$servername = "localhost";
$username = "reon";
$password = "reon";
 $conn = mysqli_connect($servername,$username,$password);

if(!$conn){
	die("Database Connection Failed" . mysqli_error($conn));
}
$select_db = mysqli_select_db($conn, 'photo');
if(!$select_db){
	die("Database Selection Failed" . mysqli_error($conn));
}

if(isset($_POST) & !empty($_POST)){
	$firstname = mysqli_real_escape_string($conn, $_POST['name1']);
	$lastname =mysqli_real_escape_string($conn, $_POST['name2']);
	$email = mysqli_real_escape_string($conn,$_POST['email']);

	$sql = " INSERT INTO `users` (first name, last name,email) VALUES('$firstname','$lastname','$email')";
	$result = mysqli_query($conn, $sql);
	if($result){
		$smsg = "User Registration successfull";
	}else{
		$fmsg = "User registration failed";
	}
}
?>


<!DOCTYPE html>
<head>
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="register.css" >
<link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/font-awesome-4.7.0/css/font-awesome.css">
</head>

<body>
<div id="register_form">
  <img src="images/IMG_20151009_150434.jpg">
  <form  method="post">
  <div class="form_input">
  <input type="text" name="name1" autocomplete="on" autofocus placeholder="First Name" required><br>
  </div>
  <div class="form_input">
<input type="text" name="name2" autocomplete="on" autofocus placeholder="Last Name" required><br>
</div>
<input type="text" name="email" autocomplete="on" autofocus placeholder="Email" required><br>
<input type="reset"><br>
<input type="submit" name="register_btn"><br>
</form>
<?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
      <?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>
</div>

</body>
</html>