php 无法将JSON数据插入MySQL

s4n0splo  于 2022-11-21  发布在  PHP
关注(0)|答案(1)|浏览(148)

我无法获得json格式的数据并将其插入mysql数据库。
我在employee_data.json中有这个JSON格式

{
   "MessageCode":"00",
   "Message":[
      {
         "name":"Michael Bruce",
         "gender":"Male",
         "designation":"System Architect"
      },
      {
         "name":"Jennifer Winters",
         "gender":"Female",
         "designation":"Senior Programmer"
      }
   ]
}

下面是我的PHP代码

<?php
          $connect = ysqli_connect("localhost", "root", "", "test");
          $query = '';
          $table_data = '';
          $filename = "employee_data.json";
          $data = file_get_contents($filename); 
          $array = json_decode($data, true); 
          foreach($array as $row) 
          {
           $query .= "INSERT INTO tbl_employee(name, gender, designation) 
           VALUES ('".$row["name"]."', 
                   '".$row["gender"]."', 
                   '".$row["designation"]."'); ";
          }
          ?>

$如何只返回数据

[
   {
      "name":"Michael Bruce",
      "gender":"Male",
      "designation":"System Architect"
   },
   {
      "name":"Jennifer Winters",
      "gender":"Female",
      "designation":"Senior Programmer"
   }
]
iqjalb3h

iqjalb3h1#

在执行foreach之前,您需要首先获得正确的对象

$array = json_decode($data, true); 
          $array = $array['message'];
          foreach($array as $row) {}

或者

foreach($array['message'] as $row) {}

相关问题