RE: [PHP] converting a Recorset into an XML string
| From: | Sean Malloy | Date: | Sat, 25 Jan 2003 23:14:31 +0000 |
| Subject: | RE: [PHP] converting a Recorset into an XML string | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-133142@lists.php.net to get a copy of this message | ||
Personally, I would do it differently, but thats just me... However one
modification I would suggest you make:
The Line:
$xml.="<".$nombre_campo.">".$valor_campo."</".$nombre_campo.">\n";
would probably be better as this:
$xml.="<".$nombre_campo.">".htmlspecialchars($valor_campo)."</".$nombre_camp
o.">\n";
just incase there is an & or a " in the data, and some XML parsers will
throw an error saying that the XML file is not well formed.
-----Original Message-----
From: Octavio Herrera [mailto:webmaster@latinencounters.com]
Sent: Sunday, 26 January 2003 9:36 AM
To: php-general@lists.php.net
Subject: [PHP] converting a Recorset into an XML string
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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php