Gecko [ 43.229.15.234 ]

Name	Size	Permission
publication.php	3.25 KB	-rw-r--r--
publication_editor.php	3.75 KB	-rw-r--r--
publication_list.php	5.86 KB	-rw-r--r--
view.php	2.81 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 
                            p.id,
                            p.GovtId,
                            p.pubsub,
                            pt.PubtypeName,
                            p.pubName,
                            p.pubDate
                    
                        FROM publication p
                        LEFT JOIN pubtype pt ON(p.pubtype_id=pt.id)	
                        WHERE p.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>
                        <td>PIMS আইডি</td>
                        <td>বিষয়</td>
                        <td>প্রকাশনার ধরণ</td>
                        <td>প্রকাশনার নাম</td>
                        <td>প্রকাশের তারিখ</td>               
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                  
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $pubsub = $row["pubsub"];
                          $PubtypeName = $row["PubtypeName"];
                          $pubName = $row["pubName"];
                          $pubDate = $row["pubDate"];
                     ?>

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

${this.title}

Code Editor : view.php