Guest User

Untitled

a guest
Jun 19th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. <?xml version="1.0" ?>
  2. - <users>
  3. - <uploader ID="11">
  4. <Name>moz</Name>
  5. <Photos_Uploaded>2</Photos_Uploaded>
  6. </uploader>
  7.  
  8. </users>
  9.  
  10. $xml_Doc = new DOMDocument();
  11. $xml_Doc->load('photo.xml');
  12.  
  13.  
  14. $statistics="SELECT firstname AS 'user', count( * ) AS 'num',member_id AS ID
  15. FROM members
  16. JOIN member_photo
  17. USING ( member_id )
  18. GROUP BY firstname ";
  19. $result= mysql_query($statistics);
  20.  
  21.  
  22. while($row=mysql_fetch_assoc($result)) {
  23.  
  24. $uploader=$xml->addChild('uploader');
  25. $uploader->addAttribute('ID',$row['ID']);
  26. $uploader->addChild('Name', $row['user']);
  27. $uploader->addChild('Photos_Uploaded', $row['num']);
  28. $xml->asXML('');
  29.  
  30. }
  31.  
  32. $xml_data = '<?xml version="1.0" ?><users><uploader ID="11"><Name>moz</Name><Photos_Uploaded>2</Photos_Uploaded></uploader></users>';
  33. $xml = simplexml_load_string($xml_data);
  34. $xml->uploader->Photos_Uploaded = 3;
  35. echo $xml->asXML();
  36.  
  37. <?xml version="1.0"?><users><uploader ID="11"><Name>moz</Name><Photos_Uploaded>3</Photos_Uploaded></uploader></users>
  38.  
  39. //load xml
  40. $xml = simplexml_load_file('photo.xml');
  41. // modifiy
  42. //your code..
  43. // save it back
  44. $xml->asXML('photo.xml');
Add Comment
Please, Sign In to add comment