Read xml file from last entry

[vjayis]

hi

i have a xml file which has transaction details of the users.

I m inserting data using appendChild() from php.

While displaying i need to display the last 5 entry or single entry or the whole entries descending using php.

Is there anyway to read the xml file from the lastentry using php...


regards
vijay

[Dormilich]

you can read XML in PHP either by DOMDocument or SimpleXML

[vjayis]

Yes i can.,

but i need to read the entries descendingly.. i cant figure it out from the definitions..

any suggestions..

[Dormilich]

@vjayis
sorted or as they appear in the file? (the elements are usually sorted in document order, so you can read the NodeList and do any DOM functions with it that you need)

you may consider reading them into an array and apply any array functions you need. other than that you may use XSLT (which has a sort command).

[vjayis]

here is my file contents

<?xml version="1.0" encoding="utf-8"?>
<trans>
    <transfer>
        <id>1</id>
        <acno>B900326</acno>
        <amount>10000</amount>
        <type>Credit</type>
        <memo>(Credit)memo!@#$%^&amp;*()_+|}{":?&gt;&lt;</memo>
        <fee>0</fee>
        <ft_acno>Admin</ft_acno>
        <batch>1</batch>
        <tempbalance>10000</tempbalance>
        <date>2009-07-11</date>
        <time>1247288167</time>
    </transfer>
    <transfer>
        <id>2</id>
        <acno>P587178</acno>
        <amount>98</amount>
        <type>Credit</type>
        <memo>test</memo>
        <fee>2</fee>
        <ft_acno>B900326</ft_acno>
        <batch/>
        <tempbalance>98</tempbalance>
        <date>2009-07-11</date>
        <time>1247288200</time>
    </transfer>
    <transfer>
        <id>3</id>
        <acno>B900326</acno>
        <amount>100</amount>
        <type>Debit</type>
        <memo>test</memo>
        <fee>0</fee>
        <ft_acno>P587178</ft_acno>
        <batch/>
        <tempbalance>9900</tempbalance>
        <date>2009-07-11</date>
        <time>1247288200</time>
    </transfer>
    <transfer>
        <id>4</id>
        <acno>P662318</acno>
        <amount>196</amount>
        <type>Credit</type>
        <memo>testing</memo>
        <fee>4</fee>
        <ft_acno>B900326</ft_acno>
        <batch/>
        <tempbalance>196</tempbalance>
        <date>2009-07-13</date>
        <time>1247460597</time>
    </transfer>
    <transfer>
        <id>5</id>
        <acno>B900326</acno>
        <amount>200</amount>
        <type>Debit</type>
        <memo>testing</memo>
        <fee>0</fee>
        <ft_acno>P662318</ft_acno>
        <batch/>
        <tempbalance>9700</tempbalance>
        <date>2009-07-13</date>
        <time>1247460597</time>
    </transfer>
 </trans>
 

there are totally 5entry's in it.

i need to display it in descending order.

I had found an way to display it in the descending order as follows..

<?
$filename='test.xml';
 
$data = simplexml_load_file($filename);
 
$c=count($data->transfer);
 
for($i = $c; $i>=0 ; $i--){
 
  echo $i.'-'.$data->transfer[$i]->time.'<br>';
 
}
?>
 

which results in giving the the output as follows

6-
5-1251866501
4-1251866308
3-1251804653
2-1251802528
1-1251802455
0-1251802411


Did i followed the correct way?

or is there an anyother formatted approach for this one?

And can i make a search and display results in xml file like doing in sql...

if there give me some ideas..

[Dormilich]

// last index is usually 1 lower than length
for($i = $c-1; $i>=0 ; $i--){

And can i make a search and display results in xml file like doing in sql...

you can use XPath to search if you want to stay inside XML or use PHP to look inside the XML string, depending on the search requirements.

[vjayis]

ya thats what i m asking.,

how can search inside xml file using php without using any loops.

any examples..

[Dormilich]

@vjayis
what do you need loops for?

[vjayis]

k fine if i need to display items with date='2009-07-11' from the above example means how can i do that..

[Dormilich]

guess I’d use XPath (you could also do a text search, but it would be more complicated to get the items…)

XPath (get all items with a given date)

//transfer[date="_date_"]