XML Response Search Page with PHPq

[mateo107]

I have three XML RESPONSE files generated from another application.

I'd like to create a PHP search page -with a simple text box and "search" button. When a user enters text into the search field, the page will search the first and last name fields for matches and display these fields plus the extension number field in a table (it must search all three files). I am having a LOT of trouble coding this, but I think using SimpleXML will suffice.

I need coding help from the top down on this one - as I generally code in VB.net.

An example of the XML response file is:

<response method="switchvox.extensions.search">
	<result>
		<extensions page_number="1" total_pages="1" items_per_page="500" total_items="3">
		    	<extension number="1111" status="1" can_dial_from_ivr="1" account_id="1446" display="John Smith" date_created="2009-12-23 11:57:36" type="sip" type_display="SIP Extension" first_name="John" last_name="Smith" email_address="[e-mail]" template_id="1187"  template_name="Basic User" phone_password_score="50" voicemail_password_score="40" lang_locale="en_us" title="" location="" profile_image_id="" profile_image_link="https://192.168.192.168/dl?cmd=profile_image&amp;amp;cs=0&amp;amp;id=0&amp;amp;hash=de6de8233830fdc935aae4ffe7003a85" />
		    	<extension number="1112" status="1" can_dial_from_ivr="1" account_id="1611" display="Jane Doe" date_created="2011-02-28 13:08:45" type="sip" type_display="SIP Extension" first_name="Jane" last_name="Doe" email_address="[e-mail]" template_id="1186"  template_name="Basic Station" phone_password_score="104" voicemail_password_score="40" lang_locale="en_us" title="Project Manager" location="1st Floor" profile_image_id="" profile_image_link="https://192.168.192.168/dl?cmd=profile_image&amp;amp;cs=0&amp;amp;id=0&amp;amp;hash=de6de8233830fdc935aae4ffe7003a85" />
		    	<extension number="1113" status="1" can_dial_from_ivr="1" account_id="1369" display="Roger Testerson" date_created="2009-12-16 12:23:28" type="sip" type_display="SIP Extension" first_name="Roger" last_name="Testerson" email_address="[e-mail]" template_id="1187"  template_name="Basic User" phone_password_score="50" voicemail_password_score="40" lang_locale="en_us" title="" location="" profile_image_id="" profile_image_link="https://192.168.192.168/dl?cmd=profile_image&amp;amp;cs=0&amp;amp;id=0&amp;amp;hash=de6de8233830fdc935aae4ffe7003a85" />
		    		</extensions>
	</result>
</response>

[NogDog]

Here's a somewhat quick and dirty example (e.g. not much error-checking) using the [man]DOM[/man] classes:

<?php
function search($name, $file)
{
   $result = array();
   $dom = new DOMDocument();
   $text = file_get_contents($file) or die("could not read '$file'");
   $dom->loadXML($text);
   $extension = $dom->getElementsByTagName('extension');
   foreach($extension as $ext) {
      $fullName = $ext->getAttribute('last_name').' '.$ext->getAttribute('last_name');
         if(stripos($fullName, $name) !== false) {
         $result[] = array(
            'first_name' => $ext->getAttribute('first_name'),
            'last_name' => $ext->getAttribute('last_name'),
            'number' => $ext->getAttribute('number')
         );
      }
   }
   return $result;
}

$data = search('Doe', 'test.xml');
echo "<ul>\n";
foreach($data as $ext) {
   echo "<li>{$ext['first_name']} {$ext['last_name']}: {$ext['number']}</li>\n";
}
echo "</ul>\n";