modifying json file values with php

Question

I have a json file with this below exact format structure.

[  
 {  
    "name":"banana",
    "type":"fruit",
    "rate":10
 },
 {  
    "name":"orange",
    "type":"fruit",
    "rate":20
 },
 {  
    "name":"apple",
    "type":"fruit",
    "rate":30
 }
]

The goal logic would be

if the fruit rate searched is 30 ,i would update it to 31
if the fruit rate searched is 31 ,i would update it to 32
if the fruit rate searched is 32 ,i would update it to 33
if the fruit rate searched is 33 , stop updating and echo "Over Priced";

I would like to update the rate of the fruit when searched with fruit name "apple" by +1 upto +3 when i match a search for it ?.

How can i achieve the goal logic ?

I tried programming lengthy code here but it failed with finding index to modify - finding php json array index number

you can update what you want and check other limit, after update it you can break the loop with use break at the foreach. — SuperBear
– SuperBear, Commented Sep 18, 2014 at 6:12

BetaCoder · Accepted Answer · 2014-09-18 06:40:05Z

1

$text = file_get_contents('fruits.txt');
$json = json_decode($text , true);
$searchedFruit = 'apple';

foreach ($json as &$fruit){
  if($fruit['name'] === $searchedFruit){
    if($fruit['rate'] >= 30 && $fruit['rate'] < 33){
      $fruit['rate']++;        
    } else if($fruit['rate'] === 33){
      echo "Over priced";
    }
  }
}

var_dump($json);

file_put_contents('fruits.txt', json_encode($json));

edited Sep 18, 2014 at 6:40

BetaCoder

3121 silver badge13 bronze badges

answered Sep 18, 2014 at 5:47

ylerjen

4,3082 gold badges31 silver badges48 bronze badges

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

1 Comment

BetaCoder Over a year ago

I don't want all the fruit rates to be increased to +1 , instead if i search orange , it should update only the value of orange rate by +1

Clément Malet · Accepted Answer · 2014-09-18 05:56:59Z

0

You went too far with your previous code

$json = '[{"name":"banana","type":"fruit","rate":31},
 {"name":"orange","type":"fruit","rate":32},
 {"name":"apple","type":"fruit","rate":33}
]';

$array = json_decode($json, true);

$maximum_rate = 32;
$searched_fruit = "apple";

foreach ($array as &$value) {
  if ($value['name'] == $searched_fruit) {
    if ($value['rate'] > $maximum_rate) {
      echo 'Over priced : ' . $value['name'] . "\n";
      break;
    } else {
      $value['rate']++;
      break;
    }
  }
}

$json = json_encode($array);

var_dump($json);

Output :

Over priced : apple
[{"name":"banana","type":"fruit","rate":31},
 {"name":"orange","type":"fruit","rate":32},
 {"name":"apple","type":"fruit","rate":33}]

edited Sep 18, 2014 at 5:56

answered Sep 18, 2014 at 5:46

Clément Malet

5,0903 gold badges32 silver badges48 bronze badges

4 Comments

BetaCoder Over a year ago

I don't want all the fruit rates to be increased to +1 , instead if i search orange , it should update only the value of orange rate by +1

Clément Malet Over a year ago

@BetaCoder It won't, it will update only the fields corresponding to $searched_fruit. I used a foreach in the case where you'd have several fruits / types or don't know what with the same name. Edit : Oh right, I got what you mean when I added breaks. Your question wasn't clear about the "the wanted fruit only"

ylerjen Over a year ago

it will +1 every fruit that is not the searched one with your answer. You have only 1 if clause with all conditions, so the else will be executed for every non searched element

ylerjen Over a year ago

Ok... your answer was edited while I was writing... ;)

Collectives™ on Stack Overflow

modifying json file values with php

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related