Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxview.php	510 B	-rw-r--r--
empaddress.php	3.58 KB	-rw-r--r--
empaddress_editor.php	6.32 KB	-rw-r--r--
empaddress_list.php	6.36 KB	-rw-r--r--
view.php	2.8 KB	-rw-r--r--

Code Editor : empaddress_editor.php

<?php
 include("../homepage/header.php");
 include("../homepage/headermenu.php");

<div class="container fullheight">
    <div class="row">
        <div class="col-md-8 col-md-offset-2">
           <br/>
           <div><font class="headline">স্থায়ী ও বর্তমান ঠিকানা যোগ করুন</font></div>
           <div style="background-color: #ff0000;height: 2px">&nbsp;</div>

<div align="right"><a href="empaddress.php?cmd=list">লিস্ট দেখুন</a></font></div>

<div class="div-ln">
           <br/>
              <form name="frm_empaddress" method="post"  enctype="multipart/form-data" class="form-horizontal">
			           
			  
					<div class="form-group">
                        <label class="col-md-4 control-label">স্থায়ী জেলা</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM district ORDER BY DistrictName");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="district_id" id="district_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$district_id){ echo "selected"; }?>><?=$row["DistrictName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">স্থায়ী উপজেলা/থানা</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM upazila ORDER BY UpazilaName");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="upazila_id" id="upazila_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$upazila_id){ echo "selected"; }?>><?=$row["UpazilaName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                <label class="col-md-4 control-label">থানা/উপজেলা অন্যকিছু হলে লিখুন</label>
                <div class="col-md-6">
                    <input type="text" class="form-control" name="upthana" value="<?=$upthana?>">                        
                </div>
            </div>
                    
                    
					<div class="form-group">
                        <label class="col-md-4 control-label">স্থায়ী ঠিকানা</label>
                        <div class="col-md-6">
                         <textarea class="form-control" rows="4" required name="pmaddress"><?=$pmaddress?></textarea>     						                      
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান ঠিকানা</label>
                        <div class="col-md-6">
                          <textarea class="form-control" rows="4"  name="craddress"><?=$craddress?></textarea>    
						                  
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">টেলিফোন নং</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="telephone" value="<?=$telephone?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">মোবাইল নং</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="mobile" value="<?=$mobile?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                          <div class="col-md-6 col-md-offset-4">
						  <input type="hidden" name="cmd" value="add">
				          <input type="hidden" name="id" value="<?=$Id?>">	
                          <button type="submit" class="btn btn-primary">
                           <i class="fa fa-btn fa-sign-in"></i>Submit
                           </button>
                          </div>
                     </div>

</form>
           </div>
        </div>
    </div>
</div>
<script>
$( "select[name='district_id']" ).change(function () {
    var district_id = $(this).val();

if(district_id) {

$.ajax({
            url: "ajaxview.php",
            dataType: 'Json',
            data: {'district_id':district_id},
            success: function(data) {
                $('select[name="upazila_id"]').empty();
                $('select[name="upazila_id"]').append('<option value=""> --Select-- </option>');
                $.each(data, function(key, value) {                    
                    $('select[name="upazila_id"]').append('<option value="'+ key +'">'+ value +'</option>');
                });
            }
        });

}else{
        $('select[name="upazila_id"]').empty();
    }
});
</script>

<?php
 include("../homepage/footer.php");
?>

${this.title}

Code Editor : empaddress_editor.php