如何用php读取API数据并插入到MYSQL中

$url = 'API的URL地址';
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
curl_close($ch);

$data = json_decode($response, true); // 将JSON数据转换为PHP数组

$servername = '数据库服务器地址';
$username = '数据库用户名';
$password = '数据库密码';
$dbname = '数据库名';

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die('连接失败：' . $conn->connect_error);
}

// 插入数据
foreach ($data as $item) {
    $sql = "INSERT INTO 表名 (字段1, 字段2, ...) VALUES ('" . $item['字段1'] . "', '" . $item['字段2'] . "', ...)";
    if ($conn->query($sql) === true) {
        echo "数据插入成功";
    } else {
        echo "数据插入失败：" . $conn->error;
    }
}

$conn->close();