<div id="videos">
	<?php
if(!isset($_GET['page']) || $_GET['page']==1){
	$limit=" LIMIT 0,12";
}else{
	$_GET['page'];
	$end=$_GET['page']*12;
	$start=$end-12;
	$limit=" LIMIT ".$start.",12";
}
$page=$conn->prepare("SELECT COUNT(id) AS count FROM video WHERE del=0");
$page->execute();
$pages=$page->fetch(PDO::FETCH_ASSOC);
$pages['count'];
$amountPages=$pages['count']/12;
$amountPages=floor($amountPages);
if($pages['count']%12 > 0){
	$amountPages++;
}
$stmt=$conn->prepare("SELECT * FROM video WHERE del=0".$limit);
$stmt->execute();
$video=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($video as $video) {
		$startLink=strrpos($video['link'],"=");
		$link=substr($video['link'],$startLink+1);
	?>
	<a ><div class="detailVideo">
		<div class="video">
			<iframe src="https://www.youtube.com/embed/<?php echo $link ?>" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
		</div>
		<div class="infoVideo"><?php echo $video['title']; ?></div>
	</div></a>
<?php }?>
	<div id="page">
			<?php if(isset($_GET['page'])){
			$startUrl=strrpos($_SERVER['REQUEST_URI'], "/")+1;
			$endUrl=(strrpos($_SERVER['REQUEST_URI'], "=")+1)-$startUrl;
			$url=substr($_SERVER['REQUEST_URI'],$startUrl,$endUrl);
			if($_GET['page']>1){ ?>
			<a href="<?php echo $url.($_GET['page']-1); ?>"><img src="lib/icons/prev.png" align="center"></a>
			<?php } for ($i=$_GET['page']-1; $i <= $_GET['page']+4; $i++) {if($i>0 && $i<=$amountPages){ ?>
					<a class='page' id="p<?php echo $i; ?>" href="<?php echo $url ?><?php echo $i; ?>"><?php echo $i; ?></a>	
			<?php }}if(($i-1)<$amountPages){ ?><a>...</a><?php }if($_GET['page']<$amountPages){ ?>
			<a href="<?php echo $url.($_GET['page']+1); ?>"><img src="lib/icons/next.png" align="center"></a>
			<?php }} ?>
		</div>
</div>