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_"]

[vjayis]

sorry i had not used Xpath and i dont know how to implement it into my code..

could you guide me..

[Dormilich]

XPath in SimpleXML: xpath()

XPath Tutorial

XPath is a convenient way to address XML nodes. if you’re familiar with the DOM (e.g. from using Javascript) this shouldn’t be too complicated.

[vjayis]

thanks i ll gothrough it..

(you could also do a text search, but it would be more complicated to get the items…)

how can i do a text search using php..

[Dormilich]

@vjayis

$xmltxt = file_get_contents("test.xml");
// or whichever search function you need
$pos = strpos($xmltxt, $_date_);

the point is, you need some clever code (probably including RegEx) to get the items from that (the XML is treated as a string, not as XML)

[vjayis]

thanks

and i had worked an search from an example

$filename='example.xml';
 
$data = simplexml_load_file($filename);
$op = $data->xpath('/entries/entry[time>1251802411]');
 
   foreach($op as $ops) {
    echo $ops->acno."-".$ops->time."<br />";
   }
 

which outputs

B900326-1251802455
B900326-1251802528
B900326-1251804653
B900326-1251866308
B900326-1251866501

in this how can i search two or more conditions for example.....

acno='B900326' & time>'1251802411'

how to implement it

[Dormilich]

@vjayis
add another square bracket.

node[condition1][condition2]

[vjayis]

ohh yeah thanks yar.,

guess its going to be very easy than sql search....

thanks