JezK

Edit File: districts.php

<?php 
include('admin_functions.php');
if($_SESSION['username']=='')
{
	echo "<script>location.replace('index.php');</script>" ;
}   
$admin=new adm_functions();

$districts_data = $admin->get_alldistricts();
 $mandalas_data = $admin->get_allmandals();
 $cities_data = $admin->get_allcities();

$i=1;
   $j=1;
   $k=1;
   $l=1;
   $state_data = '';
   $dist_data = '';
   $mandala_data = '';
   $city_data = '';

foreach($districts_data as $k=>$val){
	   $id = (string)$val['id'];
	   
	$dist_data .= '<tr><td>'.$j.'</td>
					  <td>'.$val['statename'].'</td>
					  <td>'.$val['districtname'].'</td>
				      <td><a href="#"  data-toggle="modal"  data-target="#myModal2" onclick="updatecategory(\''.$id.'\',\''.$val['name_te'].'\',\''.$val['name_en'].'\')"><input type="button" class="btn btn-primary" value="Edit"></a>&nbsp;&nbsp;<a href="deletecategory.php?id='.$id.'"  data-toggle="modal" ><input type="button" class="btn btn-primary" value="Delete"></a>
                     
                      </td>
                   </tr>';
    $j++;
   }
   
  foreach($mandalas_data as $k=>$val){
	   $id = (string)$val['id'];
	   
	$mandala_data .= '<tr><td>'.$k.'</td>
					  <td>'.$val['district_id'].'</td>
					  <td>'.$val['mandalname'].'</td>
				      <td><a href="#"  data-toggle="modal"  data-target="#myModal2" onclick="updatecategory(\''.$id.'\',\''.$val['name_te'].'\',\''.$val['name_en'].'\')"><input type="button" class="btn btn-primary" value="Edit"></a>&nbsp;&nbsp;<a href="deletecategory.php?id='.$id.'"  data-toggle="modal" ><input type="button" class="btn btn-primary" value="Delete"></a>
                     
                      </td>
                   </tr>';
    $k++;
   }
      
  foreach($cities_data as $k=>$val){
	   $id = (string)$val['id'];
	   
	$city_data .= '<tr><td>'.$l.'</td>
					  <td>'.$val['mandal_id'].'</td>
					  <td>'.$val['cityname'].'</td>
				      <td><a href="#"  data-toggle="modal"  data-target="#myModal2" onclick="updatecategory(\''.$id.'\',\''.$val['name_te'].'\',\''.$val['name_en'].'\')"><input type="button" class="btn btn-primary" value="Edit"></a>&nbsp;&nbsp;<a href="deletecategory.php?id='.$id.'"  data-toggle="modal" ><input type="button" class="btn btn-primary" value="Delete"></a>
                     
                      </td>
                   </tr>';
    $l++;
   }
   
   	$currentPage='category_management';
   include"header.php" ?>
      <div class="main-panel">
		<nav class="navbar navbar-default">
            <div class="container-fluid">
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle">
                        <span class="sr-only">Toggle navigation</span>
                        <span class="icon-bar bar1"></span>
                        <span class="icon-bar bar2"></span>
                        <span class="icon-bar bar3"></span>
                    </button>
                    <a class="navbar-brand" href="#">Location Management</a>
                </div>
             </div>
                
			<div class="collapse navbar-collapse">
            </div>
        </nav>

<div class="content">
	  <div class="container-fluid">
  <ul class="nav nav-pills" style="background: #cfcfcf;
margin-bottom: 30px;">
    <li class="active"><a data-toggle="pill" href="#states">States</a></li>

<li><a data-toggle="pill" href="districts.php">Districts</a></li>
    <li><a data-toggle="pill" href="#mandals">Mandals</a></li>
    <li><a data-toggle="pill" href="#cities">Cities</a></li>
  </ul>
  
  <div class="tab-content col-md-12">

<div class="content table-responsive table-full-width">
                                <table class="table table-striped" id="example2">
                                    <thead>
                                        <th>S.No</th>
                                    	<th>State Name</th>
                                    	<th>District Name</th>
                                       	<th>Action</th>
                                    </thead>
                                    <tbody>
										<?php echo $dist_data; ?>
                                    </tbody>
                                </table>

</div>
    </div>
    <div id="mandals" class="tab-pane fade">
				<div align="center"><input type="button" class="btn btn-default  " value="Add" style="margin-bottom: -40px;"></div>

<div class="content table-responsive table-full-width">
                                <table class="table table-striped" id="example3">
                                    <thead>
                                        <th>S.No</th>
                                    	<th>District Name</th>
                                    	<th>Mandal Name</th>
                                    	<th>Action</th>
                                    </thead>
                                    <tbody>
										<?php echo $mandala_data; ?>
                                    </tbody>
                                </table>

</div>
    </div>
    <div id="cities" class="tab-pane fade">
				<div align="center"><input type="button" class="btn btn-default  " value="Add" style="margin-bottom: -40px;"></div>

<div class="content table-responsive table-full-width">
                                <table class="table table-striped" id="example4">
                                    <thead>
                                        <th>S.No</th>
                                    	<th>Mandala Name</th>
                                    	<th>City Name</th>
                                       	<th>Action</th>
                                    </thead>
                                    <tbody>
										<?php echo $city_data; ?>
                                    </tbody>
                                </table>

</div>
    </div>
  </div>
</div>
</div>
           
               
					  <div class="modal fade" id="myModal1" role="dialog">
						<div class="modal-dialog ">
						  <div class="modal-content">
							<div class="modal-header">
							  <button type="button" class="close" data-dismiss="modal">&times;</button>
							  <h4 class="modal-title">Add New Category</h4>
							</div>
							<div class="modal-body">
							  <form method="post" >
								<div class="form-group">
									<label for="name">Category Name(Telugu):</label>
									<input type="text" id="categoryname" name="categoryname" >
								
								</div>
								<div class="form-group">
									<label for="name">Category Name(English):</label>
									<input type="text" id="categoryname_english" name="categoryname_english" >
								
								</div>
								<div class="">
									<button type="submit" class="btn btn-primary" onclick="return validateadd()">Add</button>
									<a type="button" class="btn btn-danger" href="category_management.php">Cancel</a>
								</div>
								<input type="hidden" name="action" id="action" value="Save">
							  </form>
							</div>
							<div class="modal-footer">
							  <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
							</div>
						  </div>
						</div>
					  </div>
				  
					  <div class="modal fade" id="myModal2" role="dialog">
						<div class="modal-dialog ">
						  <div class="modal-content">
							<div class="modal-header">
							  <button type="button" class="close" data-dismiss="modal">&times;</button>
							  <h4 class="modal-title">Edit Category</h4>
							</div>
							<div class="modal-body">
							  <form method="post">
								<div class="form-group">
									<label for="name">Category Name:</label>
									
									<input type="text" name="editcategory" id="editcategory" class="form-control">
								</div>
										<div class="form-group">
									<label for="name">Category Name ENG:</label>
									
									<input type="text" name="editcategory_en" id="editcategory_en" class="form-control">
								</div>
								<div class="">
									<button type="submit" class="btn btn-primary">Update</button>
									<button type="button" class="btn btn-danger" data-dismiss="modal">Cancel</button>
								</div>
								<input type="hidden" name="action" id="action" value="update">
								<input type="hidden" name="categoryid" id="categoryid" value="">
							  </form>
							</div>
							<div class="modal-footer">
							  <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
							</div>
						  </div>
						</div>
					  </div>	  
   <?php include"footer.php" ?>
 
   <script>
$(document).ready(function() {
    $('#example').DataTable();
    $('#example2').DataTable();
    $('#example3').DataTable();
    $('#example4').DataTable();
})
function updatecategory(catid,catename,catenameen){
//	data-target="#myModal2"
document.getElementById('editcategory').value = catename;
document.getElementById('editcategory_en').value = catenameen;
document.getElementById('categoryid').value = catid;

}