Gecko [ 43.229.15.234 ]

Name	Size	Permission
role_user.php	3.46 KB	-rw-r--r--
userrole.php	2.63 KB	-rw-r--r--
userrole_editor.php	1.62 KB	-rw-r--r--
userrole_list.php	4.79 KB	-rw-r--r--

Code Editor : role_user.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");
 }	
 ?>		 
 
<div class="container fullheight">
    <div class="row">
        <div class="col-md-12">
            <br>
           
            
<?php
$userrole_id = $_REQUEST["id"];

// prepare and bind
 $stmt = $conn->prepare("SELECT * FROM userrole WHERE id = ? ORDER BY id ASC");
 $stmt->bind_param("i", $userrole_id);
 $stmt->execute();

//Result
 $result = $stmt->get_result();
 $numrows = $result->num_rows;

while ($row = $result->fetch_assoc()) {
     $rolename = $row["rolename"];
 }

$stmt = $conn->prepare("SELECT u.id, u.uname, u.username, u.designation,
                                u.office_id, o.OfficeName,
                                u.mobileno, u.districtoffice_id, d.districtofficeName  
                        FROM userinfo u
                        LEFT JOIN office o ON(u.office_id=o.id)
                        LEFT JOIN districtoffice d ON(u.districtoffice_id=d.id)
                        WHERE aprflag>0 AND u.userrole_id=? ORDER BY u.office_id");

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

$slno=0;

if($numrows>0)
  {
 ?>
 <br>
 <h4>ইউজার রোলের নাম: <?=$rolename ?></h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>ব্যক্তিগত ই-মেইল</td>
                        <td>ব্যবহারকারীর নাম</td>
                        <td>পদবী</td>
                        <td>মোবাইল নং</td>
                        <td>অফিসের নাম</td>
                        <td>নির্বাহী প্রকৌশলীর কার্যালয়</td>                            
                        </tr>                       
                     <?php
                     while($row = $result->fetch_assoc())
                     {
                         $slno=$slno +1;
                         $id = $row["id"];
                         $uname = $row["uname"];
                         $username = $row["username"];
                         $designation = $row["designation"];
                         $mobileno = $row["mobileno"];
                         $OfficeName = $row["OfficeName"];
                         $districtofficeName = $row["districtofficeName"];
                        
                     ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td><?=$uname ?></td>
                        <td><?=$username ?></td>
                        <td><?=$designation ?></td>
                        <td><?=$mobileno ?></td>
                        <td><?=$OfficeName?></td>
                        <td><?=$districtofficeName ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
  }	
  
  ?>

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

${this.title}

Code Editor : role_user.php