Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxview.php	520 B	-rw-r--r--
userinfo.php	6.11 KB	-rw-r--r--
userinfo_editor.php	7.45 KB	-rw-r--r--
userinfo_list.php	8.37 KB	-rw-r--r--
userinfo_pending.php	8.36 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>রোল</th>   
				<th>PMIS আইডি</th>   
				<th>অনুমোদন আছে?</th>                        
             
				<th style="text-align: center">সংশোধন</th>
				<th style="text-align: center">ডিলিট</th>
	        
				
               </thead>

<tbody>
               <?php
				
				if($_SESSION["search"]=="yes")
				  {
					
					$val= $_SESSION["field_value"];
					$whrstr = "%$val%";
				  }
				  else
				  {
					$whrstr = "%%";
				  }
		 
				$rowsPerPage = 50;
				$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 and  (u.uname LIKE ? or g.GovtId LIKE ? OR u.mobileno LIKE ? ) ORDER BY u.id DESC  LIMIT ?, ?");
                $stmt->bind_param("sssii",$whrstr,$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"];    
					$username = $row["username"];            
					$rolename = $row["rolename"];
					$designation = $row["designation"];
					$aprflag = $row["aprflag"];
					$mobileno = $row["mobileno"];
					$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><?=$rolename ?></td>
				 <td><?=$GovtId ?></td>

<td align="center">
               <a href="userinfo.php?cmd=delete&id=<?=$id?>" onClick=" return confirm('আপনি কি নিশ্চিত?');">
               <span class="glyphicon glyphicon-trash"></span></a>
               </td>

</tr>

<?php
               }
               ?>
             </tbody>

<div align="center">     
		   <?php

// prepare and bind
        $stmt = $conn->prepare("SELECT * FROM userinfo WHERE uname LIKE ? ORDER BY id ASC");
        $stmt->bind_param("s",$whrstr);
        $stmt->execute();

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

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

$maxPage = ceil($numrows/$rowsPerPage);
			$self = "userinfo.php?cmd=list";
			$nav  = "";
			
			$start    = ceil($pageNum/5)*5-5+1;
			$end      = ceil($pageNum/5)*5;	
			
			if($maxPage<$end)
			  {
				$end  = $maxPage;
			  }	
			
			
			for($page = $start; $page <= $end; $page++)
                  {
                      				   
					  if ($page == $pageNum)
						{
							$nav .= "<span class=\"page-link\"><font color=\"red\">$page</font></span>";
						}
						else
						{
							$nav .= " <a href=\"$self&&page=$page\" class=\"page-link\">$page</a> ";
						}
				}
				
		   if ($pageNum > 1)
				{
					$page  = $pageNum - 1;
					$prev  = " <a href=\"$self&&page=$page\" class=\"page-link\">Prev</a> ";
			
				   $first = " <a href=\"$self&&page=1\" class=\"page-link\">First Page</a> ";
				} 
				else
				{
					$prev  = "&nbsp;"; 
					$first = "&nbsp;"; 
				}
		  
		  if ($pageNum < $maxPage)
				{
					$page = $pageNum + 1;
					$next = " <a href=\"$self&&page=$page\" class=\"page-link\">Next</a> ";
			
					$last = " <a href=\"$self&&page=$maxPage\" class=\"page-link\">Last Page</a> ";
				} 
				else
				{
					$next = "&nbsp;"; 
					$last = "&nbsp;"; 
				}
				
				if($numrows>1)
				{
				  echo '<nav>
                         <ul class="pagination">
                           <li class="page-item">'.$first.'</li>'.
						   '<li class="page-item">'.$prev.'</li>
						   <li class="page-item">'.$nav .'</li>
						   <li class="page-item">'.$next.'</li> 
						   <li class="page-item">'. $last.'</li>
						</ul></nav>';
				  
				}
			?>
           </div>		   
         </div>
    </div>
</div>

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

if(districtoffice_id) {

$.ajax({
            url: "ajaxoffice.php",
            dataType: 'Json',
            data: {'districtoffice_id':districtoffice_id},
            success: function(data) {
                $('select[name="office_id"]').empty();
                $.each(data, function(key, value) {
                    $('select[name="office_id"]').append('<option value="'+ key +'">'+ value +'</option>');
                });
            }
        });

}else{
        $('select[name="office_id"]').empty();
    }
});
</script>

${this.title}

Code Editor : userinfo_list.php