“此json数据”å“陆地岛屿”,这是写在数据库视图中的-ã…“陆地岛屿”?请帮我找错地方`
<?php
$link = mysqli_connect('localhost','root','password','days');
$string = file_get_contents('data.json', true);
$json_a = json_decode($string, true);
foreach($json_a as $arr)
{
$name = $arr['countryName'];
$query = "INSERT INTO countries(name) VALUES ('$name');";
mysqli_query($link,$query);
$country_id = mysqli_insert_id($link);
foreach ($arr['regions'] as $region)
{
$region_name = $region['name'];
$query = "INSERT INTO regions(country_id,name,created_at,updated_at) VALUES ($country_id,'$region_name',NOW(),NOW());";
mysqli_query($link,$query);
}
}
?>`
1条答案
按热度按时间toe950271#
“name”列的字符集和排序规则是什么?它是什么数据类型?我猜您没有使用json数据类型列和/或它不是utf8mb4。