Script php pour generer Xml

Bonjour,



j'aimerai mettre en place un script php qui me permet de creer un fichier Xml que je vais utilisé aprés dans une application Java Me voici le script que j'ai ecrit mais un message affichant que pas de base de donnée a été selectionné

----------------------------------------------------------------------------------------

<?php   
 $hostname_localhost ="localhost";  
 $database_localhost ="tunipharma";  
 $username_localhost ="root";  
 $password_localhost ="";  
 $con = mysql_connect($hostname_localhost,$username_localhost,$password_localhost) 
 $base=mysql_select_db ("tunipharma", $con);  
 or  
 trigger_error(mysql_error(),E_USER_ERROR);   
      $query_search = "SELECT nom,prenom FROM pharmacie ";  
      $query_exec = mysql_query($query_search) or die(mysql_error());  
   
if($query_exec!=null){  
      $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
   //1er noeud 
      $root_element = "pharmacie"; 
      $xml .= "<$root_element>";
   
   while($result_array = mysql_fetch_assoc($query_exec))
     {
      $xml .= "<pharmacie>";
 
      foreach($result_array as $key => $value)
      {
         //$key holds the table column name
         $xml .= "<$key>";
 
         //embed the SQL data in a CDATA element to avoid XML entity issues
         $xml .= "<![$value]>"; 
 
         //and close the element
         $xml .= "</$key>";
      }
 
      $xml.="</pharmacie>";
   }
   
   //close the root element
$xml .= "</$root_element>";
 
//send the xml header to the browser
header ("Content-Type:text/xml"); 
 
//output the XML data
echo $xml;
 }  
 ?>  

--------------------------------------------------------------------------------------