<?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 VOL WHERE (HEUREDEP >= 9) && (HEUREDEP >= 13)';
			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 reussie<br/>';
		$db_selected = mysql_select_db($dbname, $connect);
		if (!$db_selected) { die ('Impossible de selectionner la bd : ' . mysql_error());  } else echo 'selection BD reussie<br/>';
		echo "Requete : $req<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>";
	}

?>