php convert $str = '[0=>"hello",1=>"world"]'; into indexed array

Question

I have a string stored on my database in the following format:

$str = '[0=>"hello",1=>"world"]';

I wish to convert this into an array which would have the 0,"hello" key-value pair, 1,"world" key-value pair.

If there is a better way to format and store the string to make the conversion to array easier I would be open to that answer.

Thanks for your help Jordan

Better way is to build it as an array and then json_encode() it for storage; can easily be restored then using json_decode() — Mark Baker
– Mark Baker, Commented Mar 20, 2017 at 19:01
Storing multiple data elements of a row in a single column probably isn't the best idea to begin with. Have you considered adding another table in which each of these items would have its own row, and associating those rows with the row in your original table with a foreign key? — Don't Panic
– Don't Panic, Commented Mar 20, 2017 at 19:06
I find answer that can helps you, try it: stackoverflow.com/questions/3531857/… — 4EACH
– 4EACH, Commented Mar 20, 2017 at 19:28
It would probably be easier to give a good answer if we knew how you were getting that string to begin with. — Don't Panic
– Don't Panic, Commented Mar 20, 2017 at 19:31

Christopher Francisco · Accepted Answer · 2017-03-20 19:06:04Z

0

You can do that by passing the string to eval() but you need to put a return inside your string before the array.

That being said, you're probably better off using JSON format and calling json_decode to decode a JSON string to an array.

answered Mar 20, 2017 at 19:06

Christopher Francisco

16.4k31 gold badges110 silver badges222 bronze badges

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

2 Comments

user3502651 Over a year ago

Is there any way to store/ retrieve using JSON the index as well? I dont want json to automatically assume the data starts at index 0 and increments along. I want to specify the exact index - is this possible?

Mark Baker Over a year ago

Depending on the database you use, MySQL has a JSON datatype that can be indexed; but better to normalize your database structure

jedruniu · Accepted Answer · 2017-03-20 19:37:46Z

0

Answer for better way part of question, just use json formatted string. Example will be the best I guess. Such snippet of code:

<?php
$str = '{"0":"hello", "1":"world"}';
$arr = json_decode($str);

will give you exact pairs you are asking for.

answered Mar 20, 2017 at 19:37

jedruniu

5284 silver badges13 bronze badges

Comments

Simone Cabrino · Accepted Answer · 2017-03-20 19:42:43Z

If you want to use a structured data as you are doing now and storing it in a database, you can use a great function that laravel offers you, typecasting your structured data into an array.

Take a look at the documentation at the page https://laravel.com/docs/5.4/eloquent-mutators#array-and-json-casting

The array cast type is particularly useful when working with columns that are stored as serialized JSON. For example, if your database has a JSON or TEXT field type that contains serialized JSON, adding the array cast to that attribute will automatically deserialize the attribute to a PHP array when you access it on your Eloquent model.

This speed up the process for you and sometimes is comfortable than using an external table as suggested.

Collectives™ on Stack Overflow

php convert $str = '[0=>"hello",1=>"world"]'; into indexed array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related