<?php
	$servername = "radio.mysql.db";//server
	$username = "radio";//user
	$password = "";//password
	$dbname = "radio";//dbase


	// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	// Check connection
	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	}

//table en html
	$montablo='';
	$montablo.='<table  style="border-collapse: collapse;">
                    <tr>
                         <th>Id</th>
                         <th>Nom</th>
                    </tr>
	';

//Requet SQL

    $sql1="select * from inscription";
	    foreach ($conn->query($sql1) as $row) {
	    	$montablo.='
                    <tr>
                         <td>'.$row['id'].'</td>
                         <td>'.$row['nom'].'</td>
                    </tr>
	';
    }

 $montablo.='</table> ';

 //nom fille

$filename = "inscription.xls";

// on insère les en-têtes Excel
 header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename='.$filename);
// et on exporte le fichier
echo $montablo;
?>