PhP guru's ---> Php to xml

[D-flyer]

Hello there

I am trying to get a simple guestbook working with flash (front-end) and php/xml (back-end).

First i got a simple php-script that writes data to guest.db file and the data looks like:
barry||barry%40fula.nl||Aug%2024||2001||19%3A58||Hi%20there

The php-script i use looks like this:
<?PHP
if ($command=="view"){
$info=file("guest.db");
$max=sizeof($info);
for ($i=0;$i<$max;++$i){
$temp=explode("||",$info[$i]);
echo("&name".($i+1)."=".$temp[0].
"&email".($i+1)."=".$temp[1].
"&date".($i+1)."=".$temp[2].
"&year".($i+1)."=".$temp[3].
"&time".($i+1)."=".$temp[4].
"&message".($i+1)."=".$temp[5]);
}
echo("&max=".$max);
}
if ($command=="sign"){
if ($name!="" && $message!=""){
$fp=fopen("guest.db","a");
fputs($fp, rawurlencode(StripSlashes($name))."||".
rawurlencode(StripSlashes($email))."||".
rawurlencode(date("M d"))."||".
rawurlencode(date("Y"))."||".
rawurlencode(date("H:i"))."||".
rawurlencode(StripSlashes($message))."\n");
fclose($fp);
}
echo("done=1");
}
?>


Now i want to replace the guest.db with guest.xml. My xml doc has the following structure:

<?xml version="1.0" standalone="yes" ?>
<Guestbook>
<Message Name="" Email="" Date="" Time="" Words=""/>
</Guestbook>

I think i must replace the guest.db file in the php-script with guest.xml, right?
But how do i rewrite the php-script so that it has the xml doc as output??

Long story i know,
Greetz
D-flyer

[D-flyer]

I am a little bit closer to the solution. I use the following php:

<?PHP

if ($command=="sign"){

$info=file("guest.xml");

if ($naam!="" && $words!=""){
/* open.xml file en schrijf naar het einde v/h bestand*/
$fp=fopen("guest.xml","a");

$tofile.="<"."?"."xml version=\"1.0\""."?".">\n";
$tofile.="<guestbook>\n";


$tofile.="\t<message>\n";
$tofile.="\t\t<naam>".$naam."</naam>\n";
$tofile.="\t\t<email>".$email."</email>\n";
$tofile.="\t\t<words>".$words."</words>\n";
$tofile.="\t</message>\n";


$tofile.="</guestbook>\n";

fwrite($fp,$tofile);
fclose($fp);

}
echo("done=1");
}
?>


If my guestbook is clean (no entries) than this PHP generates a valid .xml file. But with a second entry i get a invalid .xml file.

How do i enable this php script so that it doesn't write the xml-declaration and the <guestbook> tags with other entries?

Grtz,
D-flyer

[qslack]

You should probably use PHP's XML support (http://php.net/manual/en/ref.xml.php) instead of parsing it with regexps.

[WALoeIII]

Just have it add the lines in the middle, and have it write to an xml file that you already wrote the declaration in.

<?PHP 

if ($command=="sign"){ 

$info=file("guest.xml"); 

if ($naam!="" && $words!=""){ 
/* open.xml file en schrijf naar het einde v/h bestand*/ 
$fp=fopen("guest.xml","a");
$tofile.="\t<guestbook>\n"; 
$tofile.="\t<message>\n"; 
$tofile.="\t\t<naam>".$naam."</naam>\n"; 
$tofile.="\t\t<email>".$email."</email>\n"; 
$tofile.="\t\t<words>".$words."</words>\n"; 
$tofile.="\t</message>\n"; 
$tofile.="\t</guestbook>\n"; 
fwrite($fp,$tofile); 
fclose($fp); 

} 
echo("done=1"); 
} 
?>

And then go and write yourself an xml document with the declaration.

[WALoeIII]

does that work? or do you have to insert the new data between the guestbook tags, and may only have them once.

[D-flyer]

Snoozy,
Indeed i only (can) use the <guestbook> tags once. So what is a way to accomplish this?

[D-flyer]

qslack --> I am going to parse .xml thru flash 5, but thx for the linkage.

I know i have to use it someday