php—当我将json文件写入数据库时,会与字符混淆

9ceoxa92  于 2021-06-24  发布在  Mysql
关注(0)|答案(1)|浏览(273)

“此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);
    }
}
?>`
toe95027

toe950271#

“name”列的字符集和排序规则是什么?它是什么数据类型?我猜您没有使用json数据类型列和/或它不是utf8mb4。

相关问题