Remove an element from Json array

Question

I stored my array content in form of json array to database .

Format: ["1","2","3"]

Now i retrieved the value from database and tried to remove the third element "2" from same structure.

My code for that is

$numbers= json_decode($numbers_db,true); //json decode numbers array got from DB
if (($key = array_search(2, $numbers)) !== false) {
                    unset($numbers[$key]);
                 }
                 $numbers_final = json_encode($numbers);

Now i expected $numbers_final to be of the format: ["1","3"]

But it resulted to {"0":"1","2":"3"}

Alejandro Arbiza · Accepted Answer · 2014-10-11 15:29:14Z

4

The problem is that when you unset() an element, the indexes are kept intact. In this case, the index 1 doesn't exists anymore so the array is converted into an object.

To force the array to be re-indexed sequentially yo can do something like this:

$numbers_db  = '["1", "2", "3"]';

echo $numbers_db;

$numbers= json_decode($numbers_db,true); //json decode numbers ar

if (($key = array_search(2, $numbers)) !== false) {
    unset($numbers[$key]);
    $numbers = array_values($numbers);
}
$numbers_final = json_encode($numbers);

echo $numbers_final;

edited Oct 11, 2014 at 15:29

answered Oct 11, 2014 at 15:17

Alejandro Arbiza

7665 silver badges10 bronze badges

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

Comments

Gerrlt · Accepted Answer · 2020-10-19 13:41:50Z

1

Use array_splice instead

array_splice($array,$offset,$length)

this will remove from the $offset element $length elements and re-index

answered Oct 19, 2020 at 13:41

Gerrlt

398 bronze badges

Collectives™ on Stack Overflow

Remove an element from Json array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related