Won't go into prepared statement

Asked May 19 '20 at 21:24

Active May 19 '20 at 21:26

Viewed 9 times

I am trying to insert something into my table called user. I have checked the names of the columns and it is correct, but it doesn't seem to go through the prepared statement as none of my echo messages shows up. I am using a password hash, but have made sure the varchar is "big" enough. It worked on the localhost, but not when I uploaded it to a server.

$password = password_hash($_POST['password'], PASSWORD_DEFAULT);

if($stmt = $conn -> prepare("INSERT INTO user (firstname, lastname, username, password, mail, joined) VALUES (?,?,?,?,?, NOW())")){
    echo "hello banana";
    $stmt -> bind_param("sssss",$_POST["firstname"], $_POST["lastname"], $_POST["username"], $password, $_POST["email"]);
    $stmt -> execute();
    echo "hello fruit";
    $id = $stmt -> insert_id;
    $stmt -> store_result();
    $_SESSION["id"] = $id;
    $redirectIndex = 1;
    $message =  "Account registered. You can now go to the <a href=\"index.php\"> front page</a>.";
     
    
    $stmt -> close(); 
}

edited May 19 '20 at 21:26

Barmar

741,623
53
500
612

asked May 19 '20 at 21:24

Meek

You can't use `$store_result()` for an `INSERT` statement, there's no result set. – Barmar May 19 '20 at 21:26
`$conn->prepare()` will return false on error, check that. If it is false, check `mysqli_error()` or equivilent. – Chris Haas May 19 '20 at 21:26
1

Add `else { echo $conn->error; }` to see the reason it didn't go through. – Barmar May 19 '20 at 21:27
@Barmar do you know another way to get the id of what u just inserted? :) – Meek May 19 '20 at 21:28
`$stmt->insert_id` does that. It has nothing to do with `store_result()`. BTW, it's not idiomatic to put spaces around `->`. – Barmar May 19 '20 at 21:30
@ChrisHaas it makes the page go blank – Meek May 19 '20 at 21:37
@Barmar didn't make a difference :/ – Meek May 19 '20 at 21:37
@Meek Which of my comments are you referring to when you say it didn't make a difference? – Barmar May 19 '20 at 21:40
@Barmar both space and removed the store_result() – Meek May 19 '20 at 21:41
1

Both of those have no effect. The spaces are just coding style. `store_result()` doesn't do anything. But you're getting the error when you call `prepare()` and nothing in the `if` block is being executed, so why would you expect changing that code to make a difference? – Barmar May 19 '20 at 21:43
@Barmar ah yeah lol ofc xD – Meek May 19 '20 at 21:43
1

@Barmar got back no database selected, I figured it out lol I did a stupid copy paste mistake somewhere, but thanks for your help! – Meek May 19 '20 at 21:47
Obviously you didn't. – Barmar May 19 '20 at 21:50
@Barmar yeah hehe – Meek May 19 '20 at 21:51

Won't go into prepared statement

0 Answers0