converting a Recorset into an XML string

["Octavio Herrera" <webmaster@latinencounters.com>]

Hello everybody, I make a function that lets you convert a recordset
obtained via mysql_query() into an XML string:
maybe could be helpfull to yours

this is the function

it have 3 parameters:   $rs is the recordset you want to convert
                                    $padre is the name for the parent node
that will contain every record on the recordset
                                    $hijo is the name for the child node
that will contain a single record in the recordset



function rs2xml($rs,$padre,$hijo){
 $num_campos=mysql_num_fields($rs);
 $num_filas=mysql_num_rows($rs);

 if($padre!="-1")
  $xml="<$padre>\n";
 else
  $xml="";

 $cont1=0;
 while($cont1<$num_filas){
  $fila=mysql_fetch_array($rs);
  $xml.="<$hijo>\n";
  $cont=0;
  while($cont<$num_campos){
   $nombre_campo=mysql_field_name($rs,$cont);
   $valor_campo=$fila[$cont];
   $xml.="<".$nombre_campo.">".$valor_campo."</".$nombre_campo.">\n";
   $cont++;
  }
  $xml.="</$hijo>\n";
  $cont1++;
 }
 if($padre!="-1")
 $xml.="</$padre>\n";
 return $xml;
}

I hope this will be helpful for you

OCTAVIO HERRERA





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php