<META NAME="robots" CONTENT="noindex,nofollow">


<?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>';
   