v1_avaliacoes_positivas
SELECT id AS idAvaliacao, idVideo, COUNT( voto ) AS totalPositivos
FROM avaliacoes
WHERE voto LIKE '1'
GROUP BY idVideo
---
v2_avaliacao_final
SELECT videos.id AS idVideo, url, totalPositivos, totalNegativos
FROM videos
LEFT JOIN v1_avaliacoes_positivas ON videos.id = v1_avaliacoes_positivas.idVideo
LEFT JOIN v1_avaliacoes_negativas ON videos.id = v1_avaliacoes_negativas.idVideo
---
<?php require_once("ligacao.php");
$sql="SELECT * FROM videos";
$query=mysqli_query($ligar, $sql);
$total=mysqli_num_rows($query);
$fetch=mysqli_fetch_assoc($query); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Lista de vídeos</title>
</head>
<body>
<div>
<?php do {?>
<div id="video<?php echo $fetch['id'];?>">
<iframe width="560" height="315" src="<?php echo $fetch['url'];?>" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>
</div>
<br>
<?php } while($fetch=mysqli_fetch_assoc($query));?>
</div>
</body>
</html>
Sem comentários:
Enviar um comentário