SimpleXML and php - get a node that contains text that matches another node

Question

I am trying to display the text content of a Node, if the content of that node matches another node (sibling). Here is the XML:


    
        
            
                20140605
                20140605
                PR DED
                Account payroll deduction
                SJ1550
                ACCOUNT PAYROLL DEDUCTION
                -11.77
                0.00
                0.00
                0.00
                0.00
                -11.77
                PR DED
                20140605
            

            
                20140605
                20140605
                03128862
                Mountain Mkt Sales
                SJ1553
                MOUNTAIN MKT SALES
                8.99
                0.00
                0.00
                0.61
                0.00
                9.60
                03128862
                20140605
            
        
    
    
    
    03128862

I am successfully displaying each ChitCode and ChitDate, because they are in the Line[@number] Node. I want to display the Body node that contains the text "Chit#: XXXXXX" where xxxxxx matches Line->ChitCode. Here is my php, it displays the Body, but it displays the first Body for all the line items:

ChitCode."-".$Line->ChitDate."'>".$Line->Description."
            
            "; 
            // Creates hide - show link for each Description item
            // Start getting the matching Chit Code from Chit/Body                          

            if ($Chit->Code = $Line->ChitCode)
            {
                echo $Chit->Body."";
            }
            else
            {
                echo " ".$Line->ChitCode."";
            } // End If
        } //End  foreach Linequery
    } // End foreach Chitquery
?>

It's the echo $Chit->Body.""; that I need help with, I want to display the Body that contains the value of $Line->ChitCode.

Oh yeah, and the lines are repeating weird, due to improper placement of 'foreach' statements! screenshot of lists Help! Thanks in advance!

UPDATE: I have changed my php code and now I have the hide-show divs working, with no duplicates, but I get 'array' instead of $ChitBody. I cannot figure out how to find the Body node that contains the $Line->ChitCode in $ChitBody = $member->xpath('Chits/Chit/Body[text()="'.$Line->ChitCode.'"] ');

Chits->Chit->Code;
                        $ChitBody = $member->xpath('Chits/Chit/Body[text()="'.$Line->ChitCode.'"] ');
                        echo "".$Line->Description."
                         "; // Creates hide - show link for each Description item
                        // Start getting the matching Chit Code from Chit/Body                          
                            if ($ChitCode = $Line->ChitCode) {
                            echo "Code: ".$ChitCode."
".$ChitBody."";
                            } else {
                            echo "".$Line->ChitCode."";
                            } // End If
                        } //End  foreachLinequery
                     ?>

enter image description here

hakre · Accepted Answer

You are most likely looking for xpath to query you document.

for example to iterate over the lines - I don't fully understand why you do it the way you do it, but here is how I understand it to go over the lines (text-only output):

$xml = simplexml_load_string($buffer);

foreach ($xml->xpath('//Details/Line') as $line)
{
    printf("#%d: %s
", $line['NUMBER'], $line->Description);            
}

which gives:

#0: Account payroll deduction
#1: Mountain Mkt Sales

I guess you see how this works in general. So now for getting chit based on $line->ChitCode, which is I think actually the more interesting part for you. It also better illustrates the benefits of xpath:

foreach ($xml->xpath('//Details/Line') as $line)
{
    printf("#%d: [%s] %s
", $line['NUMBER'], $line->ChitCode, $line->Description);

    $query  = sprintf("//Chits/Chit[Code = '%s']/Body", $line->ChitCode);
    $result = $xml->xpath($query);

    if ($result) {
        $chit = $result[0];
        echo $chit;
    } else {
        echo ' -- no chit found -- ';
    }
    echo "
";
}

This time the query contains the condition to look for the number (in case you want to make this save, escape the string properly (more info)), it basically creates the following two xpath queries:

//Chits/Chit[Code = 'PR DED']/Body

//Chits/Chit[Code = '03128862']/Body

I again guess you can imagine what those mean. In case such a element is found, the code above outputs it. And this is how the result looks like:

#0: [PR DED] Account payroll deduction
 -- no chit found -- 
#1: [03128862] Mountain Mkt Sales

        Member#: 0ECHER
        Name: *******
        Area:  *********
        Server: JEANNEANE
        Chit#: 03128862
        Date:  June 5 2014
        ------- ------- ------- ------- -------
        1       MINGUA BEEF JER            8.99
        ------- ------- ------- ------- -------
        Sub-Total                          8.99


        TAX                                0.61
        ------- ------- ------- ------- -------
        Chit Total                         9.60



        MEMBER CHARGE                     -9.60

I hope this gives you enough insight to get started with it. xpath() is just a method on SimpleXMLElement so you can combine this as well with your code which I didn't copy just to have the example smaller (same reason why I use plain text output here, would work equally with HTMl but would bloat the example).

Addition by OP:

THAT WORKED GREAT!!

I adapted your code to this, and it worked perfectly:

foreach ($Linequery as $Line) {
    $LineChitCode = $Line->ChitCode;
    $ChitBody     = sprintf("//Chits/Chit[Code = '%s']/Body", $LineChitCode);
    $CBresult     = $member->xpath($ChitBody);
    echo "" . $Line->Description . "
                             "; // Creates hide - show link for each Description item
    // Start getting the matching Chit Code from Chit/Body                            
    if ($CBresult) {
        $chit = $CBresult[0];
        echo "Code: " . $LineChitCode . "
" . $chit . "";
    } else {
        echo "" . $Line->ChitCode . "";
    }
}

Thank you, you saved me from 3 days of trying to figure this out!!

SimpleXML and php - get a node that contains text that matches another node

Answers (2)

Related Questions