在php中以mysql的表格显示组

Question

I have a query in mysql which will return a table grouped by some fields. How can I echo these results? Here is piece of my code.

$stmt = $con->prepare("
SELECT classSubject
     , COUNT(*) cnt
  from Class 
 where grade=? 
   and department=? 
   and classGroup IN(?,3) 
 GROUP 
    BY classSubject;
");
    $stmt->bind_param("isi", $grade, $department, $classGroup);

 //executing the query 
 $stmt->execute();

What should I do after this so that I can echo all the result?

Answer 1

After reading Tim Biegeleisen's answer and doing a bit of surfing, I came up with this solution. After executing the query:

$response = array(); 
 $response['success']=true; 

    $stmt->bind_result($classSubject,$cnt);

    while ($stmt->fetch()) 
    {
        $response[$classSubject]=$cnt;
    }

 echo json_encode($response);

Hope this helps someone.