根据给定的json对象更新json数据


update json data according to a given json object

首先,我想从json文件中读取"Likes"值,更新它,例如使它加一或两个。

[{"ProductName": "Apsara", "Likes": "1"}]

将其插入带有"ProductName"的json中:"飞天"。

apsara_json_document_v2.json

[
  {
    "ProductName": "Apsara",
    "Likes": 0
  },
  {
    "ProductName": "Laxmipati",
    "Likes": 0
  }]

我在php中发布了两个字段,php搜索并提取包含ProductName的数组,我希望相应地更新点赞。这是我的php代码。。

<?php
    //checking if the script received a post request or not 
    if($_SERVER['REQUEST_METHOD']=='POST'){
        //Getting post data 
        $productname = $_POST['ProductName'];
        $likes = $_POST['Likes'];
        //checking if the received values are blank
        if($productname == '' || $likes == ''){
            //giving a message to fill all values if the values are blank
            echo 'please fill all values';
        }else{
            //If the values are not blank Load file
            $contents = file_get_contents('apsara_json_document_v2.json');
            //Decode the JSON data into a PHP array.
            $json = json_decode($contents, true);
            if(!function_exists("array_column")) {
                function array_column($json,'ProductName') {
                    return array_map(function($element) use($column_name){return $element[$column_name];}, $array);
                }
            }
            $user = array_search($username, array_column( $json, 'ProductName' ) );
            if( $user !== False ) 
                // Here I want to read from $user, the 'Likes' value, update it and then 
                //insert in file
                $json[$user] = array("Likes" => $likes);
            else
                echo "product not found";
            //Encode the array back into a JSON string.
            $json = json_encode($json);
            //Save the file.
            file_put_contents('apsara_json_document_v2.json', $json);
        }
    }else{
        echo "error";
    }

我不知道如何更新数组搜索结果的点赞值。

好吧,你只需要用intval将值解析为int,计算一下,然后用strval:将其放回字符串

$likes = intval($json[$user]['Likes']);
$likes++;
$json[$user]['Likes'] = strval($likes);

需要注意的一点是,intval在出错时返回0。因此,在进行错误检查时必须小心:

if($json[$user]['Likes'] === '0') {
  $likes = 0;
} else {
  $likes = intval($json[$user]['Likes']);
  if($likes == 0) {
    // ERROR! INTVAL returned an error
  }
}
$likes++;
$json[$user]['Likes'] = strval($likes);

此外,将数组中的密钥命名为$user是非常令人困惑的。为了清晰起见,称之为$index:)