Untitled

<?php
$mysqli = new mysqli("127.0.0.1","ivan","","(ne mi stana qsno kakvo ime na bazata)");

if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}
if($_POST['submit']){
    $name = $_POST['name'];
    $number = $_POST['number'];
    $email = $_POST['email'];
    $gender = $_POST['gender'];

    $query = "INSERT INTO registrations SET
            Name = '$name',
            Number = '$number',
            Email = '$email',
            Gender = '$gender'
            ";
    if ($mysqli->query($query) === TRUE) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $query . "<br>" . $mysqli->error;
    }

    $mysqli->close();
}

?>
<html>
<head>
    <style type="text/css">
        input::-webkit-outer-spin-button,
        input::-webkit-inner-spin-button {
          -webkit-appearance: none;
          margin: 0;
        }
    </style>
</head>
   <body>
    <form action="#" method="post">
        <label for="name">Име: </label>
        <input type="text" name="name" id="name"><br>
        <label for="number">Телефон: </label>
        <input type="number" name="number" id="number"><br>
        <label for="email">Имейл: </label>
        <input type="email" name="email" id="email"><br>
        <input name="gender" type="radio" value="male" id="male">
        <label for="male">Male</label>
        <input name="gender" type="radio" value="female" id="female" >
        <label for="female">Female</label>

        <input type="submit" name="submit">
    </form>
   </body>
</html>