Read from a text file after a specific word

Posted on 16th Feb 2014 07:03 pm by admin

Hi all.

I have a text file that looks like the one below.
I know how to open the text file but I need to get the php pointer to take a value suck as $username. Once it finds $username, i need it to move to the next following MonthUp"> and then read the number after it and save it to the string $monthup. I will be doing the same for $monthdown and then closing the file.

Eg. If the value is $username, i need to find the first occurance of that username, find the number after MonthUp"> and read it to $monthup, then move to MonthDown"> and then read the number after it to $monthdown.
I will then use php to add the numbers together so that I can show the user when they enter their username into the website, how much they have used for the month.

I am just learning php and all I can find so far from google is reading line-by-line which i want to read after a specific word as I need to do this for a few different files and line by line wont work.


File - stats.cfg - can be renamed to stats.txt easily.
<config>
<list name="UserStats">
<listitem>
<variable name="Id">288A5772-2964-4701-9E66-765F3CECE522</variable>
<variable name="Name">all users</variable>
<variable name="DayUp">32729762</variable>
<variable name="DayDown">336451305</variable>
<variable name="WeekUp">982718994</variable>
<variable name="WeekDown">5711384480</variable>
<variable name="MonthUp">15542938381</variable>
<variable name="MonthDown">106022753555</variable>
<variable name="TotalUp">441879285577</variable>
<variable name="TotalDown">1763579705023</variable>
<variable name="Since">1210849661</variable>
<variable name="Timestamp">1256258234</variable>
<variable name="FullName">all users</variable>
</listitem>
<listitem>
<variable name="Id">807459fd-71a9-467d-bf0c-f0ce98fef937</variable>
<variable name="Name">Administrator</variable>
<variable name="DayUp">0</variable>
<variable name="DayDown">0</variable>
<variable name="WeekUp">0</variable>
<variable name="WeekDown">0</variable>
<variable name="MonthUp">0</variable>
<variable name="MonthDown">0</variable>
<variable name="TotalUp">995621942</variable>
<variable name="TotalDown">6089875753</variable>
<variable name="Since">1210849662</variable>
<variable name="Timestamp">1256224866</variable>
<variable name="FullName"></variable>
</listitem>
<listitem>
<variable name="Id">9cd97dd4-f902-4811-ad05-372658c8ec64</variable>
<variable name="Name">Mathew</variable>
<variable name="DayUp">0</variable>
<variable name="DayDown">0</variable>
<variable name="WeekUp">0</variable>
<variable name="WeekDown">0</variable>
<variable name="MonthUp">36809697</variable>
<variable name="MonthDown">565151504</variable>
<variable name="TotalUp">1739819196</variable>
<variable name="TotalDown">26628701150</variable>
<variable name="Since">1210849662</variable>
<variable name="Timestamp">1256257815</variable>
<variable name="FullName">mathew</variable>
</listitem>

Your Answer:

Login to answer

Other forums

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Socket problem
Hello,

Earlier I posted about my problem with my socket script. It took up to 100% CPU usage.

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

Problem with variable declaration in switch statement
Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I a

Adding Outlook 2007 items via file upload
I am looking for a way to be able to attach an Outlook item (an email message) in an ASP.NET 3.5 app

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi