使用key：value对从JSON过滤项目

Question

I have JSON array

[
{"id":"476","jobid":"324","remarks":"Job 500","status":"Open"},
{"id":"477","jobid":"324","remarks":"Job 501","status":"Closed"},
{"id":"481","jobid":"324","remarks":"Job 502","status":"Cancelled"}
]

How can I get remarks for the status Closed using PHP ?

Better if possible without loop

Answer 1

Check out JQL:

$jql = new JQL('[
  {"id":"476","jobid":"324","remarks":"Job 500","status":"Open"},
  {"id":"477","jobid":"324","remarks":"Job 501","status":"Closed"},
  {"id":"481","jobid":"324","remarks":"Job 502","status":"Cancelled"}
]');

$result = $jql->select('remarks')->where('status = Closed')->fetch();