Gecko [ 43.229.15.234 ]

Name	Size	Permission
userinfo.php	3.3 KB	-rw-r--r--
userinfo_editor.php	3.8 KB	-rw-r--r--
userinfo_list.php	4.01 KB	-rw-r--r--

Code Editor : userinfo_list.php

<?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-6 col-md-offset-4">
<br/>
    <form name="search_frm" id="search_frm" class="form-inline">
      
         <label>Search Key</label>
         <input type="text"    name="field_value" id="field_value" value="<?=$_SESSION["field_value"]?>" class="form-control">
		 <input type="hidden" name="cmd" id="cmd" value="search_userinfo" >
         <input type="submit" class="btn btn-primary" value="Search">
    </form>
</div>
</div>

<thead>
				<th>ক্রম</th>	
				<th>ব্যক্তিগত ই-মেইল</th>    
				<th>ব্যবহারকারীর নাম</th>     
				<th>পদবি</th>             
				<th>মোবাইল নং</th>              
	            <th>অধিদপ্তর/প্রতিষ্ঠান</th>				 
				<th>PMIS আইডি</th>
           
				<th style="text-align: center">সংশোধন</th>	          
				
               </thead>

<tbody>
               <?php
			   include("../common/role.php");

if($_SESSION["search"]=="yes")
				  {
					
					$val= $_SESSION["field_value"];
					$whrstr = "%$val%";
				  }
				  else
				  {
					$whrstr = "%%";
				  }
		 
				$rowsPerPage = 100;
				$pageNum = 1;
				if(isset($_REQUEST["page"]))
				{
					$pageNum = $_REQUEST["page"];
				}
				$offset = ($pageNum - 1) * $rowsPerPage;

// prepare and bind
                $stmt = $conn->prepare("SELECT u.id, u.uname, u.username,
											   u.designation, u.office_id, u.upassword, u.userrole_id,
											   u.dumpass, u.aprflag, u.mobileno, u.districtoffice_id,
										       g.GovtId,offi.OfficeName,doff.districtofficeName, ur.rolename
										FROM userinfo u 
										LEFT JOIN `general` g ON(u.id=g.userinfo_id)
										LEFT JOIN `office` offi ON(u.office_id=offi.id)
										LEFT JOIN `districtoffice` doff ON(u.districtoffice_id=doff.id)
										LEFT JOIN `userrole` ur ON(u.userrole_id=ur.id)		   
							   WHERE 1=1 ".$user." and  (u.uname LIKE ? or g.GovtId LIKE ? ) ORDER BY u.id DESC  LIMIT ?, ?");
                $stmt->bind_param("ssii",$whrstr,$whrstr,$offset,$rowsPerPage);
                $stmt->execute();

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

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

while($row = $result->fetch_assoc())
                {

$slno = $slno+1;
                    $id = $row["id"];
					$OfficeName = $row["OfficeName"];
					$uname = $row["uname"];                
					$rolename = $row["rolename"];
					$designation = $row["designation"];
					$mobileno = $row["mobileno"];
					$username = $row["username"];
					$GovtId = $row["GovtId"];

?>
               <tr>
              
                 <td align="center"><?=bangladate($slno) ?></td>
                 <td><?=$uname ?></td>	
				 <td><?=$username ?></td>	
				 <td><?=$designation ?></td>	
				 <td><?=$mobileno ?></td>	
				 <td><?=$OfficeName ?></td>				
				 <td><?=$GovtId ?></td>
             			    
			 
               <td align="center">
               <a href="userinfo.php?cmd=edit&id=<?=base64_encode($id)?>">
               <span class="glyphicon glyphicon-pencil"></span></a>
               </td>
			 
               </tr>
               <?php
               }
               ?>
             </tbody>
           </table>		   
           	   
         </div>
    </div>

</div>

<?php
include("../homepage/footer.php");
?>

${this.title}

Code Editor : userinfo_list.php