Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxview.php	520 B	-rw-r--r--
userinfo.php	6.11 KB	-rw-r--r--
userinfo_editor.php	7.45 KB	-rw-r--r--
userinfo_list.php	8.37 KB	-rw-r--r--
userinfo_pending.php	8.36 KB	-rw-r--r--

Code Editor : userinfo_editor.php

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

<div class="form-group">
                        <label class="col-md-4 control-label"> ব্যবহারকারীর নাম</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="username" required value="<?=$username?>">                        
                        </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" required name="mobileno" value="<?=$mobileno?>">                        
                        </div>
                    </div>
                    
					<div class="form-group">
                        <label class="col-md-4 control-label">পাসওর্য়াড</label>
                        <div class="col-md-6">
						   <input type="password" class="form-control" name="upassword" required value="<?=$upassword?>">                        
                        </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 districtoffice order by districtofficeName");
                            $stmt->execute();

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

if($numrows==0) exit('No rows');

?>
						 <select  name="districtoffice_id" id="districtoffice_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
                               while($row = $result->fetch_assoc())
								  { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$districtoffice_id){ echo "selected"; }?>><?=$row["districtofficeName"]?>
							 </option>
								<?php
								  }
								?> 
						</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();
                            $numrows=$result->num_rows;

if($numrows==0) exit('No rows');

?>
						 <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
								  }
								?> 
						</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 userrole");
                            $stmt->execute();

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

if($numrows==0) exit('No rows');

?>
						 <select  name="userrole_id" id="userrole_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
                               while($row = $result->fetch_assoc())
								  { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$userrole_id){ echo "selected"; }?>><?=$row["rolename"]?>
							 </option>
								<?php
								  }
								?> 
						</select>                        
                        </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='districtoffice_id']" ).change(function () {
    var districtoffice_id = $(this).val();

if(districtoffice_id) {

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

}else{
        $('select[name="office_id"]').empty();
    }
});
</script>
<?php
 include("../homepage/footer.php");
?>

${this.title}

Code Editor : userinfo_editor.php