Convert string array back to PHP array

Question

In DB TEXT field i have saves string (polygon coordinates), similar to this: "[[35.408686311173874,-119.14944509590913],[35.408686311173874,-119.14538959587861]]"

What would be the easiest way to convert this string back to actual PHP array like this: [[35.408686311173874,-119.14944509590913],[35.408686311173874,-119.14538959587861]], when assigning it to a variable?

When I try to unserialize I get this error unserialize(): Error at offset 0 of 163 bytes

At fist, I thought it will be easy, but I still haven't found a solution on how to do that. Any thoughts? Thank you.

[json_decode](https://www.php.net/manual/en/function.json-decode.php) — Nick, Nov 12 '19 at 22:55
@Sharman, how would you recommend it to be saved in DB? Depending on polygon complexity, the string/point can be ~100 times longer. — Guntar, Nov 12 '19 at 22:58
I would save it in another table. If the relation is 1:N a separate table is required. — Dharman, Nov 12 '19 at 23:00

score -2 · Answer 1 · answered Nov 12 '19 at 23:01

-2

As @Nick noted, json_decode worked.

answered Nov 12 '19 at 23:01

Guntar

473
8
23

Convert string array back to PHP array

1 Answers1