Delete element from json with php

Question

i'm sorry for my english. I know that there are many other questions like this but i didn't find anything that could help me (or maybe i don't understand).

I have a json like this (autocaricate.json):

[
{
"nome":"LABORGHINI GALLARDO",
"descrizione":"LAMBORGHINI GALLARDO ED. NERA- ANNO 2007- ",
"indirizzo_pubblicato":"autocaricateeea\/LABORGHINI GALLARDO31072013-023853\/LABORGHINI GALLARDO31072013-023853.json",
"indirizzo_immagine_copertina":"autocaricateeea\/LABORGHINI GALLARDO31072013-023853\/IMG_1414 (600x448).jpg",
"indirizzo_paginaauto":"autocaricateeea\/LABORGHINI GALLARDO31072013-023853\/index.html"
},
{
"nome":"RENAULT MEGANE",
"descrizione":"RENAULT MEGANE -ANNO 2006-DIESEL-CC. 1461",
"indirizzo_pubblicato":"autocaricateeea\/RENAULT MEGANE31072013-024103\/RENAULT MEGANE31072013-024103.json",
"indirizzo_immagine_copertina":"autocaricateeea\/RENAULT MEGANE31072013-024103\/P1080949 (600x450).jpg",
"indirizzo_paginaauto":"autocaricateeea\/RENAULT MEGANE31072013-024103\/index.html"
},
{
"nome":"FORD MONDEO",
"descrizione":"FORD MONDEO SINISTRATA- ANNO 2009- DIESEL- CC. 1997-",
"indirizzo_pubblicato":"autocaricateeea\/FORD MONDEO31072013-045216\/FORD MONDEO31072013-045216.json",
"indirizzo_immagine_copertina":"autocaricateeea\/FORD MONDEO31072013-045216\/P1080971 (600x450).jpg",
"indirizzo_paginaauto":"autocaricateeea\/FORD MONDEO31072013-045216\/index.html"
}
]

I want delete an element (a car, for example RENAULT MEGANE) from the json with php. I write a function like this:

$url = $GET['indirizzo']; //this variable get an address like autocaricateeea\/RENAULT MEGANE31072013-024103\/index.html

$file = file_get_contents('autocaricate.json');
$data = json_decode($file);
unset($file);//prevent memory leaks for large json.
//insert data here
foreach($data as $elemento) {
    $valore = $elemento['indirizzo_paginaauto'];
    if($valore == $url){
        ****** enter code here ******
    }
}
//save the file
file_put_contents('autocaricate.json',json_encode($data));
unset($data);//release memory

Which code do i write for remove any property (for the car that we want remove, for example RENAULT MEGANE) from the json file?

Nimantha · Accepted Answer · 2021-07-21 04:56:39Z

41

I have found the correct way to check and remove an element from JSON file.

$i=0;
foreach($data as $element) {
   //check the property of every element
   if($url == $element->indirizzo_paginaauto){
      unset($data[$i]);
      echo ("elemento cancellato");
   }
   $i++;
}

edited Jul 21, 2021 at 4:56

Nimantha

6,5276 gold badges32 silver badges78 bronze badges

answered Aug 17, 2013 at 8:21

Manuel Ragazzini

9091 gold badge10 silver badges25 bronze badges

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

3 Comments

Murilo Over a year ago

The problem with this solution is that if we are working with an array of objects after this if we try a json_encode it becomes an object with several objects inside and the attribute of the main object is the key of the position it once had on the array. To fix this after the foreach we should do an $data = array_values($data) to rebase the main array.

BrDaHa Over a year ago

@Murilo Thanks for pointing that out, and this should be part of the answer, but I'm not sure why the author didn't see the issue with this approach. Also answered in this question considerably further down in my search results: stackoverflow.com/a/26316131/1827734 With an in-depth explanation at stackoverflow.com/a/27088740/1827734

ajaykools Over a year ago

Along with @Murilo solution, he also need to decrement $i ($i--) in IF condition, after unset().

Hiago Venancio · Accepted Answer · 2018-02-19 17:56:41Z

8

It's easier do that way.

//get all your data on file
$data = file_get_contents('teste_data.json');

// decode json to associative array
$json_arr = json_decode($data, true);

// get array index to delete
$arr_index = array();
foreach ($json_arr as $key => $value) {
    if ($value['YOUR KEY'] == SOME VALUE TO COMPARE) {
        $arr_index[] = $key;
    }
}

// delete data
foreach ($arr_index as $i) {
    unset($json_arr[$i]);
}

// rebase array
$json_arr = array_values($json_arr);

// encode array to json and save to file
file_put_contents('teste_data.json', json_encode($json_arr));

This will do Just fine. Trust me!

answered Feb 19, 2018 at 17:56

Hiago Venancio

811 silver badge3 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:46:16Z

3

<?php

$cars = json_decode($cars , true); // $cars is the json array before decoding
foreach ($cars as $key => $value) {
    if (in_array('RENAULT MEGANE', $value)) {
        unset($cars[$key]);
    }
}
$cars = json_encode($cars );
?>

1 Comment

Manuel Ragazzini Over a year ago

I'm sorry, but your solution doesn't work (also if i changed $animals to $cars) ;)

Matěj Koubík · Accepted Answer · 2013-08-13 15:24:55Z

0

foreach ($data as $key => $element) {
    $value = $element['...'];
    if (...) {
        unset($data[$key]);
        // or
        $data[$key]['...'] = '...';
    }
}

answered Aug 13, 2013 at 15:24

Matěj Koubík

1,1671 gold badge10 silver badges25 bronze badges

Comments

Aditya Yaduvanshi · Accepted Answer · 2021-04-08 17:45:58Z

0

getpath = file_get_contents('file.json');
$arr = json_decode($getpath, true);
for ($i = 0; $i < count($arr); $i++) {
    if($arr[$i]['id']==$id){
        unset($arr[$i]);
        $arr = array_values($arr);

        // encode array to json and save to file
        file_put_contents('file.json', json_encode($arr));
 
    }
}

answered Apr 8, 2021 at 17:45

Aditya Yaduvanshi

1

Collectives™ on Stack Overflow

Delete element from json with php

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related