MAINHACK

Viewing / Editing File: add_location.php

<?php
include('header.php');

?>
<style type="text/css">

#fli,#fli1
	{
	width: 79%;
height: 42px;
	}
	#display
	{
		position:absolute;
		width:303;
		margin-left:0;
		margin-top:0;
	
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show11,.show12
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:13px; 
		
	}
	
	.show11:hover,.show1:hover
	{
		background:#1da1f2;
		color:#000;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}

</style>
<script>
function get_sub_category_name()
{
	var category_id = $('#district').val();
	 $.ajax({
        type: "POST",
        url: "ajax_check.php", // Name of the php files
        data: "district="+category_id,
        success: function(html)
        {
            $("#show").html(html);
			document.getElementById("hide_k").style.display="none";
        }
    });
} 
</script>
		<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
			<div class="row">	
<div class="col-md-6">
<div class="card">
	<div class="card-header">
		<div class="card-title">Add Location</div>
	</div>
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" >

<div class="card-body">
		    <div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">District Name <span class="required-label">*</span></label>
				<div class="col-lg-8 col-md-9 col-sm-8">
				    	<select class="form-control" id="district"  onChange="get_sub_category_name();" name="district">
					 <option value="">District Name</option>
      
        <?php
       // $table1='designation';
        //$sq="select * from designation where position>$position and position<=8";
        //$stmt=$con->prepare($sq);
       // $stmt->execute();
       $table="district";
       $stmt=$show->readAll_clause('city','group by district order by id asc');
        $num=$stmt->rowCount();
        if($num>0){
        while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row['district']."'>".$row['district']."</option>";	}
        
        }
        
        ?>
					    
					</select>
				</div>
			</div>
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">City</label>

<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">Location Name <span class="required-label">*</span></label>
				<div class="col-lg-8 col-md-9 col-sm-8">
					<input type="text" class="form-control" name="locality" placeholder="Location Name " required>
				</div>
			</div>
			
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">Pincode <span class="required-label">*</span></label>
				<div class="col-lg-8 col-md-9 col-sm-8">
					<input type="number" steps="any" class="form-control" name="pincode"  placeholder="Pincode " required>
				</div>
			</div>
		<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
					<button class="btn btn-danger">Cancel</button>
				</div>										
			</div>
		</div>

</div>
</form>
</div>	
</div>

<?php
if(isset($_POST['sub'])){
  $sq=$con->prepare("select id from district where locality='".$_POST['locality']."' and pincode='".$_POST['pincode']."'");
   $sq->execute();
   $c=$sq->rowCount();
   if($c>0){
       echo '<script>
        setTimeout(function() {
        swal({
            title: "oops!",
            text: "Locality and pincode exists",
            type: "error"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
   }else{  
      $data = array(
    'locality' => htmlentities(strip_tags($_POST['locality'])), 
    'district' => htmlentities(strip_tags($_POST['district'])), 
    'pincode' => htmlentities(strip_tags($_POST['pincode'])), 
     'city' => htmlentities(strip_tags($_POST['city'])), 
   
    );
	
 if($show->insert('district',$data)){
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "Location has been added",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
 //echo "<script>swal('Thank you for Registration.');window.location.href='".$_SERVER['request_uri']."';</script>";
 }   
}
}?>    
   	
<div class="col-md-6">							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
											<h5 class="page-title">All Locations</h5>

<table id="basic-datatables" class="display table table-striped table-hover">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Locality</th>
								  <th>District</th>
								  <th>City</th>
								  <th>Pincode</th>
								
								  <th>Delete</th>
								</tr>
							    </thead>
							   <tbody>

<?php
			
$sr='district';
$stmt =$show->readAll($sr);
$num = $stmt->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];       
     
								echo "<tr>
							    <td>$count</td>
								<td>".$row['locality']."</td>								
								<td>".$row['district']."</td>								
								<td>".$row['city']."</td>								
								<td>".$row['pincode']."</td>								
								"
 								;
 								?>
 							<td>
							<button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove">
							<a href="delete_menu.php?id=<?=$id?>&table=<?=$sr?>&url=<?=$_SERVER['REQUEST_URI']?>"  class="btn btn-link btn-danger"onclick="return send();"><i class='la la-times'></i></a>	
							</button>
							</td>
								<?php echo"</tr>";

++$count;
 }
}

?>							
</tbody></table>								
									
									</div>
				
									</div>
								</div>
	</div>
  
		
			</div>
			</div>
		
		
		<?php 
		
		include('footer.php');
		?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_location.php

Server Info

System Features

User Info