db->where('id',$id)->get("personalDetails")->result() as $details){ $currentRank = $details->currentRankId; //get current rank exam and course status foreach($this->db->where('id',$currentRank)->get("ranksType")->result() as $detailsRankType){ $isExam = $detailsRankType->exam; $isCourse = $detailsRankType->course; } ?>

Name	firstName.' '.$details->middleName.' '.$details->lastName;?>
Mil No.	uniqueNumber;?>
Current Rank	Login_model->getRank($details->currentRankId);?> Promote
Unit	UserModel->getUnit($details->unit);?>
Gender	gender;?>
DOB	UserModel->convDate($details->dateOfbirth);?>
Mobile Number	phoneNumber;?>
Email	email;?>
Descipline	UserModel->getDesciplineDate($details->dateReported); if($dateDiff==1){ echo 'No warning form'; }else{ echo 'Warning form filled'; } ?>

db->where('userId',$id)->order_by('id','desc')->get("officerRanks")->result() as $detailsEmp){ ?>

Rank	Promotion Date	Action
Login_model->getRank($detailsEmp->rankId);?>	promotionDate)); echo $date;?>	Edit

db->where('userId',$id)->get("coursesAttended")->result() as $detailsCourses){ ?>

Course	Institution	Intake Number	Exam Score	Action
Login_model->getCourse($detailsCourses->courseId);?>	institution;?>	intakeNumber;?>	examScore;?>	Edit Delete

db->where('userId',$id)->get("officerExams")->result() as $detailsExam){ ?>

Examination	Examination Number	Results	Action
Login_model->getExam($detailsExam->examId);?>	examNumber;?>	results;?>	Edit Delete

db->where('userId',$id)->get("education")->result() as $detailsEdu){ ?>

Level	Programme	Institution	country	Date	Action
level;?>	programme;?>	institution;?>	country;?>	startDate.' To '.$detailsEdu->endDate;?>	Edit Delete