File size: 1.05Kb
<?php
$limit = 3;
$video = $pdo->query(("SELECT COUNT(*) FROM `user_video`"), 0)->fetchColumn();
?>
<style>
.video {
position: relative;
margin: 3px 5px 3px 3px;
position: relative;
}
.video_blok {
top: 13px;
left: 12px;
color: #F7F7F7;
position: absolute;
}
</style>
<?
echo "<div style='padding:5px; background-color: #FAFDFF;'>";
echo "<a href='/modules/video/index.php?sort=rate&DESC'><div class='link_p' style='padding: 5px;'><font color=#6E8394><b>ЛУЧШИЕ ВИДЕО <span class='count_p' style=' color: #D0DFEB;'>$video</span> <span style='float: right;'><i class='fa fa-film'></i></span></font></b></div></a>";
echo "<div class='list-group-item'>";
$q = $pdo->query("SELECT * FROM `user_video` WHERE `private_folder` = '0' AND `block_yes` = '0' ORDER BY time DESC LIMIT $limit");
while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
echo "<i class='fa fa-film fa lg fa-fw'></i> <a href='/user/video/file.php?id=".$post['id']."'> ".htmlspecialchars($post['name'])."";
echo "</a><br><br>";
}
echo "</div>";
echo "</div>";
?>