Convert a JSON_KEYS(specs) result from a MySql query to php array?

Question

From a php script I'm requesting the keys of a JSON field in a MySQL 8++ database (table) using the JSON_KEYS(specs), which works fine. The result is a string like this $json_keys = '["KEY1", "KEY2", "KEY3", "KEY4"]'

Is there a quick way to convert this into a php array ?

Today i'm doing this $myArray = explode(', ',str_replace(array('[',']','"'), '',$json_keys)); But there must be a better and smarter way to do it.

RePsEj · Accepted Answer · 2020-09-14 18:23:08Z

0

I think the best answer is

$myArray = json_decode ($json_keys)

answered Sep 14, 2020 at 18:23

RePsEj

499 bronze badges

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

Collectives™ on Stack Overflow

Convert a JSON_KEYS(specs) result from a MySql query to php array?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related