Processing an XML document in Javascript

[Sebarry]

Hi,

I have a Javascript function that creates a Ajax request to retrieve data from a database using a PHP script. The data returned by the PHP script is an XML Document that I access through transport.responseXML. The structure of the XML document is as follows:

<job>
<contactTelephone>028 ---------</contactTelephone>
<contactName>Karen -------</contactName>
<contactFax>028 -----------</contactFax>
<contactEmail>karen@---------</contactEmail>
<contactWebsite>www.---------</contactWebsite>
</job>

I use var xmlOptions = xmlDoc.getElementsByTagName('job'); to get job and then xmlOptions[0].getElementsByTagName('contactTelephone')[0].firstChild.data but can I use a for loop to process the XML document tag by tag without hardcoding it? Using a variable in getElementsByTagName?

Thanks,

Sean

[epots9]

Hi,

I have a Javascript function that creates a Ajax request to retrieve data from a database using a PHP script. The data returned by the PHP script is an XML Document that I access through transport.responseXML. The structure of the XML document is as follows:

<job>
<contactTelephone>028 ---------</contactTelephone>
<contactName>Karen -------</contactName>
<contactFax>028 -----------</contactFax>
<contactEmail>karen@---------</contactEmail>
<contactWebsite>www.---------</contactWebsite>
</job>

I use var xmlOptions = xmlDoc.getElementsByTagName('job'); to get job and then xmlOptions[0].getElementsByTagName('contactTelephone')[0].firstChild.data but can I use a for loop to process the XML document tag by tag without hardcoding it? Using a variable in getElementsByTagName?

Thanks,

Sean

i got mine working with for loops try this:

var xmlData = xmlDoc.documentElement;
 

the u would have to do:

alert(xmlData.childNodes[0].childNodes[0].nodeValue);
 

the second snipplet u will have to change....depending on your xml structure.

good luck

[pbmods]

Heya, Sebarry. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

[Sebarry]

i got mine working with for loops try this:

var xmlData = xmlDoc.documentElement;
 

the u would have to do:

alert(xmlData.childNodes[0].childNodes[0].nodeValue);
 

the second snipplet u will have to change....depending on your xml structure.

good luck

Hi, Can you post your code in full. I've tried what you suggested but I can't get it to work. Sorry :(.

[epots9]

Hi, Can you post your code in full. I've tried what you suggested but I can't get it to work. Sorry :(.

i read your pm, looking at your xml file, test this out:

alert(xmlData.childNodes[0].nodeValue);
 

each childNode is like going one step down...i think we went too far before.

try it and post back.

good luck

[Sebarry]

Hi, me again.

Sorry I seriously do not know what I'm doing wrong. Here's the Javascript code.

 
new Ajax.Request('/iwo/libs/GetJobInfo.php', {
        method: 'get',
          parameters: 'jobIdentifier=' + jobID,
          onSuccess: function(transport){
 
            var xmlDoc = transport.responseXML;
 
            var xmlData = xmlDoc.documentElement;
            alert(xmlData);
 
            try
            {
                alert(xmlData.childNodes[0].nodeValue);
            }
            catch( err )
            {    
                alert(err);
            }
 
 

Followed by the XML document.

 
<?xml version="1.0" encoding="utf-8"?>
 
<job>
 
  <jobContactTelephoneTxt>028 9035 2066</jobContactTelephoneTxt>
 
  <jobContactNameTxt>Karen Topping</jobContactNameTxt>
 
  <jobContactFaxTxt>028 9035 2161    </jobContactFaxTxt>
 
  <jobContactEmailTxt>[e-mail]</jobContactEmailTxt>
 
  <jobContactWebsiteTxt>biosearch.co.uk</jobContactWebsiteTxt>
 
  <jobLocationOpt>Ireland</jobLocationOpt>
 
  <jobStatusOpt></jobStatusOpt>
 
  <jobTitleTxt>Microbiologist</jobTitleTxt>
 
  <jobCompanyTxt>Bio-Search (N.I.) Ltd.</jobCompanyTxt>
 
  <jobReferenceTxt>IWO/ED/17138</jobReferenceTxt>
 
  <jobSalaryRdo>Negotiable</jobSalaryRdo>
 
  <notesFCKEditor>Responsible for: operation of a dedicated algae and cryptosporidium laboratory; maintenance
 
 of UKAS accreditation; reporting of results; conducting internal and external quality control.  Experience
 
 of cryptosporidium analysis essential.</notesFCKEditor>
 
  <jobStartOpt>2007-06-15</jobStartOpt>
 
  <jobCloseOpt>2007-06-29</jobCloseOpt>
 
  <jobLogoImg></jobLogoImg>
 
  <jobCategoryOpt>Scientific</jobCategoryOpt>
 
</job>
 
 

The PHP does the following at the end to complete the XML document.

 
$dom->formatOutput = true;
print $dom->saveXML();
 
 

Please help :(

Sean

[pbmods]

Heya, Sean.

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

[Sebarry]

Hiya,

Thanks for replying. I should change my profile so I know when someone has replied. In answer to your question of what I'm wanting to achieve. I want to write a generic piece of code that will process a XML document given the name of the document root i.e. job. The code should retrieve the node name and node value.

What I have so far is:

 
function getJobInfo(jobID)
{
      new Ajax.Request('/iwo/libs/GetJobInfo.php', {
          method: 'get',
          parameters: 'jobIdentifier=' + jobID,
          onSuccess: function(transport){
 
    var xmlDoc = transport.responseXML;
    var xmlOptions = xmlDoc.getElementsByTagName('job');
 
    alert("Length is: " + xmlOptions.length );
 
    for( i = 0; i < xmlOptions.length; i++ ) 
    {
          alert( "Node name is: " + xmlOptions.item(i).tagName );
          alert( "Node value is: " + xmlOptions.item(i).nodeValue );
    }
 
 

/iwo/libs/GetJobInfo.php

retrieves data from a database and creates and populates the XML document that I want to parse. The XML document will only ever contain the details of one job. As follows.

<?xml version="1.0" encoding="utf-8"?>
<job>
  <jobContactTelephoneTxt>028 9035 2066</jobContactTelephoneTxt>
  <jobContactNameTxt>Karen Topping</jobContactNameTxt>
  <jobContactFaxTxt>028 9035 2161</jobContactFaxTxt>
  <jobContactEmailTxt>[e-mail]</jobContactEmailTxt>
  <jobContactWebsiteTxt>biosearch.co.uk</jobContactWebsiteTxt>
  <jobLocationOpt>Ireland</jobLocationOpt>
  <jobStatusOpt></jobStatusOpt>
  <jobTitleTxt>Microbiologist</jobTitleTxt>
  <jobCompanyTxt>Bio-Search (N.I.) Ltd.</jobCompanyTxt>
  <jobReferenceTxt>IWO/ED/17138</jobReferenceTxt>
  <jobSalaryRdo>Negotiable</jobSalaryRdo>
  <notesFCKEditor>Responsible for: operation of a dedicated algae and   
       cryptosporidium laboratory; maintenance of UKAS accreditation; reporting
       of results; conducting internal and external quality control.  Experience
       of cryptosporidium analysis essential.</notesFCKEditor>
  <jobStartOpt>2007-06-15</jobStartOpt>
  <jobCloseOpt>2007-06-29</jobCloseOpt>
  <jobLogoImg></jobLogoImg>
  <jobCategoryOpt>Scientific</jobCategoryOpt>
</job>
 

However

alert("Length is: " + xmlOptions.length );

reports a length of 1 and

alert( "Node name is: " + xmlOptions.item(i).tagName );
and alert( "Node value is: " + xmlOptions.item(i).nodeValue );

outputs Job and null respectively. Its the nodes under job that I want not job.

I've tried this that works but it requires me to know how many nodes there are and it's not very elegant.

alert(transport.responseXML.documentElement.firstChild.text);
alert(transport.responseXML.documentElement.firstChild.nextSibling.nodeName);
alert(transport.responseXML.documentElement.firstChild.nextSibling.text);
aler(transport.responseXML.documentElement.firstChild.nextSibling.nextSibling.nodeName);
alert(transport.responseXML.documentElement.firstChild.nextSibling.nextSibling.text);
 

Hope you can help,

Sean

Heya, Sean.

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.