Display the sql query results in php

Question

How can I display the following SQL query's results in PHP ?

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;

This question is missing the following information: (1) the nature of the problem (2) what you have tried so far, (3) expected and (4) actual results. — Michael Jaros, Mar 06 '15 at 18:02
I am a new user in php , I am getting the reults in mysql console but not able to form the table in php . — emesar ITPL, Mar 06 '15 at 18:07
http://prntscr.com/6d3hzt Please chk the screen shot I want to display it same in webpage using php. — emesar ITPL, Mar 06 '15 at 18:09

score 0 · Answer 1 · edited May 23 '17 at 11:43

0

Have a look at this W3schools tutorial explaining how to select data from MySQL in PHP.
This StackOverflow Question adds how to build a simple HTML around a query.

edited May 23 '17 at 11:43

Community

1
1

answered Mar 06 '15 at 18:18

Michael Jaros

4,586
1
22
39

Display the sql query results in php

1 Answers1