Replace value of the array when null [duplicate]

Question

I created a WebService in php for get data from mySQL DB and returns a JSON.

So, I need that, whenever have null value from my DB, this value is changed for white (= " ").

I did this way, but without success (look the last foreach):

<?php

header("Content-Type: application/json; charset=utf-8;");

include('connectdb.php');

$something = $_GET['cod'];
$sqlcode = mysql_query("Select descricao, cliente, local from terminal_cartao Where     descricao='$something'");
$sqlcode2 = mysql_query("Select descricao, cliente, local from terminal_cartao");

$jsonObj= array();

if($something == 'all')
{

while($result=mysql_fetch_object($sqlcode2))
{
$jsonObj[] = $result;
}

}

else{
while($result=mysql_fetch_object($sqlcode))
{
$jsonObj[] = $result;
}
}

foreach ($jsonObj as $key => $value) {
if ($value === null) {
    $jsonObj[$key] = ""; 
}
}

$final_res =json_encode($jsonObj);
echo $final_res;
exit;

var_dump($value) inside foreach and verify what it returns carefully. Outside the question please refactor your code. — gvgvgvijayan
– gvgvgvijayan, Commented Nov 4, 2014 at 10:26

Husni · Accepted Answer · 2014-11-04 10:28:10Z

1

foreach ($jsonObj as $key => $value) {
  $value = get_object_vars($value);
  foreach($value as $key2 => $value2) {
    if ($value2 === null) {
      $jsonObj[$key]->$key2 = ""; 
    }
  }
}

answered Nov 4, 2014 at 10:28

Husni

1,0659 silver badges12 bronze badges

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

Comments

Rene Sá · Accepted Answer · 2014-11-04 10:28:20Z

0

The code bellow works fine for me now:

foreach ($jsonObj as $k1 => $row) {
foreach ($row as $k2 => $value) {
    if ($value === null) {
        $jsonObj[$k1]->$k2 = "";
    }
}
}

answered Nov 4, 2014 at 10:28

Rene Sá

45 silver badges24 bronze badges

Collectives™ on Stack Overflow

Replace value of the array when null [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related