$servername="localhost";
    $username="root";
    $password="";
        $db="test";

   $con=mysqli_connect($servername,$username,$password,$db) or
die("Connection Failed");
   if(isset($_GET['submit']) && isset($_GET["EndUser"])){

       $name=$_GET['name'];
       $username=$_GET['username'];
       $password=$_GET['password'];
       $city=$_GET['city'];
           $type=$_GET['type'];

       $sql =  "INSERT INTO reservation
(Name,Username,Password,City,tUser) VALUES
('$name','$username','$password','$city', '$type')";

 if ($con->query($sql) === TRUE) {
    echo "New record created successfully";
 } else {
      echo "Error: " . $sql . "<br>" . $con->error;
  }

   }
   ?>