Database error: faild to registerIncorrect integer value: '' for column 'verify' at row 1

Asked Dec 10 '21 at 08:10

Active Dec 10 '21 at 08:52

Viewed 22 times

I have gone through many questions already but couldn't get the solution. I have avoided id column from my query,which is auto incremented. However I am still getting the above error. My code is as below:

$sql = "INSERT INTO userdata (email,dob,password,verify,token) VALUES (?, ?, ?, ?, ?)";
        $stmt = $conn->prepare($sql);
        $stmt -> bind_param('sssbs',$receivedEmail,$receivedDob,$receivedPwd,$verified,$token);
        if($stmt->execute()){
            //login user
        }else{
        $errors['db_error'] = "Database error: faild to register" .htmlspecialchars($stmt->error);
        }

Can someone help me to figure out this problem? Thank You

edited Dec 10 '21 at 08:52

Dharman

30,962
25
85
135

asked Dec 10 '21 at 08:10

You have put b instead of s in the types – Dharman Dec 10 '21 at 08:51
1

where do you what me to put b? I already used it.... – Dec 10 '21 at 09:01
Don't use b. Your first argument should be composed of only s. So `'sssss'` and don't use any other letters – Dharman Dec 10 '21 at 09:10
I already try that still getting same error – Dec 10 '21 at 17:35
Please update the code in question so that we can see what you tried – Dharman Dec 10 '21 at 18:13
I solved it as I change b to I now I am able to store data. – Dec 10 '21 at 20:00
Why `i` though? Why not `s`? – Dharman Dec 10 '21 at 20:01
error showing that incorrect integer value so I set it to I, and that work for me – Dec 11 '21 at 08:54

Database error: faild to registerIncorrect integer value: '' for column 'verify' at row 1

0 Answers0