Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. <ArrayOfUnitDTO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  2. <UnitDTO>
  3. <Category>Category name</Category>
  4. <code>863</code>
  5. <Status>Blocked</Status>
  6. <RefNo>12345</RefNo>
  7. <Images>
  8. <Image>
  9. <Title>Community</Title>
  10. <ImageURL>http://imageaddress.com/images/watermark.aspx?imageurl=/uf/1015/GroupUpdate/unit/350/350_Image.jpg&width=640&group=1015&module=1&watermarktype=default&position=Center</ImageURL>
  11. </Image>
  12. <Image>
  13. <Title>Local Area Image</Title>
  14. <ImageURL>http://imageaddress.com/images/watermark.aspx?imageurl=/uf/1015/GroupUpdate/unit/631/631_Image.jpg&width=640&group=1015&module=1&watermarktype=default&position=Center</ImageURL>
  15. </Image>
  16. </Images>
  17. </UnitDTO>
  18. </ArrayOfUnitDTO>
  19.  
  20. foreach ($listings ->UnitDTO as $listingInfo) //loop read xml
  21. {
  22. $RefNo = $listingInfo->RefNo;
  23. $Category = $listingInfo->Category;
  24. $code = $listingInfo->code;
  25. $Status = $listingInfo->Status;
  26.  
  27. mysqli_query($link,"REPLACE INTO UnitDTO (`RefNo`, `Category`, `code`, `Status`) VALUES ('$RefNo', '$Category', '$code', '$Status',)") or die(mysqli_error($link));
  28.  
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement