Save to a XML document using php problem

Question

Hey all. I'm trying to save A XML file using php. here is my code, the connection to the DB is okay and all, i can use $dom->saveXML() but the save function isn't saving nothing. please help.

<?
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
} 

// Select all the rows in the markers table

$query = "SELECT * FROM Listing_Arnona WHERE 1";
$result = mysql_query($query);
if (!$result) {  
  die('Invalid query: ' . mysql_error());
} 



// Iterate through the rows, adding XML nodes for each

while ($row = @mysql_fetch_assoc($result)){  
  // ADD TO XML DOCUMENT NODE  
  $node = $dom->createElement("marker");  
  $newnode = $parnode->appendChild($node);   
  $newnode->setAttribute("Price",$row['Price']);
  $newnode->setAttribute("PriceS", $row['Price']);  
  $newnode->setAttribute("address", $row['street_name']);  
  $newnode->setAttribute("NumRooms", $row['Room_Num']);  
  $newnode->setAttribute("PROMO", $row['PROMO']);
} 

$dom->formatOutput = true; 
$test1 = $dom->saveXML(); // put string in test1
$dom->save('test1.xml'); // save as file

?>

Do you have write permissions to test1.xml? Are you able to successfully output $test1 to the browser? — user142162
– user142162, Commented Mar 18, 2011 at 2:04
What does $dom->save('test1.xml') return? If it returns false, it can't write the file (and most probably that is a permissions issue). — Jon
– Jon, Commented Mar 18, 2011 at 2:04
isn't saving nothing? Ah, gotta love them double negatives. What is it saving? — Marc B
– Marc B, Commented Mar 18, 2011 at 2:05
@Tim $test1 in browser is alright, i didn't check what it returns, i have full root access — Tom
– Tom, Commented Mar 18, 2011 at 2:06
having full root access doesn't mean that script can write to that particular directory. Can you check if it's indeed able to write to that directory? — ariefbayu
– ariefbayu, Commented Mar 18, 2011 at 2:09

Tom · Accepted Answer · 2011-03-18 02:12:23Z

1

The problem as everyone pointed out was the writing permissions. i opend a new folder name 'xml' with chmod 777 and changed the code to:

$dom->save('xml/test1.xml');

Thank you all.

answered Mar 18, 2011 at 2:12

Tom

9,69526 gold badges96 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jon Over a year ago

Excuse me for being blunt, but you didn't check the return value of the function before posting? Priceless... php.net/manual/en/domdocument.save.php

Collectives™ on Stack Overflow

Save to a XML document using php problem

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related