PHP write to XML file

Yrogerg

I'm trying to write to an xml file, but I don't want to overwrite anything, just append the file. Also, I have to create the new line on line 2 as illustrated:

The XML:

<threads>
  <thread subject="ONE SMALL STEP" date="08.01.02" body="TEST"/>
</threads>

So, the idea is to be able to add more and more threads on top of the current thread without overwriting older ones.

So I'd need the file pointer to create a new line just beneath '<threads>'.

Any takers?
Thanks.

theslinky

I haven't tested this code, but try it anyway 🙂

<?php

// ... some code to set the new thread txt ...
$newthread = "<thread subject=\"new thread\">";


// get file contents
$contents = file("myfile.xml");

$newcontents = "";

foreach($contents as $line) {
    if($line != "<threads>") {
        $newcontents .= $line;
    }
    else {
        $newcontents .= $line;
        $newcontents .= $newthread . "\n"; // don't add the newline if you've already added it in $newthread before
    }
}

// now write the file
$fd = fopen("myfile.xml", "w");
fwrite($fd, $newcontents);
fclose($fd);

?>

Yrogerg

Thanks for the reply but I just get a blank page and my XML is unchanged. Here's my code:

                $Lsubject = $_POST['subject'];
	$subject = strtoupper($Lsubject);
	$Lbody = $_POST['body'];
	$body = strtoupper($Lbody);
	$date = date(m ."." . d . "." . y);

$thread  = '<thread ';
$thread .= 'subject="' . $subject . '" ';
$thread .= 'date="' . $date . '" ';
$thread .= 'body="' . $body . '"';
$thread .= '/>';

echo($thread);

$file = "../xml/threads.xml";
$contents = file($file);
$newcontents = "";

foreach($contents as $line) {
	if($line != "<threads>") {
    $newcontents .= $line;
	}
	else {
    	$newcontents .= $line;
    	$newcontents .= $thread . "\n";
	}
}

$fp = fopen($file, "w");
fwrite($fp, $newcontents);
fclose($fp);

theslinky

Okay, the error is in this line, sorry 🙂

change:

if($line != "<threads>") {

if(rtrim($line) != "<threads>") {

the rtrim will temporarily remove the \n character at the end of the <threads> line. also, the if comparison is case-sensitive. use eregi if you want to do an insensitive search (or regexp/wildcard search).

-sridhar

Yrogerg

Rawk on. Many thanks.

Peredy

This is EXACTLY what I have been looking for for days.. Can you tell me how that would go if I needed the xml file to read...

<songs>

 <song title="songtitle" artist="bandname" path="mp3file"/>
 <song title="songtitle" artist="bandname" path="mp3file"/>
 <song title="songtitle" artist="bandname" path="mp3file"/>
 <song title="songtitle" artist="bandname" path="mp3file"/>
 <song title="songtitle" artist="bandname" path="mp3file"/>


</songs>

Here is the thing, I'm calling the info from my database called bschedule and the table is epk the fields within it are $name $songtitle $songlink

The info is already in the database.

I do want it to overwrite the xml file as the info in the database changes, as this works for a play list in a flash mp3 player.

Here is what I have tried from yours but am getting error each time...

<?php
include("epkheader.inc");

 // read in the connection settings
    require("bsadmin/dbconnection.txt");

// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass") 
    or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");

// select the database
mysql_select_db("$database",$db) 
    or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");


            $link = "SELECT * FROM epk";
            $result = mysql_query($link);
            if (!$result) {
                             die('Could not query:' . mysql_error());
                                            }
                                            $row = mysql_fetch_assoc($result);




$name = strtoupper($name); 
$songtitle = strtoupper($songtitle); 
$songlink = strtoupper($songlink); 

$thread .= '<songs '; 
$thread .= 'song title="' . $songtitle . '"; 
$thread .= 'artist="' . $name . '"; 
$thread .= 'path="' . $songlink . '"; 
$thread .= '/>'; 






echo($thread); 

$file = "songInfo.xml"; 
$contents = file($file); 
$newcontents = ""; 

foreach($contents as $line) { 
    if(rtrim($line) != "<songs>") { 
    $newcontents .= $line; 
    } 
    else { 
        $newcontents .= $line; 
        $newcontents .= $thread . "\n"; 
    } 
} 

$fp = fopen($file, "w"); 
fwrite($fp, $newcontents); 
fclose($fp); 

?>

<style type="text/css">
BODY {

margin-bottom:0;
margin-top:0; 
margin-right:0; 
margin-left:0;
background-color:none;

scrollbar-face-color:black;
scrollbar-highlight-color:black;
scrollbar-3dlight-color:gray;
scrollbar-darkshadow-color:black;
scrollbar-shadow-color: black;
scrollbar-arrow-color:gray;
scrollbar-track-color:black;


}
</style>
<title>MP3 player</title><body link="#CCCC00" vlink="#CCCC00" alink="#FFFFFF" text="#CCCCCC" >
<table width="36%" border="0" align="center">
  <tr>
    <td><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Sounds</font></b></td>
  </tr>
  <tr>
    <td><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="340" height="171" align="absmiddle">
        <param name=movie value="bsadmin/music/player.swf">
        <param name=quality value=high><param name="SCALE" value="exactfit"><param name="BGCOLOR" value="#000000">
        <embed src="bsadmin/music/player.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="340" height="171" align="absmiddle" scale="exactfit" bgcolor="#000000">
        </embed> 
      </object></td>
  </tr>
  <tr>
    <td><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2">Downloads: 
      </font></td>
  </tr>
</table>

Any help would be greatly appreciated. XML confuses me greatly so I would love to be able to just do it this way. I am creating an edit form page to edit the contents in the playlist that will read back to the xml file from the php which will execute when the mp3 player is went to since it is in the php page.

Am I rambeling? haha. Sorry. I am excited to see if this thing can work.

Peredy