<?php
// STORE DATABASE VARIABLES
$hostname_cnConnection = "localhost";
$database_cnConnection = "utiles";
$username_cnConnection = "root";
$password_cnConnection = "root";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);
$query_rsRecordset = "select * from photos";
$rsRecordset = mysql_query($query_rsRecordset, $cnConnection) or die(mysql_error());
$row_rsRecordset = mysql_fetch_assoc($rsRecordset);
$totalRows_rsRecordset = mysql_num_rows($rsRecordset);
// START STORING DATA IN VARIABLE TO PLACE IN XML FILE
if($totalRows_rsRecordset > 0) {
$strXML = "<?xml version=\"1.0\"?>\n";
// STORE NAME OF TABLE
$strXML = $strXML . "<photos>\n";
// STORE FIELD AND FIELD DATA IN ONE HIARCHY, REPEAT FOR MULTIPLE FIELDS
;
do {
$strXML = $strXML . "<photo filename='".$row_rsRecordset["photo_filename"]."'
thumbnail='".$row_rsRecordset["thumbnail"]."' description='".$row_rsRecordset["description"]."/>";
} while ($row_rsRecordset = mysql_fetch_assoc($rsRecordset));
$strXML = $strXML . "</photos>";
// OPEN FILE, WRITE TO FILE, CLOSE FILE, CLOSE RECORDSET
$XMLFile = fopen("flashmo_060_gallery01.xml", "w");
fwrite($XMLFile, $strXML);
fclose($XMLFile);
}
mysql_free_result($rsRecordset);
?>
el rollo vine aqui esto-----------------------------------------------------------------------------------------------------------
$strXML = $strXML . "<photo filename='".$row_rsRecordset["photo_filename"]."'
thumbnail='".$row_rsRecordset["thumbnail"]."' description='".$row_rsRecordset["description"]."/>";-----------------------
me genera un xml
<?xml version="1.0"?>
<photos>
yo ne decito que imprima <photo filename="'bees.jpg"
y no con ' <photo filename='bees.jpg' alguien sabe como conseguirlo?
<photo filename='bees.jpg'
thumbnail='' description='Bees (640x480) - here is a photo description.<br /><b>Photos by <a href="http://www.flashband.net/photos">flashband.net</a></b>'/></photos>
agradeco cualq ueir alcanse
