Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <ArrayOfUnitDTO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <UnitDTO>
- <Category>Category name</Category>
- <code>863</code>
- <Status>Blocked</Status>
- <RefNo>12345</RefNo>
- <Images>
- <Image>
- <Title>Community</Title>
- <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>
- </Image>
- <Image>
- <Title>Local Area Image</Title>
- <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>
- </Image>
- </Images>
- </UnitDTO>
- </ArrayOfUnitDTO>
- foreach ($listings ->UnitDTO as $listingInfo) //loop read xml
- {
- $RefNo = $listingInfo->RefNo;
- $Category = $listingInfo->Category;
- $code = $listingInfo->code;
- $Status = $listingInfo->Status;
- mysqli_query($link,"REPLACE INTO UnitDTO (`RefNo`, `Category`, `code`, `Status`) VALUES ('$RefNo', '$Category', '$code', '$Status',)") or die(mysqli_error($link));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement