Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" ?>
- - <users>
- - <uploader ID="11">
- <Name>moz</Name>
- <Photos_Uploaded>2</Photos_Uploaded>
- </uploader>
- </users>
- $xml_Doc = new DOMDocument();
- $xml_Doc->load('photo.xml');
- $statistics="SELECT firstname AS 'user', count( * ) AS 'num',member_id AS ID
- FROM members
- JOIN member_photo
- USING ( member_id )
- GROUP BY firstname ";
- $result= mysql_query($statistics);
- while($row=mysql_fetch_assoc($result)) {
- $uploader=$xml->addChild('uploader');
- $uploader->addAttribute('ID',$row['ID']);
- $uploader->addChild('Name', $row['user']);
- $uploader->addChild('Photos_Uploaded', $row['num']);
- $xml->asXML('');
- }
- $xml_data = '<?xml version="1.0" ?><users><uploader ID="11"><Name>moz</Name><Photos_Uploaded>2</Photos_Uploaded></uploader></users>';
- $xml = simplexml_load_string($xml_data);
- $xml->uploader->Photos_Uploaded = 3;
- echo $xml->asXML();
- <?xml version="1.0"?><users><uploader ID="11"><Name>moz</Name><Photos_Uploaded>3</Photos_Uploaded></uploader></users>
- //load xml
- $xml = simplexml_load_file('photo.xml');
- // modifiy
- //your code..
- // save it back
- $xml->asXML('photo.xml');
Add Comment
Please, Sign In to add comment