<?php
include ('session.php');
include('connection.php');
$i=1;
mysqli_query($GLOBALS["___mysqli_ston"], "set character_set_results='utf8'");
			$Comp_id="SELECT *  FROM `administrate` 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">name	</th>
    <th scope="col" align="center">name_eng</th>
    <th scope="col">padnam</th>
    <th scope="col">padnam_mar</th>
    <th scope="col">area</th>
    <th scope="col">area_mar</th>
    <th scope="col">contact </th>
    <th scope="col">email</th>
   <th scope="col">Update</th>';
echo '</tr>';

	while($rw2 = mysqli_fetch_assoc($res))
			{
	$srno = $rw2['srno'];
				$name =$rw2['officer_name_marathi'];
				$name_eng=$rw2['officer_name'];
				$padnam=$rw2['designation'];
				$padnam_mar	=$rw2['designation_marathi'];
				$taluka=$rw2['taluka'];
				$taluka_eng=$rw2['taluka_eng'];
				$area=$rw2['office_name_marathi'];
				$area_eng=$rw2['office_name'];
				$add=$rw2['add'];
				$add_eng	=$rw2['add_eng'];
				$contact=$rw2['mobile_no_marathi'];
				$email=$rw2['e-mail'];

				
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">'.$name.' </td>
     <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$name_eng.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$padnam.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$padnam_mar.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$area_eng.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$area.' </td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$contact.'</td>
    <td onclick="update_company('.$i.')" style="cursor:pointer" title="Click here for edit">'.$email.'</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 '</tr>';
  //		break;
								}

echo "

</table></font>



";		
	
	
	?>


<!--  <?php

include('connection.php');


echo '<br>';

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

$i=1;
			$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>";		
 ?>  -->







