<?php
  require_once('pages/connect.php');
  if (isset($_POST['username']) && isset($_POST['password'])){
    $username = mysqli_real_escape_string($connection, $_POST['username']);
    $email = mysqli_real_escape_string($connection, $_POST['email']);
    $password = md5($_POST['password']);
    $repassword = md5($_POST['repassword']);
    if ($password == $repassword) {
      $fmsg = "";
        $usernamesql = "SELECT * FROM 'users' WHERE username='$username'";
        $usernameres = mysqli_query($connection,$usernamesql);
        $count = mysqli_num_rows($usernameres);
        if($count == 1){
          $fmsg .= "Username Already Exist!";
        }

        $query = "INSERT INTO 'users' (username, password, email) VALUES ('$username', '$password', '$email')";
        $result = mysqli_query($connection, $query);
        if($result){
            $smsg = "User Created Successfully.";
        }else{
            $fmsg .= "Failed to Register User";
        }
    } else {
        $fmsg = "Password Do not Match";
    }
}
?>

$usernamesql = "SELECT * FROM 'users' WHERE username='$username'";