Gecko [ 43.229.15.234 ]

Name	Size	Permission
atpaper1	[ DIR ]	drwxr-xr-x
atpaper2	[ DIR ]	drwxr-xr-x
atpaper3	[ DIR ]	drwxr-xr-x
postingrecord.php	7.16 KB	-rw-r--r--
postingrecord_editor.php	7.72 KB	-rw-r--r--
postingrecord_list.php	7.4 KB	-rw-r--r--
view.php	3.71 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 
                             	ps.id,
                                ps.GovtId,
                                pt.PostingtypeName,
                                o.OfficeName,
                                ps.plocattion,
                                ps.stratDate,
                                ps.endDate,
                                g.PayScale,
                                ps.postcomments
                        
                        FROM postingrecord ps
                            LEFT JOIN postingtype pt ON(ps.postingtype_id=pt.id)	
                            LEFT JOIN office o ON(ps.office_id=o.id)	
                            LEFT JOIN grade g ON(ps.payscal_id=g.id)	
                        WHERE ps.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>
                       
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $PostingtypeName = $row["PostingtypeName"];
                          $OfficeName = $row["OfficeName"];
                          $plocattion = $row["plocattion"];
                          $stratDate = $row["stratDate"];
                          $endDate = $row["endDate"];
                          $PayScale = $row["PayScale"];
                          $postcomments = $row["postcomments"];
                          
                      ?>
                        <tr>              
                        <td><?=bangladate($GovtId)?></td>
                        <td><?=$PostingtypeName ?></td>
                        <td><?=$OfficeName ?></td>
                        <td><?=$plocattion ?></td>
                        <td><?=bangladate($stratDate) ?></td>
                        <td><?=bangladate($endDate) ?></td>
                        <td><?=$PayScale ?></td>
                        <td><?=$postcomments ?></td>
                        
                       </tr>
                       <?php
						}
						?>
                    </table>
                </div>

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

${this.title}

Code Editor : view.php