register code

<?php

    $username = $_POST['username'];
    $password = $_POST['password'];
    $email = $_POST['email'];

    $conn =   new mysqli('localhost','root','','calendar');
    $conn->query("SET NAMES 'UTF8'");
    $query = "INSERT INTO `users` (username, password, email) VALUES ('$username' , '$password' , '$email')";

    if ($conn->connect_error) {
        die("Database connection failed: " . $conn->connect_error);
    }
    echo "Database connected successfully<br>   ";

    if($conn->query($query) == true){
        echo 'Insertion seccessfully';
        header('location:../login.php');
    }else{
        echo 'Insertion failed';
    }

    $conn->close();


?>