2

I'm developing an API which produces results in JSON format, when I encoded results into JSON using PHP, it shows every element in the row of the array. I use MySQL to grab data.

foreach($search as $item) {
    echo json_encode($item);
}

This will output 

{"id":"1","name":"A","tag":"a A","url":"A"} {"id":"2","name":"B","tag":"b B","url":"B"}

Is there a way to dump TAG element so it won't appear in JSON encoded results?

Naveen Gamage
  • 1,844
  • 12
  • 32
  • 51
  • 1
    Wouldn't it be easier only selecting the columns in your SQL `SELECT` statement that are needed for the JSON output? – dbf Aug 04 '13 at 13:29

2 Answers2

3
foreach($search as $item) {
    unset($item['tag']);
    echo json_encode($item);
}

you can do it by unset()

UnknownError1337
  • 1,222
  • 1
  • 12
  • 16
1

You can remove the element from the array before json_encode

foreach($search as $item) {
    unset($item['tag']);
    echo json_encode($item);
}
Pierrickouw
  • 4,644
  • 1
  • 30
  • 29