query($sql);
$row = $result -> fetch_assoc();
$link = $row['LINK'];
$pak_guj = $row['PAK_NAME_GUJ'];
$sql = "SELECT `name` AS 'ENG_NAME',`name_gj` AS 'GUJ_NAME' FROM `zone_wise_city`";
$result = $con->query($sql);
$CityGuj[""] = [];
while($row = $result -> fetch_assoc())
{
$CityGuj[$row['GUJ_NAME']] = $row['ENG_NAME'];
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-pak',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => array('pak_id' => $link),
));
$response = curl_exec($curl);
curl_close($curl);
$data = json_decode($response,TRUE);
$prices["Paks"] = array();
foreach($data['bhavs'] as $item) {
$name = $item["name"];
$min = str_replace("₹ ","",$item["min_rate"]);
$max = str_replace("₹ ","",$item["max_rate"]);
$date = explode(" ",$item["created_dt"]);
$datefull = explode("-",$date[0]);
$day = $datefull[2];
$month = $datefull[1];
$year = $datefull[0];
$newdate = $day.'-'.$month.'-'.$year;
$price = array(
'CITY_NAME_GUJ'=>$name,
'CITY_NAME_ENG'=>$CityGuj[$name],
'DATE'=>$newdate,
'PAK'=>$pak_guj,
'AVG_PRICE'=>intval(($max+$min)/2),
'MIN_PRICE'=>$min,
'MAX_PRICE'=>$max
);
array_push($prices["Paks"],$price);
}
$prices["success"] = 1;
ec