<?php
    include "../id/config.php";

    function getData($conn, $getIdLigaIndonesia) {
        $curl_options = array (
            CURLOPT_URL => "https://newsapi.org/v2/everything?q=liga+1&language=id&excludeDomains=bola.net&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");
        $fetchCekBerita = mysqli_fetch_assoc($cekBerita);
        $jumlahBerita = $fetchCekBerita['jumlah'];

        echo'<p>'. mysqli_error($conn).'</p>';
        echo "<p> SELECT COUNT(*) AS jumlah FROM berita WHERE sumber_web = '$sumber_web' AND judul = '$judul'</p>";
        /*
        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')");
        }
        */
    }

?>