Untitled

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <h1>InsertData.php</h1>
    <?php
    $servername = "localhost";
    $username = "root"; //root is default user
    $password = ""; //default pw is blank
    $dbName = "heroesdb"; //database name

    //create connection
    $conn = mysqli_connect($servername, $username, $password, $dbName);

    //check connection
    if(!$conn) {
        die("Connection Failed:" . mysqli_connect_error());
    }
    echo "Connected Successfully! <br>";

    //get data from Form index.html
    $id = $_GET['id'];
    $name = $_GET['name'];
    $alterego = $_GET['alterego'];
    $gender = $_GET['gender'];
    $power = $_GET['power'];

   //make sql insert statement
   //insert data TO the database 'herodata'
   $sql = "INSERT into heroes(hID, hName, hIdentity, hGender, hPowers) values(" . $id . ",'" . $name . "','" . $alterego . "','" . $gender . "','" . $power
    . "');";

    //check if SQL is correctly formed
    echo $sql; //error here

    //write the data to the database
    if(mysqli_query($conn, $sql)) {
        echo "Records inserted successfully.";
    }
    else {
        echo "ERROR: Unable to execute $sql. " . mysqli_error($conn);
    }

    mysqli_close($conn);
    ?>
</body>
</html>