File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/CronJobs/Ekisan/jamnagar.php
Back
<?php include_once("simple_html_dom.php"); include_once("Connection.php"); //Jamnagar $html= file_get_html("https://docs.google.com/spreadsheets/d/e/2PACX-1vRziqkMSmenkbKrNZD9YJn0_ik607ne8tAKT8x-NMgUU8UlKCUdWp6pwksEPunLV2NLkm83UzMue5Vh/pubhtml/sheet?headers=false&gid=0"); $datefull = $html->find('td', 7)->plaintext; $date= explode(" ", $datefull); $date= explode("-", $date[1]); if ($date[0] < 10) $day = '0' . $date[0]; else $day = $date[0]; if($date[1] < 10) $month = '0'.$date[1]; else $month = $date[1]; $year = $date[2]; $date = $day . '/' . $month . '/' . $year; 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'; } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings