export_xls

<?php
/**
 * Created by PhpStorm.
 * User: oimtrust
 * Date: 31/08/17
 * Time: 13:07
 */


//this function for sending raw excel data
header("Content-type: application/vnd-ms-excel");

$now        = date('Y-m-d');

//definition name of file
header("Content-Disposition: attachment; filename=data-surveyor-'{$now}'.xls");
?>

<table border="1">
    <tr>
        <th>No.</th>
        <th>NPM</th>
        <th>Nama</th>
        <th>Prodi</th>
        <th>Tahun Lulus</th>
        <th>No. Telepon</th>
        <th>Email</th>
    </tr>
    <?php
    $query  = $connect->execute("SELECT * FROM tbl_questionnaire ORDER BY id_questionnaire ASC");
    $no     = 1;

    while ($data = $query->fetch_object()) {
        ?>
        <tr>
            <td><?php echo $no;?></td>
            <td><?php echo $data->npm;?></td>
            <td><?php echo $data->name;?></td>
            <td><?php echo $data->prody;?></td>
            <td><?php echo $data->graduation_year;?></td>
            <td><?php echo $data->phone;?></td>
            <td><?php echo $data->email;?></td>
        </tr>
        <?php
        $no++;
    }
    ?>
</table>