dick head

<?php

//this is for database connection!

//name of your host
$host = "localhost";
//username of your database
$username = "root";
//password of your database default is blank
$password = "";
//name of your database
$dbname = "elite_dragon";

$con = mysqli_connect("$host","$username","$password","$dbname");

if(mysqli_connect_error()){
	echo "Connection error";

}else{

}
?>

<?php
if(isset($_POST['record']))	{
$fname =$_POST['firstname'];
$lname = $_POST['lastname'];
$mname = $_POST['middlename'];
$gender = $_POST['gender'];
$m = $_POST['month'];
$d = $_POST['day'];
$y = $_POST['year'];
$bday = $m." ".$d." ".$y;
$course = $_POST['course'];
$stid = $_POST['stid'];
$ST = "10931106".$stid;
$stmt = $con->prepare("INSERT INTO students (Fname,lname,mname,gender,birtdate,course,stid) VALUES (?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param("sssssss", $fname, $lname,$mname,$gender,$bday,$course,$ST);
$stmt->execute();
echo "<script>alert('New record saved!');</script>";
$stmt->close();
}
?>

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<style>
.form{
	padding:100px;


}
</style>
<div class="form">
<form align="center" method="POST">
  Student Id:<br>
  <input type="text" name="stid"><br>
  First name:<br>
  <input type="text" name="firstname"><br>
  Middle name:<br>
  <input type="text" name="middlename"><br>
  Last name:<br>
  <input type="text" name="lastname"><br><br>
   Course:<br>
  <input type="text" name="course"><br><br>
  Birthdate:<br>
  M:
  <input style="width:5%;" type="text" name="month">
  D:
  <input style="width:5%;" type="number" name="day">
  Y:
  <input style="width:5%;" type="number" name="year">
  <br><br>
  Gender:
  <select style="width:11%;" name="gender">
	<option>Male</option>
	<option>Female</option>
  </select>
  <br><br>
  <button name="record" class="btn btn-primary">Submit</button>
</form>
</div>