在php中显示sql查询结果


Display the sql query results in php

如何在PHP中显示以下SQL查询的结果?

SELECT CONCAT(
'SELECT `repagents`.full_name', GROUP_CONCAT('
, `t_', REPLACE(status, '`', '``'), '`.value
AS `', REPLACE(status, '`', '``'), '`'
SEPARATOR ''),
' FROM `repagents` ', GROUP_CONCAT('
LEFT JOIN `repagents` AS `t_', REPLACE(status, '`', '``'), '`
ON `repagents`.full_name = `t_', REPLACE(status, '`', '``'), '`.full_name
AND `t_', REPLACE(status, '`', '``'), '`.status = ', QUOTE(status)
SEPARATOR ''),
' GROUP BY `repagents`.full_name'
) INTO @qry FROM (SELECT DISTINCT status FROM `repagents`) t;
PREPARE stmt FROM @qry;
EXECUTE stmt;
  • 看看这些W3schools辅导的解释如何在PHP中从MySQL中选择数据
  • 此StackOverflow问题增加了如何围绕查询构建一个简单的HTML