<?php

include 'dbh.php';
session_start();
$username= $_POST['username'];
$email= $_POST['email'];
$password= $_POST['password'];
$password2= $_POST['password2'];
if($password == $password2){
$sql="INSERT INTO user(username,email,password) values('$username','$email','$password')";
$query=mysqli_query($conn,$sql) or Die("ERROR: ".mysqli_error($conn));
if($query === FALSE){
    die(mysql_error());
}
else {
   $row=mysqli_fetch_row($query);
   $id=$row["id"];
   $_SESSION['id']=$id;
   $_SESSION['username']=$username;
   header("location:user.php");
}
}else {
    echo "Password doesn't match";
}

?>