php - 在php中显示2个mysql列的总和

Question

我正在尝试对 mysql 数据库中的两个 bool 列进行简单求和。并创建一个结果 Pane ，对这两个值进行不同的计算。这就是数据库的样子 db

我正在尝试提出一个返回“喜欢”和“不喜欢”总和的 mysql 语句

然后我需要有两种格式的值:

• 作为整数(只是计数)
• 百分比

这就是我的 php 代码的样子:

  if(isset($_GET['results'])){
  $get_votes = 'SELECT liked SUM(1), disliked SUM(1) AS total FROM live';
  $run_votes = mysqli_query($con, $get_votes);
  $row_votes = mysqli_fetch_array($run_votes);

  $disliked = $row_votes['disliked']
  $liked = $row_votes['liked'];

  $count = $disliked+$liked;

  $per_disliked = round($disliked*100/$count) . "%";
  $per_liked = round($liked*100/$count) . "%";

  $per_dislikedclean = round($disliked*100/$count);
  $per_likedclean = round($liked*100/$count);

我收到“除以零”错误。这可能是因为 mysqli_fetch_array 需要 mysqli_result。任何人都可以阐明这个主题吗？

Answer 1

尝试下面的 SQL 以获得您想要的结果

SELECT SUM(liked) As liked, SUM(disliked) AS disliked, ( SUM(liked)*100 )/count(*) AS like_perc, ( SUM(disliked)*100)/count(*) AS dislike_perc FROM live