[mackem]

Hi, followed the excellent thread started by Punky79 on 03-08-08, 05:25 AM.

I want to do the same thing, using the same code by the look of it (from kirupa.com).

I want to save the xml to my server, not locally. Can't get it to work.

Very inexperienced programmer, so please be gentle!

[mackem]

Here's the code I'm using to generate xml in a browser window.
What code do I need to save that to the server as an xml file I can then access?


<?php require_once('friends.php'); ?>

<?php

("Content-type: text/xml");


mysql_select_db($database_friends, $friends);
$query_Recordset1 = "SELECT email FROM member_info ORDER BY email DESC";
$Recordset1 = mysql_query($query_Recordset1, $friends) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<entries>\n";

for($x = 0 ; $x < mysql_num_rows($Recordset1) ; $x++){
$row = mysql_fetch_assoc($Recordset1);

$xml_output .= "\t<entry>\n";
$xml_output .= "\t\t<email>" . $row['email'] . "</email>\n";
$xml_output .= "\t</entry>\n";
}

$xml_output .= "</entries>";

echo $xml_output;

?>

[wirehopper]

PHP Code:

function XMLHeader($in_header)

{

  global $fp;

  fwrite($fp,sprintf("%s",$in_header));

}



function XMLStartTag($in_tag)

{

  global $fp;

  fwrite($fp,sprintf("<%s>",$in_tag));

}



function XMLEncode($in_tag,$in_data)

{

  global $fp;

  fwrite($fp,sprintf("<%s>%s</%s>",$in_tag,sanitize(4,0,$in_data),$in_tag));

}



function XMLEndTag($in_tag)

{

  global $fp;

  fwrite($fp,sprintf("</%s>",$in_tag));

}





$fp = @fopen('xml.xml',"wb");

XMLHeader ('<?xml version="1.0" encoding="ISO-8859-1" ?>');

XMLStartTag('CARRIER');

XMLEncode('ID',$id);

XMLEncode('NAME',$name);

XMLEncode('WEBSITE',$website);

XMLEncode('AREAS',$area);

XMLEndTag('CARRIER');  

fflush($fp);

fclose($fp);

http://us3.php.net/manual/en/xml.examples.php

[mackem]

Thanks Wirehopper.

Thinking about it afterwards, I don't need to save the file, I can just access the php file through flash, because that is generating the xml file for me!
Cheers
Mackem