Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxview.php	510 B	-rw-r--r--
empaddress.php	3.58 KB	-rw-r--r--
empaddress_editor.php	6.32 KB	-rw-r--r--
empaddress_list.php	6.36 KB	-rw-r--r--
view.php	2.8 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 
                        em.id,
                        em.GovtId,
                        dis.DistrictName,
                        em.pmaddress,
                        em.craddress,
                        em.telephone,
                        em.mobile										
                        FROM empaddress em
                        LEFT JOIN district dis ON(em.district_id=dis.id)	
                        WHERE em.GovtId= ?");

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

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

while($row = $result->fetch_assoc())
						{
					
						$GovtId = $row["GovtId"];
						$id = $row["id"];
						$DistrictName = $row["DistrictName"];
						$pmaddress = $row["pmaddress"];
						$craddress = $row["craddress"];
						$telephone = $row["telephone"];
						$mobile = $row["mobile"];
                        }

?>
<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>
                            <td>মোবাইল নং</td>                       
                        </tr>                       
                     
                        <tr>              
                            <td><?=bangladate($GovtId)?></td>
                            <td><?=$DistrictName ?></td>
                            <td><?=$pmaddress ?></td>
                            <td><?=$craddress ?></td>
                            <td><?=$telephone ?></td>
                            <td><?=$mobile ?></td>
                       </tr>
                    </table>
                </div>

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

${this.title}

Code Editor : view.php