<?php
$conn=mysqli_connect('localhost','ccusiitm','c1H2-nSt)(R9U','ccusiitm_ccusit');



?>
<table class="table table-bordered datatable" id="table-4">
			<thead>
				<tr>
					<th>S.no</th>
					<th>Name</th>
					<th>Image</th>
					<th>Role</th>
				
				</tr>
			</thead>
			<tbody>
			    	<?php
			$i=0;
			if(isset($_POST['page'])){
			    $page=$_POST['page'];
			    if($page==''){
			        $view='select * from portafila';
			    }
			    else {
			    	$view="select * from portafila where role='$page'";
			    }
			}
			else {
			$view='select * from portafila';
			}
			$view_result=mysqli_query($conn,$view);
			if(mysqli_num_rows($view_result)>=1){
			while($row=mysqli_fetch_assoc($view_result)){
				$i=$i+1;
				$id=$row['id'];
				$name=$row['name'];
				$role=$row['role'];
					$image=$row['image'];
			
					  
				
				
				
				
				
				
				
			
			
			
			?>
				<tr class="odd gradeX">
					<td><?php echo $i;?></td>
					<td><?php echo $name;?></td>
						<td><img src="../assets/images/portfolia/<?php echo $image;?>" alt="" class="img-circle" width="44" /></td>
						<td><?php echo $role;?></td>
					
				</tr>
				<?php
			}	
			}
			?>
				</tbody>
			
		</table>