Not able to insert Null into database from PHP

Question

I'm trying to insert NUll into database everything is working fine but null is not inserted.

below query for the same.

#update permissions for deleted user and make it to NULL
$edit_user_permission = $conn->prepare('update create_user set permission = ? where role_id = ?');
$edit_user_permission->bind_param("ss",$permission,$role_id);
$permission = NULL;
$role_id = $_SESSION['role_code'];
$edit_user_permission->execute();

below structure of Permission column in the database

You bind the values first and than set them? use `$permission = NULL; $role_id = $_SESSION['role_code'];$edit_user_permission->bind_param("ss",$permission,$role_id); ` — Jens, Jun 19 '17 at 10:00
@Jens No, OP is binding the parameter (pass by reference, not value), so you can declare the values later, but just before executing: https://stackoverflow.com/questions/1179874/what-is-the-difference-between-bindparam-and-bindvalue — Terry, Jun 19 '17 at 10:00
yes i have tried by doing $permission = " " but it's not working — Jasshh Andrews, Jun 19 '17 at 10:03

Bibhudatta Sahoo · Answer 1 · 2017-06-19T11:23:19.227

0

I thing the issue is in parameter binding.So just change the parameter binding format.Do something like this

$edit_user_permission = $conn->prepare('update create_user set permission = ? where role_id = ?');
$edit_user_permission->bindParam(1, $permission);
$edit_user_permission->bindParam(2, $role_id);
$permission = NULL;
$role_id = $_SESSION['role_code'];
$edit_user_permission->execute();

It will help you. You can refer prepared-statements.php

Modified

$edit_user_permission->bind_param(1, $permission);
$edit_user_permission->bind_param(2, $role_id);

Try this one.

edited Jun 19 '17 at 11:23

answered Jun 19 '17 at 10:43

Bibhudatta Sahoo

4,808
2
27
51

i'm getting error: Call to undefined method mysqli_stmt::bindParam() – Jasshh Andrews Jun 19 '17 at 11:13
is it working for other value and not working for null. – Bibhudatta Sahoo Jun 19 '17 at 11:43
i havt tried for other values but it is not working for null – Jasshh Andrews Jun 19 '17 at 11:47
then you do like this $permission = ' ';.And some me the table value after update – Bibhudatta Sahoo Jun 19 '17 at 11:50

Not able to insert Null into database from PHP

1 Answers1