<?PHP
	$choix = $_GET['choix'] ;
	echo '<div style="color: blue; font-family: arial; font-size: 10px;">';
	$requette = formulaire($choix);
	$reponse = connexion($requette);
	tab_out($reponse);

	echo'</div>';

function formulaire($NumReq)
{

	switch ($NumReq)
	{
	case 1;
		$req = 'SELECT PLNUM,PLNOM FROM PILOTE';
		break;
	case 2;
		$req= 'SELECT DISTINCT * FROM PILOTE WHERE (SALAIRE >= 18000)';
		break;
	case 3;
		$req = 'SELECT DISTINCT * FROM PILOTE, VOL WHERE (PILOTE.PLNUM = VOL.PLNUM)';
		break;

	}
	return $req;
}

function connexion($req)
{
        $host ="localhost:3306";
        $user ="root";
        $password ="";
        $dbname ="transport_aerien";
        $connect = @mysql_connect($host, $user, $password); // @ n'affiche pas les erreurs de la fonction
        if (!$connect) {   die('Impossible de se connecter : ' . mysql_error()); } else echo 'Connexion réussit<br/>';
        $db_selected = mysql_select_db($dbname, $connect);
        if (!$db_selected) { die ('Impossible de sélectionner la bd : ' . mysql_error());  } else echo 'Sélection BD réussit<br/>';

        $reponse = mysql_query($req);
        mysql_close($connect);
        return $reponse;
}

function tab_out($result)   {


        $N = @mysql_num_fields($result); // N = nombre de colonnes du tableau $result
        printf("<table border='0' cellpadding='1' cellspacing='1' style='font-family: arial; font-size: 10px;'>");
        printf("<tr style='color: black;' bgcolor=#D0D0D0>");
        for ($i=0; $i<$N; $i++) printf("<th>%s</th>", mysql_field_name($result,$i));
        echo "</tr>";
        while ( $ligne = @mysql_fetch_array( $result, MYSQL_NUM ))
        {   echo "<tr style='color: maroon;' bgcolor='#E8E8E8'>";
            for($n=0; $n<$N ; $n++)  printf("<td>%s</td>", $ligne[$n]);
            echo "</tr>";
        }
        echo "</table>";

}

?>