Http 500 error with register page

[Richard Deeming]

and180y wrote:

$sql = "INSERT INTO users (email, username, password) VALUES (?, ?)";
...
mysqli_stmt_bind_param($stmt, "ss", $param_email, $param_username $param_password);

Two obvious problems: You're inserting into three columns, but you've only specified two values:

$sql = "INSERT INTO users (email, username, password) VALUES (?, ?, ?)";

You've only specified types for two parameters, and you're missing a comma between the last two parameters:

mysqli_stmt_bind_param($stmt, "sss", $param_email, $param_username, $param_password);

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[and180y]

Thanks for replying Richard. :) I've fixed those errors but still having the same issue, it loaded the form once but now just a white page with the error.

[and180y]

I have played around starting again from the basic code and adding in what I need and checking for errors, all is fine till I put the code below in.

 }

// Validate email
if(empty(trim($\_POST\["email"\]))){
    $email\_err = "Please enter your email.";     
} elseif(strlen(trim($\_POST\["email"\])) < 6){
    $email\_err = "email must have at least 6 characters.";
} else{
    $email = trim($\_POST\["email"\]);
}

[Lost User]

if(empty(trim($_POST["email"]))){

If the email variable is blank then calling trim on it will fail. You should change it to:

if(empty($_POST["email"])){

[and180y]

Working perfect now. Thanks Richard. :)

[Lost User]

You're welcome.

[and180y]

Richard, is there an error log generated somewhere for the DB? I get an intermittent fault (loads of folk saying the can't register but I can see some are able to) This is the error that shows on the form so not of much use. lol "Something went wrong. Please try again later".

[Lost User]

Sorry, I don't know offhand. Check the MySQL documentation. I see that you are posting that message in your code. So you need to check why the call to mysqli_stmt_execute failed.

[and180y]

Thanks Richard, I edited as you said the other night but wonder if my issue is somewhere in here?

if(empty($_POST["email"])){
$email_err = "Please enter your email.";
} elseif(strlen(trim($_POST["email"])) < 6){
$email_err = "email must have at least 6 characters.";
} else{
$email = trim($_POST["email"]);
}
}

[and180y]

Thanks Richard, progress made. There is no error as such, if you try to register with the same email twice (yes I thought that as well) it throws the error I mentioned but isn't telling them the email is already registered. It does for username but the email was the bit I added in. :-)

[Lost User]

Did you not realise that you first need to check whether the email is already registered?

[and180y]

Hi Richard, thanks. :) Everyday is a school day dealing with the humans I do. :)