$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>&#039;.$i.&#039;</p></th>
				<td>&#039;.$userRow[&#039;user_username&#039;].&#039;</td>
				</tr>&#039;;
		}

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

Add a code snippet to your website: www.paste.org