Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxselection.php	6.05 KB	-rw-r--r--
applicantlist.php	4.83 KB	-rw-r--r--
applicantlist_editor.php	8.62 KB	-rw-r--r--
applicantlist_list.php	7.01 KB	-rw-r--r--
applicantlist_manual.php	4.64 KB	-rw-r--r--
applicantlist_manual_editor.ph...	8.52 KB	-rw-r--r--
applicantlist_manual_list.php	6.67 KB	-rw-r--r--

Code Editor : ajaxselection.php

<?php
    session_start();
    include("../common/config.php");
    include("../common/functions.php");

$pimsid= $_REQUEST["q"];
?>
 <?php
// prepare and bind for Maximum Number
$stmt = $conn->prepare("SELECT g.*, em.craddress, em.pmaddress, u.mobileno, u.uname FROM general g 
                          LEFT JOIN empaddress em ON(g.GovtId = em.GovtId)
                          LEFT JOIN userinfo u ON(g.userinfo_id  = u.id)
                        WHERE g.GovtId = ?");
$stmt->bind_param("i",$pimsid);
$stmt->execute();

//Result
$result = $stmt->get_result();

while($row = $result->fetch_assoc()){
    $district_id = $row["district_id"];
    $office_id = $row["office_id"];
    $NameB = $row["NameB"];
    $NationalID = $row["NationalID"];
    $designation_id = $row["designation_id"];
    $craddress = $row["craddress"];	
    $pmaddress = $row["pmaddress"];	
    $uname = $row["uname"];
    $mobileno = $row["mobileno"];				
}

if(empty($craddress)){
    $craddress=$pmaddress;
}
?>

<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");
                                    $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">এনআইডি(NID)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="nidcard" value="<?=$NationalID?>">                        
                        </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 designation");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="designation_id" id="designation_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$designation_id){ echo "selected"; }?>><?=$row["DesignationName"]?>
							 </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 office");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="office_id" id="office_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$office_id){ echo "selected"; }?>><?=$row["OfficeName"]?>
							 </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="address" required value="<?=$craddress?>">                        
                        </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="mobileno" required value="<?=$mobileno?>">                        
                        </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="email" value="<?=$uname?>">                        
                        </div>
                    </div>

${this.title}

Code Editor : ajaxselection.php