File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/CronJobs/Ekisan/AutoDateUpdater.php
Back
<?php include_once("simple_html_dom.php"); include_once("Connection.php"); $curl = curl_init(); //Amreli curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=106', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Amreli New Date: ' .$date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Amreli';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Amreli Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Amreli';"; $result = $con->query($sql); echo '</br>AMRELI DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Amreli';"; $result = $con->query($sql); //Amreli Vegetable curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=33', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Amreli Vegetable New Date: ' .$date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Amreli Vegetable';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Amreli Vegetable Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Amreli Vegetable';"; $result = $con->query($sql); echo '</br>Amreli Vegetable DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Amreli Vegetable';"; $result = $con->query($sql); //Azadpur Delhi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=7', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Azadpur Delhi New Date: ' .$date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Azadpur Delhi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Azadpur Delhi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Azadpur Delhi';"; $result = $con->query($sql); echo '</br>Azadpur Delhi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Azadpur Delhi';"; $result = $con->query($sql); //Idar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=56', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Idar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Idar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Idar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Idar';"; $result = $con->query($sql); echo '</br>Idar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Idar';"; $result = $con->query($sql); //Unava curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=76', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Unava New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Unava';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Unava Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Unava';"; $result = $con->query($sql); echo '</br>Unava DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Unava';"; $result = $con->query($sql); //Unjha curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=89', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Unjha New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Unjha';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Unjha Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Unjha';"; $result = $con->query($sql); echo '</br>Unjha DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Unjha';"; $result = $con->query($sql); //Ankleshwar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=20', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Ankleshwar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Ankleshwar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Ankleshwar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Ankleshwar';"; $result = $con->query($sql); echo '</br>Ankleshwar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Ankleshwar';"; $result = $con->query($sql); //Anjar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=120', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Anjar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Anjar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Anjar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Anjar';"; $result = $con->query($sql); echo '</br>Anjar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Anjar';"; $result = $con->query($sql); //Ambliyasan curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=57', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Ambliyasan New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Ambliyasan';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Ambliyasan Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Ambliyasan';"; $result = $con->query($sql); echo '</br>Ambliyasan DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Ambliyasan';"; $result = $con->query($sql); //Kadi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=67', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Kadi New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Kadi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Kadi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Kadi';"; $result = $con->query($sql); echo '</br>Kadi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Kadi';"; $result = $con->query($sql); //Kalol curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=52', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Kalol New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Kalol';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Kalol Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Kalol';"; $result = $con->query($sql); echo '</br>Kalol DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Kalol';"; $result = $con->query($sql); //Kalavad curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=97', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Kalavad New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Kalavad';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Kalavad Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Kalavad';"; $result = $con->query($sql); echo '</br>Kalavad DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Kalavad';"; $result = $con->query($sql); //Kodinar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=108', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Kodinar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Kodinar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Kodinar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Kodinar';"; $result = $con->query($sql); echo '</br>Kodinar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Kodinar';"; $result = $con->query($sql); //Khedbramha curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=80', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Khedbramha New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Khedbramha';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Khedbramha Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Khedbramha';"; $result = $con->query($sql); echo '</br>Khedbramha DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Khedbramha';"; $result = $con->query($sql); //Khambhat curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=40', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Khambhat New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Khambhat';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Khambhat Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Khambhat';"; $result = $con->query($sql); echo '</br>Khambhat DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Khambhat';"; $result = $con->query($sql); //Godhra curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=39', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Godhra New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Godhra';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Godhra Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Godhra';"; $result = $con->query($sql); echo '</br>Godhra DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Godhra';"; $result = $con->query($sql); //Gondal curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=116', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Gondal New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Gondal';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Gondal Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Gondal';"; $result = $con->query($sql); echo '</br>Gondal DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Gondal';"; $result = $con->query($sql); //Gondal (Veg Yard) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=31', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Gondal (Veg Yard) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Gondal Vegetable';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Gondal (Veg Yard) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Gondal Vegetable';"; $result = $con->query($sql); echo '</br>Gondal (Veg Yard) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Gondal Vegetable';"; $result = $con->query($sql); //Gondal Fruit curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=32', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Gondal Fruit New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Gondal Fruit';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Gondal Fruit Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Gondal Fruit';"; $result = $con->query($sql); echo '</br>Gondal Fruit DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Gondal Fruit';"; $result = $con->query($sql); //Chanasma curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=48', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Chanasma New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Chanasma';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Chanasma Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Chanasma';"; $result = $con->query($sql); echo '</br>Chanasma DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Chanasma';"; $result = $con->query($sql); //Jasdan curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=98', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jasdan New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jasdan';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jasdan Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jasdan';"; $result = $con->query($sql); echo '</br>Jasdan DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jasdan';"; $result = $con->query($sql); //Jadar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=47', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jadar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jadar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jadar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jadar';"; $result = $con->query($sql); echo '</br>Jadar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jadar';"; $result = $con->query($sql); //Jamkhambhadiya curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=101', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jamkhambhadiya New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jamkhambhadiya';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jamkhambhadiya Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jamkhambhadiya';"; $result = $con->query($sql); echo '</br>Jamkhambhadiya DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jamkhambhadiya';"; $result = $con->query($sql); //Jamjodhpur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=103', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jamjodhpur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jamjodhpur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jamjodhpur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jamjodhpur';"; $result = $con->query($sql); echo '</br>Jamjodhpur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jamjodhpur';"; $result = $con->query($sql); //Jamnagar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=114', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jamnagar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jamnagar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jamnagar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jamnagar';"; $result = $con->query($sql); echo '</br>Jamnagar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jamnagar';"; $result = $con->query($sql); //Jetpur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=93', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jetpur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jetpur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jetpur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jetpur';"; $result = $con->query($sql); echo '</br>Jetpur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jetpur';"; $result = $con->query($sql); //Jotana curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=49', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Jotana New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Jotana';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Jotana Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Jotana';"; $result = $con->query($sql); echo '</br>Jotana DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Jotana';"; $result = $con->query($sql); //Junagadh curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=113', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Junagadh New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Junagadh';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Junagadh Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Junagadh';"; $result = $con->query($sql); echo '</br>Junagadh DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Junagadh';"; $result = $con->query($sql); //Tintoi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=62', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Tintoi New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Tintoi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Tintoi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Tintoi';"; $result = $con->query($sql); echo '</br>Tintoi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Tintoi';"; $result = $con->query($sql); //Deesa curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=84', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Deesa New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Deesa';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Deesa Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Deesa';"; $result = $con->query($sql); echo '</br>Deesa DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Deesa';"; $result = $con->query($sql); //Deesa (Bhildi) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=68', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Deesa (Bhildi) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Deesa (Bhildi)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Deesa (Bhildi) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Deesa (Bhildi)';"; $result = $con->query($sql); echo '</br>Deesa (Bhildi) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Deesa (Bhildi)';"; $result = $con->query($sql); //Deesa (Veg Yard) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=30', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Deesa (Veg Yard) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Deesa (Veg Yard)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Deesa (Veg Yard) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Deesa (Veg Yard)';"; $result = $con->query($sql); echo '</br>Deesa (Veg Yard) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Deesa (Veg Yard)';"; $result = $con->query($sql); //Talod curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=77', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Talod New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Talod';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Talod Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Talod';"; $result = $con->query($sql); echo '</br>Talod DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Talod';"; $result = $con->query($sql); //Talaja curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=111', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Talaja New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Talaja';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Talaja Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Talaja';"; $result = $con->query($sql); echo '</br>Talaja DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Talaja';"; $result = $con->query($sql); //Thara curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=63', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Thara New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Thara';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Thara Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Thara';"; $result = $con->query($sql); echo '</br>Thara DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Thara';"; $result = $con->query($sql); //Tharad curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=86', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Tharad New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Tharad';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Tharad Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Tharad';"; $result = $con->query($sql); echo '</br>Tharad DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Tharad';"; $result = $con->query($sql); //Dehgam curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=54', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Dehgam New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Dehgam';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Dehgam Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Dehgam';"; $result = $con->query($sql); echo '</br>Dehgam DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Dehgam';"; $result = $con->query($sql); //Dahod curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=36', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Dahod New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Dahod';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Dahod Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Dahod';"; $result = $con->query($sql); echo '</br>Dahod DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Dahod';"; $result = $con->query($sql); //Dahod (Veg Market) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=23', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Dahod (Veg Market) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Dahod (Veg Market)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Dahod (Veg Market) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Dahod (Veg Market)';"; $result = $con->query($sql); echo '</br>Dahod (Veg Market) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Dahod (Veg Market)';"; $result = $con->query($sql); //Diyodar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=44', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Diyodar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Diyodar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Diyodar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Diyodar';"; $result = $con->query($sql); echo '</br>Diyodar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Diyodar';"; $result = $con->query($sql); //Dhanera curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=81', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Dhanera New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Dhanera';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Dhanera Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Dhanera';"; $result = $con->query($sql); echo '</br>Dhanera DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Dhanera';"; $result = $con->query($sql); //Dhrol curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=105', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Dhrol New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Dhrol';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Dhrol Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Dhrol';"; $result = $con->query($sql); echo '</br>Dhrol DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Dhrol';"; $result = $con->query($sql); //Nasik curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=21', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Nasik New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Nasik';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Nasik Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Nasik';"; $result = $con->query($sql); echo '</br>Nasik DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Nasik';"; $result = $con->query($sql); //Nenava curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=53', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Nenava New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Nenava';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Nenava Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Nenava';"; $result = $con->query($sql); echo '</br>Nenava DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Nenava';"; $result = $con->query($sql); //Patan curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=87', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Patan New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Patan';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Patan Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Patan';"; $result = $con->query($sql); echo '</br>Patan DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Patan';"; $result = $con->query($sql); //Pathavada curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=71', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Pathavada New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Pathavada';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Pathavada Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Pathavada';"; $result = $con->query($sql); echo '</br>Pathavada DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Pathavada';"; $result = $con->query($sql); //Padra curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=25', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Padra New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Padra';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Padra Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Padra';"; $result = $con->query($sql); echo '</br>Padra DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Padra';"; $result = $con->query($sql); //Palanpur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=83', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Palanpur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Palanpur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Palanpur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Palanpur';"; $result = $con->query($sql); echo '</br>Palanpur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Palanpur';"; $result = $con->query($sql); //Petlad (Veg Yard) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=24', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Petlad (Veg Yard) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Petlad (Veg Yard)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Petlad (Veg Yard) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Petlad (Veg Yard)';"; $result = $con->query($sql); echo '</br>Petlad (Veg Yard) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Petlad (Veg Yard)';"; $result = $con->query($sql); //Porbandar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=100', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Porbandar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Porbandar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Porbandar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Porbandar';"; $result = $con->query($sql); echo '</br>Porbandar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Porbandar';"; $result = $con->query($sql); //Prantij curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=51', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Prantij New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Prantij';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Prantij Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Prantij';"; $result = $con->query($sql); echo '</br>Prantij DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Prantij';"; $result = $con->query($sql); //Bahucharaji curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=43', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bahucharaji New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bahucharaji';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bahucharaji Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bahucharaji';"; $result = $con->query($sql); echo '</br>Bahucharaji DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bahucharaji';"; $result = $con->query($sql); //Babra curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=91', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Babra New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Babra';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Babra Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Babra';"; $result = $con->query($sql); echo '</br>Babra DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Babra';"; $result = $con->query($sql); //Bavla curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=5', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bavla New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bavla';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bavla Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bavla';"; $result = $con->query($sql); echo '</br>Bavla DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bavla';"; $result = $con->query($sql); //Botad curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=109', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Botad New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Botad';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Botad Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Botad';"; $result = $con->query($sql); echo '</br>Botad DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Botad';"; $result = $con->query($sql); //Bhachau curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=119', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bhachau New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bhachau';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bhachau Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bhachau';"; $result = $con->query($sql); echo '</br>Bhachau DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bhachau';"; $result = $con->query($sql); //Bhabhr curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=65', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bhabhr New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bhabhr';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bhabhr Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bhabhr';"; $result = $con->query($sql); echo '</br>Bhabhr DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bhabhr';"; $result = $con->query($sql); //Bhavnagar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=107', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bhavnagar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bhavnagar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bhavnagar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bhavnagar';"; $result = $con->query($sql); echo '</br>Bhavnagar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bhavnagar';"; $result = $con->query($sql); //Bhuj curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=4', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Bhuj New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Bhuj';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Bhuj Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Bhuj';"; $result = $con->query($sql); echo '</br>Bhuj DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Bhuj';"; $result = $con->query($sql); //Mehsana curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=60', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mehsana New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mehsana';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mehsana Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mehsana';"; $result = $con->query($sql); echo '</br>Mehsana DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mehsana';"; $result = $con->query($sql); //Mehsana (Veg) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=29', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mehsana (Veg) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mehsana (Veg)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mehsana (Veg) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mehsana (Veg)';"; $result = $con->query($sql); echo '</br>Mehsana (Veg) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mehsana (Veg)';"; $result = $con->query($sql); //Mahuva curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=104', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mahuva New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mahuva';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mahuva Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mahuva';"; $result = $con->query($sql); echo '</br>Mahuva DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mahuva';"; $result = $con->query($sql); //Mansa curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=55', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mansa New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mansa';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mansa Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mansa';"; $result = $con->query($sql); echo '</br>Mansa DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mansa';"; $result = $con->query($sql); //Mansa Vegetable curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=27', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mansa Vegetable New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mansa Vegetable';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mansa Vegetable Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mansa Vegetable';"; $result = $con->query($sql); echo '</br>Mansa Vegetable DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mansa Vegetable';"; $result = $con->query($sql); //Mendarda curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=90', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mendarda New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mendarda';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mendarda Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mendarda';"; $result = $con->query($sql); echo '</br>Mendarda DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mendarda';"; $result = $con->query($sql); //Modasa curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=82', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Modasa New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Modasa';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Modasa Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Modasa';"; $result = $con->query($sql); echo '</br>Modasa DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Modasa';"; $result = $con->query($sql); //Morbi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=115', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Morbi New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Morbi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Morbi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Morbi';"; $result = $con->query($sql); echo '</br>Morbi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Morbi';"; $result = $con->query($sql); //Morbi Vegetable curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=34', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Morbi Vegetable New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Morbi Vegetable';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Morbi Vegetable Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Morbi Vegetable';"; $result = $con->query($sql); echo '</br>Morbi Vegetable DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Morbi Vegetable';"; $result = $con->query($sql); //Mandal curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=42', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Mandal New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Mandal';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Mandal Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Mandal';"; $result = $con->query($sql); echo '</br>Mandal DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Mandal';"; $result = $con->query($sql); //Rakhiyal curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=37', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Rakhiyal New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Rakhiyal';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Rakhiyal Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Rakhiyal';"; $result = $con->query($sql); echo '</br>Rakhiyal DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Rakhiyal';"; $result = $con->query($sql); //Rajkot curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=118', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Rajkot New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Rajkot';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Rajkot Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Rajkot';"; $result = $con->query($sql); echo '</br>Rajkot DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Rajkot';"; $result = $con->query($sql); //Rajkot Vegetable curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=35', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Rajkot Vegetable New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Rajkot Vegetable';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Rajkot Vegetable Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Rajkot Vegetable';"; $result = $con->query($sql); echo '</br>Rajkot Vegetable DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Rajkot Vegetable';"; $result = $con->query($sql); //Radhanpur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=70', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Radhanpur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Radhanpur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Radhanpur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Radhanpur';"; $result = $con->query($sql); echo '</br>Radhanpur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Radhanpur';"; $result = $con->query($sql); //Rapar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=121', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Rapar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Rapar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Rapar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Rapar';"; $result = $con->query($sql); echo '</br>Rapar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Rapar';"; $result = $con->query($sql); //Rah curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=78', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Rah New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Rah';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Rah Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Rah';"; $result = $con->query($sql); echo '</br>Rah DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Rah';"; $result = $con->query($sql); //Lakhani curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=88', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Lakhani New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Lakhani';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Lakhani Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Lakhani';"; $result = $con->query($sql); echo '</br>Lakhani DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Lakhani';"; $result = $con->query($sql); //Ladol curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=73', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Ladol New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Ladol';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Ladol Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Ladol';"; $result = $con->query($sql); echo '</br>Ladol DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Ladol';"; $result = $con->query($sql); //Vadgam curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=58', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vadgam New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vadgam';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vadgam Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vadgam';"; $result = $con->query($sql); echo '</br>Vadgam DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vadgam';"; $result = $con->query($sql); //Vadali curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=59', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vadali New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vadali';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vadali Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vadali';"; $result = $con->query($sql); echo '</br>Vadali DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vadali';"; $result = $con->query($sql); //Varahi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=46', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Varahi New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Varahi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Varahi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Varahi';"; $result = $con->query($sql); echo '</br>Varahi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Varahi';"; $result = $con->query($sql); //Vasna curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=26', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vasna New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vasna';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vasna Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vasna';"; $result = $con->query($sql); echo '</br>Vasna DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vasna';"; $result = $con->query($sql); //Veraval curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=92', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Veraval New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Veraval';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Veraval Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Veraval';"; $result = $con->query($sql); echo '</br>Veraval DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Veraval';"; $result = $con->query($sql); //Vijapur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=79', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vijapur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vijapur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vijapur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vijapur';"; $result = $con->query($sql); echo '</br>Vijapur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vijapur';"; $result = $con->query($sql); //Vijapur (Kukarvada) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=72', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vijapur (Kukarvada) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vijapur (Kukarvada)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vijapur (Kukarvada) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vijapur (Kukarvada)';"; $result = $con->query($sql); echo '</br>Vijapur (Kukarvada) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vijapur (Kukarvada)';"; $result = $con->query($sql); //Vijapur (Gojariya) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=69', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vijapur (Gojariya) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vijapur (Gojariya)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vijapur (Gojariya) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vijapur (Gojariya)';"; $result = $con->query($sql); echo '</br>Vijapur (Gojariya) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = ''Vijapur (Gojariya)';"; $result = $con->query($sql); //Vijapur (Veg) curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=28', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vijapur (Veg) New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vijapur (Veg)';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vijapur (Veg) Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vijapur (Veg)';"; $result = $con->query($sql); echo '</br>Vijapur (Veg) DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vijapur (Veg)';"; $result = $con->query($sql); //Viramgam curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=41', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Viramgam New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Viramgam';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Viramgam Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Viramgam';"; $result = $con->query($sql); echo '</br>Viramgam DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Viramgam';"; $result = $con->query($sql); //Visnagar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=66', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Visnagar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Visnagar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Visnagar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Visnagar';"; $result = $con->query($sql); echo '</br>Visnagar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Visnagar';"; $result = $con->query($sql); //Visavadar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=102', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Visavadar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Visavadar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Visavadar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Visavadar';"; $result = $con->query($sql); echo '</br>Visavadar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Visavadar';"; $result = $con->query($sql); //Vankaner curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=96', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Vankaner New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Vankaner';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Vankaner Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Vankaner';"; $result = $con->query($sql); echo '</br>Vankaner DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Vankaner';"; $result = $con->query($sql); //Shirohi curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=45', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Shirohi New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Shirohi';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Shirohi Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Shirohi';"; $result = $con->query($sql); echo '</br>Shirohi DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Shirohi';"; $result = $con->query($sql); //Salal curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=50', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Salal New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Salal';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Salal Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Salal';"; $result = $con->query($sql); echo '</br>Salal DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Salal';"; $result = $con->query($sql); //Sanand curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=38', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Sanand New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Sanand';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Sanand Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Sanand';"; $result = $con->query($sql); echo '</br>Sanand DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Sanand';"; $result = $con->query($sql); //Sami curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=61', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Sami New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Sami';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Sami Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Sami';"; $result = $con->query($sql); echo '</br>Sami DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Sami';"; $result = $con->query($sql); //Savarkundla curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=99', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Savarkundla New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Savarkundla';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Savarkundla Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Savarkundla';"; $result = $con->query($sql); echo '</br>Savarkundla DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Savarkundla';"; $result = $con->query($sql); //Siddhpur curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=75', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Siddhpur New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Siddhpur';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Siddhpur Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Siddhpur';"; $result = $con->query($sql); echo '</br>Siddhpur DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Siddhpur';"; $result = $con->query($sql); //Surat curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=6', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Surat New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Surat';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Surat Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Surat';"; $result = $con->query($sql); echo '</br>Surat DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Surat';"; $result = $con->query($sql); //Shihori curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=45', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Shihori New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Shihori';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Shihori Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Shihori';"; $result = $con->query($sql); echo '</br>Shihori DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Shihori';"; $result = $con->query($sql); //Halvad curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=117', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Halvad New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Halvad';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Halvad Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Halvad';"; $result = $con->query($sql); echo '</br>Halvad DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Halvad';"; $result = $con->query($sql); //Harij curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=74', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Harij New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Harij';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Harij Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Harij';"; $result = $con->query($sql); echo '</br>Harij DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Harij';"; $result = $con->query($sql); //Himatnagar curl_setopt_array($curl, array( CURLOPT_URL => 'http://www.agriscienceindia.in/web-service/?v=1.0&device-type=1&service=get-bajarbhav-of-district', 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 => 'district_id=85', CURLOPT_HTTPHEADER => array( 'content-type: application/x-www-form-urlencoded', 'content-length: 15', 'host: www.agriscienceindia.in', 'connection: Keep-Alive', 'accept-encoding: gzip', 'user-agent: okhttp/3.14.9', 'Cookie: PHPSESSID=895tcutujhtksgpqgpdq8d4117' ), )); $response = curl_exec($curl); $data = json_decode($response,TRUE); $date = $data["date"]; echo '</br></br>Himatnagar New Date: ' . $date; $sql = "SELECT `last_updated` AS 'DATE' FROM `gujarat_city` WHERE `ename` = 'Himatnagar';"; $result = $con->query($sql); $row = $result->fetch_assoc(); echo '</br>Himatnagar Old Date: ' . $row['DATE']; if ($date != $row['DATE']) { $sql = "UPDATE `gujarat_city` SET `last_updated` = '$date' WHERE `ename` = 'Himatnagar';"; $result = $con->query($sql); echo '</br>Himatnagar DATE UPDATED'; } //bhav $prices["Prices"] = array(); foreach($data['bhavs'] as $item) { $name = $item['pak_name']; $min = str_replace("₹ ","",$item['min_rate']); $max = str_replace("₹ ","",$item['max_rate']); $price = array( 'NAME'=>$name, 'MIN'=>$min, 'MAX'=>$max ); array_push($prices["Prices"],$price); } $prices["success"] = 1; $bhav = json_encode($prices,JSON_UNESCAPED_UNICODE); echo $bhav; $sql = "UPDATE `gujarat_city` SET `bhav` = '".$bhav."' WHERE `ename` = 'Himatnagar';"; $result = $con->query($sql); curl_close($curl); ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings