<?php  
//ส่งออกรายชื่อนักเรียน 
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Bangkok');
require_once('../config.php');
$scid=$_GET['scid'];
$u="";
$output = '';
$sql= $mysqli->query("SELECT * FROM users where `role_id`='4' AND gset='$scid'");
 if(mysqli_num_rows($sql) > 0)
 {

  $output .= '
   <table class="table" bordered="1" border="1">  
                    <tr>  
                        <th>ที่</th>  
                        <th>Username</th>  
                        <th>ชื่อ-สกุล</th>  
						<th></th>
                    </tr>
  ';
$i = 0;
  while($row = mysqli_fetch_array($sql))
  {
$i++;
$sql1sc= $mysqli->query("SELECT * FROM users where `role_id`='4' AND `gset`='$scid' ");
$total1sc=mysqli_num_rows($sql1sc);
$all=number_format("$total1sc");
   $output .= '
    <tr>  
                        <td width=50 align=center>'.$i.'</td>  
                        <td width=120 align=center>'.$u.'&nbsp;'.$row["username"].'</td>  
                        <td width=500>'.$row["name"].'</td>  
						<td align=center>'.$u.'</td>  

    </tr>
   ';
  }
  $output .= '</table>';
 
$file = "รายชื่อครู_" . date('Y-m-d') . ".xls";
header('Content-Disposition: attachment; filename='.$file);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-Transfer-Encoding: BINARY");
echo $output;

 }

?>