Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "../id/config.php";
- function getData($conn, $getIdLigaIndonesia) {
- $curl_options = array (
- CURLOPT_URL => "https://newsapi.org/v2/everything?q=liga+1&language=id&apiKey=29fefd8f54de441fa6a8cc60f9f1822f",
- CURLOPT_RETURNTRANSFER => true,
- CURLOPT_HEADER => false,
- CURLOPT_TIMEOUT => 30,
- CURLOPT_CONNECTTIMEOUT => 5
- );
- $curl = curl_init();
- curl_setopt_array($curl, $curl_options);
- $result = curl_exec($curl);
- $result = (array) json_decode($result);
- $artikel = $result['articles'];
- return $artikel;
- }
- $idLigaIndonesiaQuery = mysqli_query($conn, "SELECT id FROM kategori WHERE nama = 'Liga Indonesia'");
- $fetchLigaIndonesia = mysqli_fetch_assoc($idLigaIndonesiaQuery);
- $getIdLigaIndonesia = $fetchLigaIndonesia['id'];
- $dataBerita = getData($conn, $getIdLigaIndonesia);
- //echo '<pre>',var_dump($dataBerita),'</pre>';
- foreach ($dataBerita as $key => $value) {
- $sumber_web = $value->source->name;
- $judul = $value->title;
- $penulis = $value->author;
- $deskripsi = $value->description;
- $link = $value->url;
- $image = $value->urlToImage;
- $tgl_publish = $value->publishedAt;
- $kontenBerita = $value->content;
- $cekBerita = mysqli_query($conn, "SELECT COUNT(*) AS jumlah FROM berita WHERE sumber_web = '$sumber_web' AND judul = '$judul' AND id_kategori = '$getIdLigaIndonesia'");
- $fetchCekBerita = mysqli_fetch_assoc($cekBerita);
- $jumlahBerita = $fetchCekBerita['jumlah'];
- if($jumlahBerita == 0) {
- $inputBeritaQuery = mysqli_query($conn, "INSERT INTO berita (id, id_kategori, sumber_web, judul, penulis, deskripsi, url, gambar, tgl_publish, isi_berita) VALUES (NULL, '$getIdLigaIndonesia', '$sumber_web', '$judul', '$penulis', '$deskripsi', '$link', '$image', '$tgl_publish', '$kontenBerita')");
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement