A small example of php generating xls file

include '../../inc/auth.php';
include '../public/Base.php';
include '../public /BoonList.php';
//The above is the code for pdo to connect to the database, you can complete it by yourself.
header('Cache-Control: no-cache, must-revalidate');
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: filename=leaveMessage.xls' );
?>



   < ;td nowrap>Message content < ?phpif (isset($_GET['trio']) && $_GET['trio']=='trio_message') { $sql = "select * from trio_message"; $order_list = $db-> getAll($sql); for($i=0;$i
 echo '' ; echo''; echo''; echo''; echo''; echo'' ;echo ''; }}?>

Message ID
 userid
username

Date



'.$order_list[$i]["id"].'
'.$order_list[$i]["userid "].'
'.$order_list[$i]["user_name"].'
' .$order_list[$i]["content"].'
'.$order_list[$i]["fdate"].'