Проблема с регистрацией. Данные из кода не передаются в бд. В чем может быть проблема?
Код регистрации -
<!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-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x" crossorigin="anonymous">
<link rel="stylesheet" href="style.css">
<title>Document</title>
</head>
<body>
<?php
require('connect.php');
if(isset($_POST['username']) && ($_POST['password'])){
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$query = "INSERT INTO users (username, email, password) VALUES ('$username', '$email', '$password')";
$result = mysqli_query($connection, $query);
if($result){
$smsg = "Регистрация прошла успешно";
} else {
$fsmsg = "Ошибка";
}
}
?>
<div class="container">
<form class="form-signin" method="POST">
<h2>Registration</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 class="form-control" name="username" type="text" placeholder="Username" required>
<input class="form-control" name="email" type="email" placeholder="Email" required>
<input class="form-control" name="password" type="password" placeholder="Password" required>
<button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>
</form>
</div>
</body>
</html>
Строка подключения -
<?php
$connection = mysqli_connect('localhost', 'root', 'root');
$select_db = mysqli_select_db($connection, 'practice');
?>
