<?php

include('connection.php');


echo '<br>';

echo '<h4 align="center">गट विकास अधिकारी (जिल्हा पालघर)<h4>';

$i=1;
mysqli_query($GLOBALS["___mysqli_ston"], "set character_set_results='utf8'");
			$Comp_id="SELECT *  FROM `administrate1` order by srno";
			//limit $cps, $rpp 
$res=mysqli_query($GLOBALS["___mysqli_ston"], $Comp_id) or die('Query Failed: 4' . mysqli_error($GLOBALS["___mysqli_ston"]));
		
echo 
"<font size='2'><table border='1' bgcolor='white' style='border-style: solid; border-width: 1px;width:100%;height:50%;'>";

echo '<tr>

    <th scope="col" align="center">srno</th>
    <th scope="col" align="center">srno Marathi</th>
            <th scope="col" align="center">Date</th>
    <th scope="col" align="center">Office Name</th>
    <th scope="col" align="center">Office Name Marathi</th>

    <th scope="col">Officer Name</th>
    <th scope="col">Officer Name Marathi</th>
    <th scope="col">Phone No </th>
    <th scope="col">Phone No in Marathi</th>
    <th scope="col">Mobile No</th>
    <th scope="col">Mobile No in Marathi</th>

<th scope="col">Status</th>
    <th scope="col">last Modified Date</th>
        <th scope="col">Update</th> 
        <th scope="col">Disable</th> 
  
    ';

echo '</tr>';

	while($rw2 = mysqli_fetch_assoc($res))
			{
				$srno=$rw2['srno'];
				$srno1=$rw2['srno_marathi'];
				$date=$rw2['date'];
$office=$rw2['office_name'];
$office1=$rw2['office_name_marathi'];
//echo $office;

$officer=$rw2['officer_name'];
$officer1=$rw2['officer_name_marathi'];

$phone=$rw2['phoneno'];
$phone1=$rw2['phone_marathi'];

$no=$rw2['mobileno'];
$no1=$rw2['mobile_no_marathi'];

$status=$rw2['Status'];
$last=$rw2['L_M_date'];



					
				
echo ' <tr>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$srno.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$srno1.' </td>
            <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$date.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$office.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$office1.' </td>

    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$officer.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$officer1.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$phone.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$phone1.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$no.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$no1.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$status.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$last.'</td>';
  $i++;
echo "<td><button type='button' style='margin-left:0px;width:6em;' value='update' class='submit' onclick='update_company(".$srno .")'/>Update</button></td>";
echo "<td><button type='button' style='margin-left:0px;width:6em;' onclick='view5(".$srno.")'/>Disable</button></td>";
echo '</tr>';
  //		break;
								}

echo "</table></font>";		
 ?>  
