我无法获得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"
}
]
1条答案
按热度按时间iqjalb3h1#
在执行foreach之前,您需要首先获得正确的对象
或者