<?php
$path = $_SERVER['DOCUMENT_ROOT'];
include $path . '/connect_db.php';

$res_google_suggest = $connect->query("SELECT * FROM google_suggest WHERE `volume` = 0 LIMIT 1");

if ($res_google_suggest->num_rows > 0) {
    while ($row = $res_google_suggest->fetch_assoc()) {
        $keyword = $row['keyword'];
        $keyword_id = $row['id'];
        $keyword = str_replace(" ","%20", $keyword);
        echo $keyword . "<br>";
        $volume_request = send_req($keyword);
        $volume_request_arr = json_decode($volume_request, true);

        echo "<pre>";
        print_r($volume_request_arr);

    }
}else{
    echo "No data";
}

function send_req($keyword){
    $curl = curl_init();

    curl_setopt_array($curl, [
        CURLOPT_URL => "https://seo-keyword-research.p.rapidapi.com/keynew.php?keyword=$keyword&country=us",
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_ENCODING => "",
        CURLOPT_MAXREDIRS => 10,
        CURLOPT_TIMEOUT => 30,
        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        CURLOPT_CUSTOMREQUEST => "GET",
        CURLOPT_HTTPHEADER => [
            "X-RapidAPI-Host: seo-keyword-research.p.rapidapi.com",
            "X-RapidAPI-Key: 8a6851c9c1mshab5807841fb7c40p102705jsn9f17ab591e41"
        ],
    ]);

    $response = curl_exec($curl);
    $err = curl_error($curl);

    curl_close($curl);

    if ($err) {
        echo "cURL Error #:" . $err;
        return false;
    } else {
        return $response;
    }
}
?>