$page = @intval($_GET['page']); if(!$page){ $page = 1; }
if(USER_ROLE!=11){ $oxcakmak->redirect(BASE_URL); }
$totalDataCount = $dbh->getValue("user", "COUNT(*)");
$pageLimit = 15;
$pageNumber = ceil($totalDataCount/$pageLimit); if($page > $pageNumber){ $page = 1;}
$viewData = $page * $pageLimit - $pageLimit;
$viewPerPage = 5;

$i = 0;
		$rawQuery = $dbh->rawQuery('SELECT * FROM user WHERE user_role != 11 ORDER BY user_id DESC LIMIT ?, ?', [$viewData, $pageLimit]);
		foreach($rawQuery as $userRow){
			$i++;
			echo '
			<tr>
				<th>'.$i.'</p></th>
				<td>'.$userRow['user_username'].'</td>
				</tr>';
		}

if($totalDataCount > 0){ echo '
	<div class="col-12 u-center">
		<div class="pagination pagination-bordered">';
			if($page > 1){ 
				echo '<div class="pagination-item short"><a href="'.BASE_URL.'my-uploads?page=1"><i class="fa fa-angle-double-left"></i></a></div>
				<div class="pagination-item short"><a href="'.BASE_URL.'my-uploads?page='.($page - 1).'"><i class="fa fa-angle-left"></i></a></div>';
			}
			for($i = $page - $viewPerPage; $i < $page + $viewPerPage +1; $i++){ 
				if($i > 0 && $i <= $pageNumber){
					if($i == $page){
						echo '<div class="pagination-item short selected"><a href="'.BASE_URL.'my-uploads?page='.$i.'">'.$i.'</a></div>';
					}else{
						echo '<div class="pagination-item short"><a href="'.BASE_URL.'my-uploads?page='.$i.'">'.$i.'</a></div>';
					}
				}
			}
			if($page != $pageNumber){
				echo '<div class="pagination-item short"><a href="'.BASE_URL.'my-uploads?page='.($page + 1).'"><i class="fa fa-angle-right"></i></a></div>
				<div class="pagination-item short"><a href="'.BASE_URL.'my-uploads?page='.$pageNumber.'"><i class="fa fa-angle-double-right"></i></a></div>';
			}
echo '</div>
	</div>';
	}else{
		echo '<br>';
	}