php - 如何将每个嵌套的json放入sql中

Question

我已经完成了以下 php

//read the json file contents
$jsondata = file_get_contents('ourfile.json');
 //convert json object to php associative array
$data = json_decode($jsondata, true);
//pull all job assignments 
$jobassignresults = array();
foreach($data['jobAssignments'] as $chunk){
    $jatech = $chunk['technician'];
    $jatechid = $jatech['id'];
    $jatechname = $jatech['name'];
    $jatechfinished = array($jatechid, $jatechname);
    $jobassignreults[] = $jatechfinished;
}
$jasplit = $data['jobAssignments']['split'];

我现在正在努力将这些数据放入 mysql，并启动以下代码

$sql ="INSERT INTO table1(jobassignresults, 

我一生都无法弄清楚如何将列出的每个技术的列表放入sql数据库中。

json 看起来像这样

"jobAssignments": [
{
  "id": 15797,
  "jobId": 15792,
  "jobNumber": "15792",
  "technician": {
    "id": 156,
    "name": "Mike"
  },

Answer 1

试试我的答案，如果有效的话。我循环数据，然后将每个循环数据插入数据库。

//read the json file contents
$jsondata = file_get_contents('ourfile.json');
//convert json object to php associative array
$data = json_decode($jsondata, true);
//pull all job assignments 

$jobassignresults = array();
$jatech = array(); //initiate variable

foreach($data['jobAssignments'] as $chunk){
  $jatech = $chunk['technician'];
  $jatechid = $jatech['id'];
  $jatechname = $jatech['name'];
  $jatechfinished = array($jatechid, $jatechname);
  $jobassignreults[] = $jatechfinished;
}

foreach($jatech as $key => $techs) //loop every data and insert.
{
   $sql = "INSERT INTO table_name ('id','name') VALUES ($techs['id'], $techs['name']);";
}