<?php

include_once "dbconnect.php";

$email = $_POST['email'];
$username = $_POST['username'];
$password = md5($_POST['password']);

$insert = "INSERT INTO users (username, email, password) VALUES  ('$username','$email','$password')";

if ($mysqli->query($insert) === TRUE) {

?>
    <script>alert('successfully registered ');</script>
    <?php
}else {
?>
<script>alert('error'); </script>

<?php
}


  header( 'register.html' );
  mysqli_close($mysqli);
?>

<?php
  session_start();
require_once("dbconnect.php");
?>
<br>
<?php
$username = $_POST['username'];
$password = md5($_POST['password']);
echo "error: ";
echo mysqli_error($mysqli);

?>
<br>
<?php
echo "username: ", $username;
$query = "SELECT password FROM users WHERE username='$username'";

$queryfinal = $mysqli->query($query, $mysqli);

$encpassword = md5($password);


?>
<br>
<?php
echo "password: ";
echo $encpassword;
?>
<br>
<?php
echo "query: ";
echo $queryfinal;
if ($queryfinal == $encpassword) {


  $_SESSION["username"] = "$username";

  header('Location: https://ruofftechnologies.com/login1/home.html');


}
else {
session_destroy();
?>
<br>
<?php
echo "failed";
}
?>