Signup registration is not registering users in db record

Hi Team

I am having a problem with my back end, i am using php to register new users but somehow its not registering them instead it throws an exception i created for password incorrect.

// Back end

0)
{
    $exists="Username not available";
}
    
}//end if
    
?>


    
            Success! Your account is 
            now created and you can login.

'; } if($showError) { echo '

Error! '. $showError.'

'; } if($exists) { echo '

Error! '. $exists.'

'; } ?>

// Front end

Remember me

It's difficult to determine the exact cause of the issue without seeing the error message, but it looks like you're checking if the username already exists in the database, and if it doesn't, you're checking if the passwords match before inserting the new user.

One possible issue could be with the password hash generated using password_hash(). Make sure that the column where you're storing the password in the database has enough space to hold the hashed password.

Another issue could be with the SQL query itself. Make sure that the table name and column names are correct and match the names in your database.

You can also try adding some error handling code to print out the error message when the mysqli_query() function fails. This will give you more information about the specific error that's occurring.

Here's an example of how you can print out the error message:

$result = mysqli_query($conn, $sql);
if (!$result) { printf("Error: %s\n", mysqli_error($conn)); exit();
}

Hope this helps!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Lokesh Varman3y ago
Accepted answer
It's difficult to determine the exact cause of the issue without seeing the error message, but it looks like you're checking if the username already exists in the database, and if it doesn't, you're checking if the passwords match before inserting the new user.

One possible issue could be with the password hash generated using password_hash(). Make sure that the column where you're storing the password in the database has enough space to hold the hashed password.

Another issue could be with the SQL query itself. Make sure that the table name and column names are correct and match the names in your database.

You can also try adding some error handling code to print out the error message when the mysqli_query() function fails. This will give you more information about the specific error that's occurring.

Here's an example of how you can print out the error message:
```
$result = mysqli_query($conn, $sql);
if (!$result) { printf("Error: %s\n", mysqli_error($conn)); exit();
}
```
Hope this helps!