File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/backup2609/APPS/eKisan/API/Demo/pak.php
Back
<?php include_once("simple_html_dom.php"); include_once("Connection.php"); $html = file_get_html("https://agriplus.in/prices/ajwan/gujarat"); $tbody = $html->find('tbody',0); $sql = "SELECT `agri_name` AS 'AGRI_NAME',`eng_name` AS 'ENG_NAME',`guj_name` AS 'GUJ_NAME' FROM `gujarat_yard_name`"; $sql2 = "SELECT `agri_pak_name` AS 'AGRI_NAME',`pak_name_guj` AS 'GUJ_NAME' FROM `pak_name`"; $result = $con->query($sql); $result2 = $con->query($sql2); $monthsArr = ["Jan" => "01","Fab" => "02", "Mar" => "03","Apr" => "04", "May" => "05","Jun" => "06", "Jul" => "07","Aug" => "08", "Sep" => "09","Oct" => "10", "Nov" => "11","Dec" => "12"]; $CityGuj[""] = []; $CityEng[""] = []; while($row = $result -> fetch_assoc()) { $CityGuj[$row['AGRI_NAME']] = $row['GUJ_NAME']; $CityEng[$row['AGRI_NAME']] = $row['ENG_NAME']; } $PakGuj[""] = []; while($row = $result2 -> fetch_assoc()) { $PakGuj[$row['AGRI_NAME']] = $row['GUJ_NAME']; } $con-> close(); echo '<table border="1"> <thead> <tr> <th>MARKET ENG</th> <th>MARKET GUJ</th> <th>VARIETY</th> <th>MIN PRICE</th> <th>MAX PRICE</th> <th>MODAL PRICE</th> <th>DATE</th> </tr> </thead>'; echo '<tbody>'; foreach($tbody->find('tr') as $tr) { echo '<tr>'; echo '<td>'; $name = $tr->find('td', 3)->plaintext; echo $CityEng[$name]; echo '</td>'; echo '<td>'; $name = $tr->find('td', 3)->plaintext; echo $CityGuj[$name]; echo '</td>'; echo '<td>'; $vari = $tr->find('td', 5)->plaintext; echo $PakGuj[$vari]; echo '</td>'; echo '<td>'; $min = $tr->find('td', 6)->plaintext; echo (int)($min/5); echo '</td>'; echo '<td>'; $max = $tr->find('td', 7)->plaintext; echo (int)($max/5); echo '</td>'; echo '<td>'; $model = $tr->find('td', 8)->plaintext; echo (int)($model/5); echo '</td>'; echo '<td>'; $dayMonth = explode(" ",$tr->find('td', 9)->plaintext); $day = $dayMonth[0]; $month = $monthsArr[$dayMonth[1]]; if($day < 10) $date = "0".$day."/".$month."/".date("Y"); else $date = $day."/".$month."/".date("Y"); echo $date; echo '</td>'; echo '</tr>'; } echo '</tbody>'; echo '</table>'; ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings