PHP JSON array_push replacing NULLS with blanks?

Question

Hi guys I am using the array_Push function and I am wondering if there's any way for the array_push function to return

                array_push($result, array('order_id' => $row[0],
                                  'type'  => $row[2],
                                  'description' => nl2br($row[3]),
                                  'amount' => $row[4],
                                  ));

and with the json_encode i get

   "result":[{"order_id":"67","type":"HEADER","description":"Coca Cola","amount":null},{"order_id":"72","type":"TEXT","description":"French Fries","amount":null}

this is output in a table as

    $.each(data.result, function(){
        $("tbody").append("<tr id='order_"+this['order_id']+"'><td>"+this['type']+"</td><td></td><td>"+this['description']+" </td><td>"+this['amount']+"</td><br>");

So i was wondering if there is a way for the NULL values to be returned as blanks instead? IF so, where can I do this?

"Blanks" is not a thing in PHP, or any language I'm aware of for that matter. — deceze
– deceze ♦, Commented Apr 8, 2014 at 17:32
You might want to fix the problem at the source. Do you really need / want NULL values in your table instead of empty strings for strings and a 0 for amounts? — jeroen
– jeroen, Commented Apr 8, 2014 at 17:35

Marc B · Accepted Answer · 2014-04-08 17:31:24Z

4

Just do

'amount' => (is_null($row[4]) ? '' : $row[4])

answered Apr 8, 2014 at 17:31

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

deceze Over a year ago

I'd use === null, but that's just me. The fewer parenthesis the better. ;) +1

souslov · Accepted Answer · 2014-04-08 17:42:44Z

1

foreach($row as &$value){   
    $value = $value === null ? '' : $value;
}

edited Apr 8, 2014 at 17:42

answered Apr 8, 2014 at 17:31

souslov

44.7k11 gold badges92 silver badges113 bronze badges

Collectives™ on Stack Overflow

PHP JSON array_push replacing NULLS with blanks?

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related