Laravel PHP - Convert a string to array from DB

Question

I'm trying to do something like this:

$variable = Model::where($data)->get();

$data is stored in the database as ['type' => 1, 'status' => 2]

I cannot seem to be able to parse the data from a string to array properly, the best I have gotten close to is

0 => "['type' => 1, 'status' => 2]"

How can I properly parse this array from DB -> variable in php?

That’s not a deserializable format. You should write a custom parser for it, but that particular string can be evaluated: $array = eval("return $data;"); — rickdenhaan
– rickdenhaan, Commented Sep 26, 2021 at 8:57
It would be better if you changed the way the data is stored and used something like JSON instead. — Nigel Ren
– Nigel Ren, Commented Sep 26, 2021 at 9:06
@NigelRen - I agree, thank you, JSON would be easier to manage actually — Ayman Alyamani
– Ayman Alyamani, Commented Sep 26, 2021 at 9:10

Ayman Alyamani · Accepted Answer · 2021-09-26 09:12:24Z

1

I managed to fix it using the following:

$data = "['type' => 1, 'status' => 2]";
$variable = Model::where(eval("return $data;"))->get();

This will work properly.

Cleaned and Updated as @rickdenhaan recommended.

edited Sep 26, 2021 at 9:12

answered Sep 26, 2021 at 8:53

Ayman Alyamani

313 bronze badges

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

1 Comment

rickdenhaan Over a year ago

Just a quick note: if you're defining $data yourself like here in this code sample, it's best to avoid eval() and just write $data = ['type' => 1, 'status' => 2]; (without the " marks), then $data will already be an array. This is basically what eval() is doing with your string anyway.

Collectives™ on Stack Overflow

Laravel PHP - Convert a string to array from DB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related