How to convert from string to array in php?

Question

PHP

A question.
As a result of the SQL query, I get a line like this:

[{"id":"1","value":""},{"id":"2","value":""},{"id":"3","value":""},{"id":"4","value":""}]

How can I get an array from this? I need to get the values ​​of the value field at the end for a specific id
value Thanks in advance

Answer 1

By the way, starting with mysql 5.7, you can search the JSON database and work with JSON data at the DB level
https://www.percona.com/live/mysql-conference-2015...
PS sphinx 2.1+ can index JSON
Well, the answer has already been suggested to you how to work with json
Therefore, I think storing JSON in the database is a normal topic only in BLOB fields

Answer 2

json_decode read