How to Check if Column is NULL Instead of Empty Using PHP and MSSQL

Question

I have PHP Code that is supposed to display the image name that is saved into my MSSQL table's row column photo. Some rows have the photo column set to NULL while some have the data 02.jpg in the photo column. If i use the code below, 02.jpg does not show up because it starts with zero. I am looking to find a way to check if the column is set to NULL rather than empty, because empty is not allowing some image names.

Here is the PHP code:

$picature2 = "SELECT photo1 FROM used_trailers1 WHERE orderid = $sn";
$query1=mssql_query($picature2, $conn);
$array1=mssql_fetch_assoc($query1);
$picature2=stripslashes($array1['photo1']);

if (empty($picature2['photo1'])){
    $picature2= "No Image";
} else {
    $picature2=stripslashes($array1['photo1']);
}

The code above correctly displays the "No Image" if the photo column is set to NULL, but if the photo column is 02lady.jpg then it will not work because it starts with a zero.

Here is what I tried:

if (IS_NULL($picature2['photo1'])){

So far that does not work and does not display the "No Image" if the column data for photo is NULL.

Thanks for any help. All help is greatly appreciated.

It starts with 0 so what? '02.jpg' won't be treated as empty. — zerkms
– zerkms, Commented Feb 25, 2014 at 4:05
You're checking $picature2 then using $array1. Does your code work even somehow? — zerkms
– zerkms, Commented Feb 25, 2014 at 4:08
It does get treated as empty. I am using an older version of MSSQL so maybe that is why. Yes, my code does work, some how. — Kelsey
– Kelsey, Commented Feb 25, 2014 at 4:16

Deadlock · Accepted Answer · 2014-02-25 04:44:22Z

1

Update

  if ($picature2['photo1']===null || ctype_space($picature2['photo1'])){
    $picature2= "No Image";
    }

     else {
        $picature2=stripslashes($array1['photo1']);
    }

edited Feb 25, 2014 at 4:44

answered Feb 25, 2014 at 4:07

Deadlock

1,5521 gold badge20 silver badges34 bronze badges

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

9 Comments

Kelsey Over a year ago

I tried using this, but it still does not return the "No Image" value. I have a delete button to reset the photo column to NULL and the sql for that is this : $sql = "UPDATE used_trailers1 SET photo1 = NULL WHERE orderid = '$sn'"; $retval2 = mssql_query($sql, $dbLink); is my $sql not setting the column to NULL?

Deadlock Over a year ago

What's the output echo gettype($picature2['photo1']) of?

Kelsey Over a year ago

The output is string.

Deadlock Over a year ago

So its not NULL. Try to trim it and check its type again.

Kelsey Over a year ago

What exactly do you mean by trim?

|

Community · Accepted Answer · 2023-11-20 22:45:59Z

0

You can use php is_null() function https://www.php.net/manual/en/function.is-null.php

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Feb 25, 2014 at 4:04

SajithNair

3,8771 gold badge20 silver badges23 bronze badges

Comments

Class · Accepted Answer · 2014-02-25 04:42:19Z

0

You have the following

$picature2=stripslashes($array1['photo1']);
if (empty($picature2['photo1'])){

which assigns photo1 to $picature2 then you check $picature2['photo1'] which $picature2 isn't a array.

You should use the following

#$picature2=stripslashes($array1['photo1']);
#remove this because if you have NULL and use stripslashes it turns into ""
if($array1['photo1'] === NULL){
    $picature2 = "No Image";
}else{
    $picature2 = stripslashes($array1['photo1']);
}

edited Feb 25, 2014 at 4:42

answered Feb 25, 2014 at 4:06

Class

3,1503 gold badges25 silver badges31 bronze badges

1 Comment

zerkms Over a year ago

Why to spread the logic across layers? You can even generate the result html in the query, but it makes no sense.

Collectives™ on Stack Overflow

How to Check if Column is NULL Instead of Empty Using PHP and MSSQL

3 Answers 3

Update

9 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Update

9 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related