Fatal error: Uncaught mysqli_sql_exception: Incorrect integer value: '' for column `id16714481_casestudy_db`.`users`.`verified` at row 1

Question

I don't understand why this is happening even though I have classified $verified as a boolean on my bind_param.

    $sql = "INSERT INTO users (user_name, email, verified, token, password) VALUES (?, ?, ?, ?, ?)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param('ssbss', $username, $email, $verified, $token, $password);

MySQL doesn't have a native boolean data type. Use `i` for parameter binding. — Dharman, May 03 '21 at 12:26

score 1 · Answer 1 · answered May 03 '21 at 12:24

1

Given the column name and the error message, I presume the verified column is an integer. However you're binding it as BLOB:

i corresponding variable has type integer

d corresponding variable has type double

s corresponding variable has type string

b corresponding variable is a blob and will be sent in packets

Both i and s should work.

(Reference)

answered May 03 '21 at 12:24

Álvaro González

142,137
41
261
360

Ohhh that's why it isn't working. Then why is it working on the Xampp MySQL? – someone May 03 '21 at 12:30
Sorry, I've no idea of what "working on the Xampp MySQL" means. – Álvaro González May 03 '21 at 13:04

Fatal error: Uncaught mysqli_sql_exception: Incorrect integer value: '' for column `id16714481_casestudy_db`.`users`.`verified` at row 1

1 Answers1