Untitled

<?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 = "myheroacademia";

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

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

}else{

}

?>

<?php
if(isset($_GET['submit']))
{
$StudentID = $_GET["num1"];
$FirstName = $_GET["num2"];
$LastName = $_GET["num3"];
$Course = $_GET["num4"];
$Birthdate = $_GET["num5"];
$General = $_GET["num6"];

$sql=mysqli_query($con,"INSERT INTO table(StudentID,FirstName,LastName,Course,Birthdate,Gender) VALUES ('$StudentID','$Firstname','$Lastname','$Course','$Birthdate','$Gender')");

}
?>

<img src="myhero.jpeg" WIDTH=1022, HEIGHT=188 border"3" >

<html>
<head>
<title>Student Information</title>
</head>
<body>

<h1 align=center>STUDENT INFORMATION</h1>

<form align=center method="GET">
<div>StudentID:</div>
<input type="text" name="num1"/>
<div>FirstName:</div>
<input type="text" name="num2"/>
<div>LastName:</div>
<input type="text" name="num3"/>
<div>Course:</div>
<input type=:"text" name="num4"/>
<div>Birthdate:</div>
<input type="text" name="num5"/>
<div>Gender:</div>
<input type="text" name="num6"/>
<p> </p>
<button name="submit">SUBMIT TO U.A.</button>
 </form>
<?php


?>

</body>
</head>
</html>