Как настроить форму регистрации

<?php
$connection = mysqli_connect(
    $hostname = 'localhost',
    $user = 'root',
    $password = 'root',
    $database = 'practice',
    $port = '3306'   
)
?>

Всем привет, не понимаю почему не отрабатывает форма регистрации, не могу понять где ложится соединение с БД

.form-signin{
    max-width: 400px;
    padding: 15px;
    margin: 0 auto;
}
.btn{
    width: 370px; 
}
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-KyZXEAg3QhqLMpG8r+8fhAXLRk2vvoC2f3B09zVXn8CA5QIVfZOJ3BCsw2P0p/We" crossorigin="anonymous">
    <link rel="stylesheet" href="style.css">
    <title>Document</title>
</head>
<body>

<?php
require('connect.php');
if (isset($_POST['username']) && isset($_POST['password'])){
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = $_POST['password'];

    $query = "INSERT INTO users (username, password, email) VALUES ('$username', '$email', '$password' )";
    $result = mysqli_query($link, $query);

    if($result){
        $smsg = "Регистрация успешна";    
    } else
        $fsmsg = "Ошибка, попробуйте ещё раз";
}
?>
    <div class="container">
        <form class="form-signin" method="POST">
            <h2>Регистрация</h2>

            <?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
            <?php if(isset($fsmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fsmsg; ?> </div><?php } ?>

            <input type="text" name="username" class="form-control" placeholder="username" required>
            <input type="email" name="email" class="form-control" placeholder="Email" required>
            <input type="password" name="password" class="form-control" placeholder="Password" required>
            <button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>
        </form>
    </div>
    
</body>
</html>

Ответы (0 шт):