<?php 
error_reporting(0);
include("common.php"); 
include("config.php");  
                                  $id = $_GET[id];
								 $r7 = sprintf("SELECT * from  city WHERE  id = '$id'");
								 $resdata7 = $conn->query($r7);
								$row=mysqli_fetch_assoc($resdata7);
								 $dsid = $row[district_id];		
								$q19="select * from district where id='$dsid'";
    $r19 = $conn->query($q19);
    $r=mysqli_fetch_assoc($r19);
?>
  <script>
setTimeout(function(){ 
    $('#myData').hide();
}, 3000);
</script>

        <!-- START: Template CSS-->
        <link rel="stylesheet" href="dist/vendors/bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.theme.min.css">
        <link rel="stylesheet" href="dist/vendors/simple-line-icons/css/simple-line-icons.css">        
        <link rel="stylesheet" href="dist/vendors/flags-icon/css/flag-icon.min.css"> 
        <link rel="stylesheet" href="dist/vendors/flag-select/css/flags.css">
        <!-- END Template CSS-->   

        <!-- START: Page CSS-->
        <link rel="stylesheet" href="dist/vendors/quill/quill.snow.css" />
        <!-- END: Page CSS-->

        <!-- START: Custom CSS-->
        <link rel="stylesheet" href="dist/css/main.css">
        <!-- END: Custom CSS-->
  

 

        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: Breadcrumbs-->
                <div class="row ">
                    <div class="col-12  align-self-center">
                        <div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
                            	<?php if($_GET[id]==""){?>
                            <div class="w-sm-100 mr-auto"><h5 class="mb-0">Manage Taluka</h5></div>
						<?php } else {?>
						 <div class="w-sm-100 mr-auto"><h5 class="mb-0">Update Taluka</h5></div>
						<?php } ?>
                         <?php
						           if($_GET[flag]=="del") {?>
										<center><div style="font-size:16px;" id="myData" >
										<span class="label label-success">
										<font color="red">Record deleted successfully!</font></span></font></div></center>	<br/>	
										<?php }
										
										if($_GET[flag]=="dn") {?>
										<center><div style="font-size:16px;" id="myData" >
										<span class="label label-success">
										<font color="green">Record added successfully!</font></span></font></div></center>	<br/>	
										<?php }
										
										if($_GET[flag]=="up") {?>
										<center><div style="font-size:16px;" id="myData" >
										<span class="label label-success">
										<font color="blue">Record updated successfully!</font></span></font></div></center>	<br/>	
										<?php }
						?>
                        </div>
                    </div>
                </div>
                <!-- END: Breadcrumbs-->

                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-12 col-sm-12 mt-3">
                        <div class="card">
                            <div class="card-body">
                               <form class="form-row" action="submit-city.php" method="post" enctype="multipart/form-data">
                                 	
							<div class="form-group col-md-4">
                      <td style="width:3%"> State Name <font color="red">*</font> </td>		
								 <td><select  class="form-control" name="state"  id="state" onchange="one_id('ajax.php','cat_change_n','state','change_cat');" >
<option value="" style="background-color:#A9E2F3">- Select -</option>
<?php 
$sql1=sprintf("select * from state  ORDER BY id");
$rowptdata = $conn->query($sql1);
 while($metadatatyp = mysqli_fetch_assoc($rowptdata)){	?>
<option value="<?php echo $metadatatyp[id];?>" <?php  if($metadatatyp['id']==$row['state_id']){echo 'selected="selected"';}?>>
<?php echo stripslashes($metadatatyp[state]);?></option>
<?php }?>
 </select>	 </td>
		 </div>							
									 <div class="form-group col-md-4">
                      <td style="width:3%"> District Name <font color="red">*</font> </td>
					   <span id="cat_change_n" > 
                      <td>  <input type="text" class="form-control" value="<?php echo $r[district_name];?>" placeholder="Enter" required name="district"></td>
					  </span>
                     </div>
					 <br>
					 
					 <div class="form-group col-md-4">
                      <td style="width:3%"> Taluka Name <font color="red">*</font> </td>
                      <td>  <input type="text" class="form-control" value="<?php echo $row[city];?>" placeholder="Enter" required name="city"></td>
                     </div>
					 <br>
									 
													<div class="form-group col-md-12">
                                                        
                                                        <button type="submit"  class="btn5" > Submit  </button>
														 <?php $id = $row[id]; if($id==""){?>
								<input type="hidden" value="add" name="mode" >
								<?php }else{?>
								<input type="hidden" value="<?php echo $id;?>" name="id" >
								<?php }?>  
                                                    </div>
                                </form>
                            </div>
                        </div> 

                    </div>
                </div>
                <!-- END: Card DATA-->
				
                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                            <div class="card-header  justify-content-between align-items-center">                               
                                <h4 class="card-title"> Manage District wise Taluka List</h4> 
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-bordered" >
                                        <thead>
                                            <tr>
											 <th>Sr</th>
											  <th>State Name</th>
											 <th>District Name</th>
											 <th>Taluka Name</th>
											  <th> Action</th>
											 </tr>
                                        </thead>
                                        <tbody>
										<?php
										error_reporting(0);
										include("config.php");
									 $query="select * from city order by id desc";
    $result = $conn->query($query);
    while($prow=mysqli_fetch_assoc($result)){
		$count ++;
		$ssid = $prow[state_id];
        $dsid = $prow[district_id];		
	$q="select * from state where id='$ssid'";
    $r = $conn->query($q);
    $rr=mysqli_fetch_assoc($r);
	
	$q1="select * from district where id='$dsid'";
    $r1 = $conn->query($q1);
    $rr1=mysqli_fetch_assoc($r1);
	?>
                                            <tr>
										
						<td><?php echo $count;?></td>
						         <td><?php echo ucfirst($rr[state]);?></td>
						
                                                <td><?php echo ucfirst($rr1[district_name]);?></td>
												<td><?php echo ucfirst($prow[city]);?></td>
												
        <td> 
												<!-- <a href="add-city.php?id=<?php echo $prow[id];?>"><i class="fa fa-edit"></i></a>
												 &nbsp; &nbsp; &nbsp;-->
												 <a class="btn3" title="delete" href="submit-city.php?flag=del&id=<?php echo $prow[id];?>"onclick="if(confirm('Do You Want To Delete This ?')){return true;}else{return false;}">
                <i class="fa fa-trash icon-white"></i>
                 
            </a>
                 </td>  
                                            
                                             
                                            </tr>
	<?php } ?>
                                          
                                           
                                        </tbody>
                            
                                    </table>
                                </div>
                            </div>
                        </div> 

                    </div>                  
                </div>
            </div>
        </main>
        <!-- END: Content-->

      
        <!-- START: Back to top-->
        <a href="#" class="scrollup text-center"> 
            <i class="icon-arrow-up"></i>
        </a>
        <!-- END: Back to top-->

        <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
        <script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>    
 
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/quill/quill.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->
        <script src="dist/js/mail.script.js"></script>
        <!-- END: Page Script JS-->
		<style>
		.btn5{
			padding:2px;
			background-color:#fc2210;
			color:#fff;
			border-radius:2px;
			padding-left:10px;padding-right:10px;
			border:2px solid #fc2210;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:220px;	
			
		}
		</style>
		<script src="js/ajax.js"></script>		
    </body>
   
</html>
