Untitled

<?PHP
echo "<body bgcolor=#FFFFCC>";
    $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 BETWEEN '09:00:00' AND '13:00:00'";
            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>";
    }

?>