<?php
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password);
mysqli_select_db($conn,'login');

// Check connection
if (!$conn) {
     die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT userid FROM login";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
    $reguserid=$row["userid"];
}

$userid =  mysqli_real_escape_string($conn, $_POST['userid']);
$pswrd =  mysqli_real_escape_string($conn, $_POST['pswrd']);
$fname =  mysqli_real_escape_string($conn, $_POST['fname']);
$lname =  mysqli_real_escape_string($conn, $_POST['lname']);
$gender =  mysqli_real_escape_string($conn, $_POST['gender']);

$token = rand('122332344','922332344');
$url = array('forum.modzexpertz.tk/verify.php#',$token);

$post= join($url);

if($userid!=$reguserid){
    $sql = "INSERT INTO login(fname, lname, userid, pswrd,    gender)VALUES('$fname', '$lname', '$userid', '$pswrd', '$gender')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
}else {
 echo "Failed to Register.";
}} else {
echo "A user with the email youve provided has already been registered.";
}}
 $conn->close();
?>