php - Remove Json row that contains a specific value -
i've got json output 3 values.
{"contacts":[{"id":"1","name":"one"},{"id":"2","name":"two"},{"id":"3","name":"three"}]}
and remove row id equal 2, , output this:
{"contacts":[{"id":"1","name":"one"},{"id":"3","name":"three"}]}
my code
$output = array(); while($row = mysqli_fetch_assoc($result)) { $output[] = $row; } $json = json_encode(array( "contacts" => $output )); echo strip_tags($json);
how can that? thanks
aside obvious:
while($row = mysqli_fetch_assoc($result)) { if ($row['id'] != '2') { $output[] = $row; } }
what doing returning array, filtered version of it. use array_filter
:
$json = json_encode(array( 'contacts' => array_filter(function($row) { return $row['id'] != '2'; }, $output) ));
since getting results query, add where id != 2
query doesn't come begin with.
Comments
Post a Comment