dpo15099 2019-01-22 06:19
浏览 36

我使用PHP和MySQLi。 现在我需要获取数据库中特定值的计数值?

How do I count particular values from database and display it? Now I have different feedback such like Excellent, Very Good, Good etc. It's basically a feedback form which ratings based

<?php
$sql_query_very_good = "SELECT *,COUNT(*) AS very_good_count FROM visitors_feedback
WHERE question01_answer LIKE '%Very Good%'
OR question02_answer LIKE '%Very Good%'
OR question03_answer LIKE '%Very Good%'
OR question04_answer LIKE '%Very Good%'
OR question05_answer LIKE '%Very Good%'
OR question06_answer LIKE '%Very Good%'
";

$result_very_good = mysqli_query($db, $sql_query_very_good);

while($view_very_good = mysqli_fetch_assoc($result_very_good)):

?>

<td><?php echo $view_very_good['very_good_count']; ?></td>

<?php endwhile; ?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 python按要求编写程序
    • ¥15 Python输入字符串转化为列表排序具体见图,严格按照输入
    • ¥20 XP系统在重新启动后进不去桌面,一直黑屏。
    • ¥15 opencv图像处理,需要四个处理结果图
    • ¥15 无线移动边缘计算系统中的系统模型
    • ¥15 深度学习中的画图问题
    • ¥15 java报错:使用mybatis plus查询一个只返回一条数据的sql,却报错返回了1000多条
    • ¥15 Python报错怎么解决
    • ¥15 simulink如何调用DLL文件
    • ¥15 关于用pyqt6的项目开发该怎么把前段后端和业务层分离