Function to Make Empty String NULL for MySQL Insertion in PHP

Question

This is similar question to MySQL and PHP - insert NULL rather than empty string but I'm still encountering the problem.

I'm trying to create a function so that an empty string is inserted as a NULL into MySQL.

I create the function IsEmptyString:

function IsEmptyString($val){
    if (trim($val) === ''){$val = "NULL";}
}

Before inserting the the variable, I escape it and then I call the function above. I've also tried $val = NULL;

What am I doing wrong? Also should I call the function before escaping?

psx · Accepted Answer · 2011-10-13 14:15:49Z

2

You need to return $val at the end of the function:

function IsEmptyString($val){
    if (trim($val) === ''){$val = "NULL";}
    return $val;
}

answered Oct 13, 2011 at 14:15

psx

4,0486 gold badges32 silver badges59 bronze badges

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

2 Comments

Kamil Sindi Over a year ago

I tried that but have the same problem. Can I just call the function, e.g. IsEmptyString($name) or do I have to set $name = IsEmptyString($name).

psx Over a year ago

You need to call $name = IsEmptyString($name). Another option is to define the function as: function IsEmptyString(&$val) then you do not need to return the value

Mob · Accepted Answer · 2011-10-13 14:16:58Z

0

You're not returning the value. This should work

function IsEmptyString($val){
    if (trim($val) === ''){$val = "NULL";}
return $val;
}

Also you're assigning your variable to a string and not null.

This line $val = "NULL";

should be

$val = null;

Also see PHP's isset() and empty() functions.

answered Oct 13, 2011 at 14:16

Mob

11.1k7 gold badges43 silver badges58 bronze badges

Comments

roselan · Accepted Answer · 2011-10-13 14:19:34Z

0

alternativly, you can pass val as reference.

function IsEmptyString(&$val){
    if (trim($val) === ''){$val = "NULL";}
}

however, be carefull not to send "'".$val."'" to the database;

answered Oct 13, 2011 at 14:19

roselan

3,7651 gold badge23 silver badges20 bronze badges

Comments

martinstoeckli · Accepted Answer · 2011-10-13 14:36:48Z

0

Either you can return the result with return...

function IsEmptyString($val)
{
  if (trim($val) === '')
    return 'NULL';
  else
    return $val;
}

...or you have to pass the variable as reference (note the & before the $val)

function IsEmptyString(&$val)
{
  if (trim($val) === '')
    $val = 'NULL';
}

edited Oct 13, 2011 at 14:36

answered Oct 13, 2011 at 14:18

martinstoeckli

24.3k7 gold badges63 silver badges92 bronze badges

1 Comment

martinstoeckli Over a year ago

@Rufinus - It seems that the OP is using the string 'NULL' to build an SQL statement. The function is a modification of the given example, it has other flaws too, as a misleading name for example.

Nathan Arthur · Accepted Answer · 2016-10-17 14:05:03Z

0

Looks like a good candidate for a ternary operator:

function valOrNull($val) {
    return (trim($val) === '') ? NULL : $val;
}

answered Oct 17, 2016 at 14:05

Nathan Arthur

9,2977 gold badges65 silver badges83 bronze badges

Collectives™ on Stack Overflow

Function to Make Empty String NULL for MySQL Insertion in PHP

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related