Gecko [ 43.229.15.234 ]

Name	Size	Permission
spouse.php	3.2 KB	-rw-r--r--
spouse_editor.php	3.96 KB	-rw-r--r--
spouse_list.php	6.13 KB	-rw-r--r--
view.php	3.18 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 
                                sp.id,
                                sp.GovtId,
                                sp.nameB,
                                sp.nameE,
                                d.DistrictName,
                                sp.ocupation,
                                sp.location                 
                        FROM spouse sp
                        LEFT JOIN district d ON(sp.district_id=d.id)
                        WHERE sp.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())
						{
						   
							
						$id = $row["id"];
						$GovtId = $row["GovtId"];
						$nameB = $row["nameB"];
						$nameE = $row["nameE"];
						$DistrictName = $row["DistrictName"];
						$ocupation = $row["ocupation"];
						$location = $row["location"];
                        }

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

<tr>
                            <td>নাম (বাংলায়)</td>
                            <td><?=$nameB?></td>                       
                        </tr>

<tr>
                            <td>নাম (ইংরেজিতে)</td>
                            <td><?=$nameE?></td>                       
                        </tr>

<tr>
                            <td>জন্মগ্রহনকারী জেলা</td>
                            <td><?=$DistrictName?></td>                       
                        </tr>

<tr>
                            <td>কর্মস্থল ও যোগাযোগ</td>
                            <td><?=$location?></td>                       
                        </tr>

</table>
                </div>

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

${this.title}

Code Editor : view.php