Gecko [ 43.229.15.234 ]

Name	Size	Permission
foreigntraining.php	4.15 KB	-rw-r--r--
foreigntraining_editor.php	5.16 KB	-rw-r--r--
foreigntraining_list.php	6.61 KB	-rw-r--r--
view.php	3.58 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 
                            f.id,
                            f.GovtId,
                            f.coursetitle,
                            f.instName,
                            f.instLocation,
                            c.CountryName,
                            f.startDate,
                            f.endDate,
                            f.exmresult					         
                        FROM foreigntraining f
                            LEFT JOIN country c ON(f.country_id=c.id)	
                        WHERE f.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"];
                         $coursetitle = $row["coursetitle"];
                         $instName = $row["instName"];
                         $instLocation = $row["instLocation"];
                         $CountryName = $row["CountryName"];
                         $startDate = $row["startDate"];
                         $endDate = $row["endDate"];
                         $exmresult = $row["exmresult"];
                     ?>
                        <tr>              
                        <td><?=bangladate($GovtId)?></td>
                        <td><?=$coursetitle ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$instLocation ?></td>
                        <td><?=$CountryName ?></td>
                        <td><?=bangladate($startDate) ?></td>
                        <td><?=bangladate($endDate) ?></td>
                        <td><?=$exmresult ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
                </div>

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

${this.title}

Code Editor : view.php