adijeff

Hi all,

I thought I would reply to my own post in case anyone else needs help with this. This is the code I used to amend the XML using PHP. I am not a coder, so this is possibly not the most efficient way, but it works!

Essentially, I read the XML file, and go through each <campaign> node, find the imageurl tag and then go through each <event> node within that <campaign> and add the imageurl into that node. Then instead of calling the original XML file, I call the new PHP file:

<?php
$doc = new DOMDocument('1.0', 'utf-8');
$doc->formatOutput = true;
$doc->preserveWhiteSpace = false;
$doc->load("xmlfile.xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>";
echo "<campaigns>";
$xpath = new DOMXpath($doc);
$searchNode = $xpath->query('//campaign'); // find campaign nodes
foreach( $searchNode as $searchNode )
{
     $valueID = $searchNode->getAttribute('id');
			echo "<campaign id=\"" .$valueID. "\">"; // get the campaign id
	//campaignimage
	$xmlUrl = $searchNode->getElementsByTagName( "campaignimage" );
    $valueImage = $xmlUrl->item(0)->nodeValue; // get the imageurl
	$searchEventNode = $xpath->query("campaign[@id='$valueID']//event"); // get all events within our selected campaign (using id)
	foreach( $searchEventNode as $searchEventNode )
	{
		//get venuelocation
		$xmlVenueLocation = $searchEventNode->getElementsByTagName( "venuelocation" );
		$valueVenueLocation = $xmlVenueLocation->item(0)->nodeValue;
		echo "<event>";
		echo "<campaignimage>" .$valueImage. "</campaignimage>";
		echo "<venuelocation>" .$valueVenueLocation. "</venuelocation>";
		echo "</event>";
	}
	echo "</campaign>";
}
echo "</campaigns>";
?>

OK, thanks for your speedy reply. I look forward to the update, and in the mean time, will get the user to scale the slider images first.

Works perfectly – thanks Jeff.

Hah, OK – I thought it was an undocumented feature!

I’ve re-read your post, and you’re suggesting the individual URL mysite.com/testimonials?testimonial_id=5 etc is the default behaviour, without having to manually add the link. This would be ideal.

Thanks again for such quick responses.

OK, thanks, anyway.

When clicking a “read more…” link, I would expect to go to the full article. Please consider this for a future update. Thanks.