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

<?php
$api_url = 'https://api.example.com/data'; // 替换为实际的API URL
$response = file_get_contents($api_url);
$data = json_decode($response, true); // 将JSON数据转换为关联数组
?>

<?php
$host = 'localhost';
$dbname = 'your_database';
$username = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}
?>

<?php
foreach ($data as $item) {
    $stmt = $pdo->prepare("INSERT INTO your_table (column1, column2, column3) VALUES (:column1, :column2, :column3)");
    $stmt->bindParam(':column1', $item['key1']);
    $stmt->bindParam(':column2', $item['key2']);
    $stmt->bindParam(':column3', $item['key3']);
    $stmt->execute();
}
echo "Data inserted successfully!";
?>