PHP: insert NULL if input value is empty

Question

i have been trying to insert NULL to my database if the value of input is empty but i still it insert empty and NULL string

Here's my code

this code returns blank

  if (empty($_POST['caller'])){ $caller= NULL; }else{ $caller =  mysqli_real_escape_string($con, $_POST['caller']);}

  or this

  $caller =  mysqli_real_escape_string($con, $_POST['caller']);
  $caller = !empty($caller_contact) ? "'$caller'" : NULL;

this code returns NULL string

  $caller =  mysqli_real_escape_string($con, $_POST['caller']);
  $caller = !empty($caller_contact) ? "'$caller'" : 'NULL';

 or this

  if (empty($_POST['caller'])){ $caller= 'NULL'; }else{ $caller =  mysqli_real_escape_string($con, $_POST['caller']);}

query

$sql_caller = "INSERT INTO `tblcall_info` VALUES ('','$save_inc_id','$call_time','$call_date','$caller','$caller_contact','$receiver','$device')";

i have also tried changing '$caller' to $caller but its an error.

can anyone help?. thanks

bharat · Accepted Answer · 2016-11-27 14:59:44Z

2

You can try this way:

remove single invated comma from query and set them to query it will surely work for you

if (empty($_POST['caller'])){ 
    $caller="NULL";
}else{ 
    $caller=mysqli_real_escape_string($con, $_POST['caller']);
    $caller="'$caller'";
}

$sql_caller = "INSERT INTO `tblcall_info` VALUES ('','$save_inc_id','$call_time','$call_date','$caller','$caller_contact','$receiver','$device')";

edited Nov 27, 2016 at 14:59

answered Nov 27, 2016 at 14:40

bharat

1,7821 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Vincent Dapiton Over a year ago

its just like my code. it will only generate string null not the actual NULL

bharat Over a year ago

please check my updated comment it may helps you :-|

Vincent Dapiton Over a year ago

as in my statement above in my question i already change '$caller' to $caller but it generated an error

Vincent Dapiton Over a year ago

i accepted it coz it got me an idea and tried it and it work

Vincent Dapiton Over a year ago

i just put single quotes in null like this 'NULL' and remove quotes to $caller

|

Muhammad Faizan Uddin · Accepted Answer · 2016-11-27 14:27:34Z

1

Try this method in the $sql_caller string:

INSERT INTO table_name (column1,column2,...)  VALUES(value1,value2,...);

And skip the column & it's value, which you want to be set as NULL.

answered Nov 27, 2016 at 14:27

Muhammad Faizan Uddin

1,37713 silver badges29 bronze badges

1 Comment

Vincent Dapiton Over a year ago

if i skip column and value that i want to be NULL then the problem is if the value is not empty it will not be added to the database. it will always be null even if it is not empty

Collectives™ on Stack Overflow

PHP: insert NULL if input value is empty

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related