使用 PHP 解码多个 JSON URL - Decoding multiple JSON URL's using PHP

Decoding multiple JSON URL's using PHP

本文关键字：JSON URL PHP 解码使用 | 更新日期: 2023-09-27

我正在使用YouTube API尝试将来自多个URL的JSON数据放入mySQL数据库中。我正在尝试在多个 JSON 链接上使用 json 解码器，目前我的代码删除了第一个数组并用第二个数组覆盖它。请注意，我不想使用 array_merge 函数，因为我想使用大约 6-7 个 json URL。如果你能非常具体，那也很棒，因为我对 php 很陌生。

$linkone = 'https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=25&playlistId={playlistID}&key={Key}';
$linktwo = 'https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=25&playlistId={PlaylistID}&key={Key}';

$content = file_get_contents($linkone);
$content2 = file_get_contents($linktwo);
$json = json_decode($content, true);

foreach($json['items'] as $row)
{
$title = $row['snippet']['title'];
$title = mysql_real_escape_string($title);
$description = $row['snippet']['description'];
$description = mysql_real_escape_string($description);
$publishedAt = $row['snippet']['publishedAt'];
$publishedAt = mysql_real_escape_string($publishedAt);
$high = $row['snippet']['thumbnails']['high']['url'];
$high = mysql_real_escape_string($high);
$sql = "INSERT INTO table(title, description, publishedAt, high) VALUES('".$title."','".$description."','".$publishedAt."','".$high."')";
if(!mysql_query($sql,$conn))
{
die('Error : ' . mysql_error());
}
}

$linkone = 'https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=25&playlistId={playlistID}&key={Key}';
$linktwo = 'https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=25&playlistId={PlaylistID}&key={Key}';
$jsonArray = array(
  json_decode(file_get_contents($linkone)),
  json_decode(file_get_contents($linktwo))
);
foreach($jsonArray as $json) {
  foreach($json['items'] as $row)
  {
    $title = $row['snippet']['title'];
    $title = mysql_real_escape_string($title);
    $description = $row['snippet']['description'];
    $description = mysql_real_escape_string($description);
    $publishedAt = $row['snippet']['publishedAt'];
    $publishedAt = mysql_real_escape_string($publishedAt);
    $high = $row['snippet']['thumbnails']['high']['url'];
    $high = mysql_real_escape_string($high);
    $sql = "INSERT INTO table(title, description, publishedAt, high)
      VALUES('".$title."','".$description."','".$publishedAt."','".$high."')";
    if(!mysql_query($sql,$conn))
    {
      die('Error : ' . mysql_error());
    }
  }
}