php - 如何使用php中的str_replace函数替换数组中的值

Question

我在 mysql 数据库表中有一个 json 格式的数据，如下所述。

 {
 "dataType": "mis_type",
 "diceCode": "20070100102",
 "forms": {
   "4. Campus": {},
   "7. Classroom": {},
   "1. Details of school": {
          "School_Name": "GOVT. UPG .M.S. KHAGARA",
          "Village_Name": "KHAGARA",
          "Block_Name": "MOHAN PUR",
          "Dist_Name": "DEOGHAR",
          "Type_of_School": "DEPARTMENT OF EDUCATION",
          "Category": "PRIMARY WITH UPPER PRIMARY",
          "No_of_Student": 209,
          "No_of_Section": 8,
          "No_of_Classroom": 5,
          "Govt_Teacher": 2,
          "Para_Teacher": 3,
          "Other_Teacher": 0,
          "Total_Teacher": 5,
          "Total_Toilet": 2,
          "Total_Urinals": 2
             },
    "6. Drinking Water Source": {},
    "8. Kitchen Shed": {},
    "2. Location of School": {},
    "5. Location of Toilet": {},
    "3. Pollution Status": {
    }
   }
 }

我正在尝试用另一个新值替换“Total_Toilet”值。为此我编写了以下代码。

  $selectQuery = "SELECT `json_data` FROM `abc` WHERE `disc_code`='" . $diseCode . "' AND `type`='mis'";
  $res = $conn->query($selectQuery);
  $jsonvalue = $res->fetch_assoc();
  $jsonvalue = json_decode($jsonvalue['json_data'], true);
  unset($value['Dise_Code']);
  unset($value['OBJECTID']);
  if ($res->num_rows > 0) 
 {
   foreach( $jsonvalue['forms']['1. Details of school'] as $key1 => $value1 )
 {
   echo"<br>"; 
   $key2 = str_replace($jsonvalue['forms']['1. Details of school'] ['Total_Toilet'] , 4, $value1 ) ;
   echo $key2;
 }

代码正在编译，没有任何错误，但仍然没有使用 str_replace 函数将先前的值替换为新值。如果我做错了什么，请指导我，或者如果有人知道任何替代解决方案，请帮助我。

如有任何帮助，我们将不胜感激。

Answer 1

好的，请在 foreach 循环之前添加以下行

$jsonvalue['forms']['1. Details of school']['Total_Toilet'] = 4;

并按如下方式进行 foreach 循环

foreach( $jsonvalue['forms']['1. Details of school'] as $key1 => $value1)
{
    echo"<br>"; 
    $key2 = $value1;
    echo $key2;
}

希望这对您有帮助。