Gecko [ 43.229.15.234 ]

Name	Size	Permission
promotion.php	5.11 KB	-rw-r--r--
promotion_editor.php	10.24 KB	-rw-r--r--
promotion_list.php	7.86 KB	-rw-r--r--
view.php	5.03 KB	-rw-r--r--

Code Editor : view.php

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

if(empty($_SESSION["username"])) 
{
  Header("Location: ../login/login.php");
 }	
 		 
 $GovtId= $_REQUEST['GovtId'];
 
 $stmt = $conn->prepare("SELECT 
                             	pr.id,
                                GovtId,
                                d.DesignationName,
                                pr.experiance,
                                ex.PexampassName,
                                pr.apointDate,
                                psc.PscrecomName,
                                pr.pscDate,
                                pr.sarokNo,
                                pr.permDate,
                                sg.GradeName,
                                pr.timesDate,
                                sd.FlagName
                                
                        FROM promotion pr
                            LEFT JOIN designation d ON(pr.designation_id=d.id)	
                            LEFT JOIN selectiongrade sd ON(pr.selectiongrade_id=sd.id)	
                            LEFT JOIN pexampass ex ON(pr.pexampass_id=ex.id)	
                            LEFT JOIN pscrecom psc ON(pr.pscrecom_id=psc.id)	
                            LEFT JOIN grade sg ON(pr.sgrade_id=sg.id)	
                        WHERE pr.GovtId= ?");

$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

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

?>
<div class="container fullheight">
    <div class="row">
        <div class="col-md-12">
            <br>

<div class="row">
              <div class="col-md-12">
              <h4> পদায়ন সংক্রান্ত তথ্য</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <th>PIMS আইডি</th>
                        <th>প্রত্যাশিত পদোন্নতির পদ</th>
                        <th>অভিজ্ঞতা ফিডার পদে</th>
                        <th>পদোন্নতি পরীক্ষায় উর্ত্তীণ?</th>
                        <th>অস্থায়ীভাবে নিয়োগের তারিখ</th>
                        <th>পিএসসির সুপারিশ আছে?</th>
                        <th>থাকলে তারিখ</th>
                        <th>ও স্বারক নং</th>
                        <th>স্থায়ীভাবে নিয়োগের তারিখ</th>
                        <th>সিলেকশন গ্রেড কি না?</th>
                        <th>সিলেকশন গ্রেড</th>
                        <th>টাইম স্কেল প্রাপ্তির তারিখ</th>
                       
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $DesignationName = $row["DesignationName"];
                          $experiance = $row["experiance"];
                          $PexampassName = $row["PexampassName"];
                          $apointDate = $row["apointDate"];
                          $PscrecomName = $row["PscrecomName"];
                          $pscDate = $row["pscDate"];
                          $sarokNo = $row["sarokNo"];
                          $permDate = $row["permDate"];
                          $FlagName = $row["FlagName"];
                          $GradeName = $row["GradeName"];
                          $timesDate = $row["timesDate"];
                      ?>

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

${this.title}

Code Editor : view.php