File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/eKisan/API/GetPakDetails.php
Back
<?php if(isset($_GET['id'])) { require_once('Connection.php'); $sql = "SELECT `pak_link` AS 'LINK',`pak_name_guj` AS 'PAK_NAME_GUJ' FROM `pak_table` WHERE `pak_id` = ".$_GET['id']; $result = $con->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; echo json_encode($prices,JSON_UNESCAPED_UNICODE); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.07 |
proxy
|
phpinfo
|
Settings