Read lines from text file using PHP

[Fab108]

Hello everyone, i am new here. Hmm...can you all please help me with this..what is the code for reading lines from a text file..Thanks =)

[ak1dnar]

Hello everyone, i am new here. Hmm...can you all please help me with this..what is the code for reading lines from a text file..Thanks =)

Hi, Fab108 Welcome to TSDN.

Try these Tutorials

[Fab108]

Thanks for your help, but fgets help us to get the first line for example my text file is

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: B108
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237


And i only want to display from Year onwards, how do i do that using fgets?

[ak1dnar]

Thanks for your help, but fgets help us to get the first line for example my text file is

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: B108
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237


And i only want to display from Year onwards, how do i do that using fgets?

I didn't ask to use just only the fgets().There were number of tutorials on the search result that i supplied.
And one more thing if you want to read this values from a text file there should be a specific format for each and every record.

example:

Mike Johann | 15-02-2005 | [e-mail]
Jessica Moore | 20-10-2000 | [e-mail] 
 
 

for better readability.

The format that you have supplied also can read, but its not a god practice for creating a application. Still i can't understand whether it is a single file or a combination. and is this the only record you have?

[r035198x]

Thanks for your help, but fgets help us to get the first line for example my text file is

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: B108
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237


And i only want to display from Year onwards, how do i do that using fgets?

Use the gets function then .

[Fab108]

I didn't ask to use just only the fgets().There were number of tutorials on the search result that i supplied.
And one more thing if you want to read this values from a text file there should be a specific format for each and every record.

example:

Mike Johann | 15-02-2005 | [e-mail]
Jessica Moore | 20-10-2000 | [e-mail] 
 
 

for better readability.

The format that you have supplied also can read, but its not a god practice for creating a application. Still i can't understand whether it is a single file or a combination. and is this the only record you have?

No i got 1891 records..= (..i am new to php that is why i am so vex now..haha

[ak1dnar]

Is this the structure of your text file or differ than this?

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: B108
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237
Record: 2
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237
Record: 3
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237

And what you meant by saying "year onwards" ?

[Fab108]

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: Data Logger
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237
Latitude: 1.342335
Longitude: 103.776921
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 3
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 47.526634
Latitude: 1.342375
Longitude: 103.776858
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================

This is the text file, from record 1, all the way to 1891.

[ak1dnar]

text.txt

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: Data Logger
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237
Latitude: 1.342335
Longitude: 103.776921
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 3
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 47.526634
Latitude: 1.342375
Longitude: 103.776858
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
 

Try to modify this script as per your requirement.
read_text.php

<?php
$filename = "text.txt";
$fd = fopen ($filename, "r");
$contents = fread ($fd,filesize ($filename));
fclose ($fd);
 
$delimiter = "=====================";
$splitcontents = explode($delimiter, $contents);
 
foreach( $splitcontents as $record )
{
 
echo "$record<hr>";
}
 
?>
 

[Fab108]

Thanks a lot, if i have anymore problem, i will pm you..= )

[ak1dnar]

Thanks a lot, if i have anymore problem, i will pm you..= )

Glad to hear that, Fab108 !
You are welcome ! anytime.
-Ajaxrand

[r035198x]

Thanks a lot, if i have anymore problem, i will pm you..= )

Unfortunately we don't allow technical questions to be asked through PMs. we prefer it for them to be posted here where we all can learn from them.

Sorry for being a spoil sport but those are the rules.

[ak1dnar]

Unfortunately we don't allow technical questions to be asked through PMs. we prefer it for them to be posted here where we all can learn from them.

Sorry for being a spoil sport but those are the rules.

Its my mistake, i really forgot to mention that in my last post.

Do NOT PM questions to individual Experts, Moderators or Administrators

Sorry r035198x.

[Fab108]

Ok i understand, haha i will post my questions if i have any = ) thanks a lot.

[Fab108]

Ok..i got a new problem. After i read the lines, how i convert the data and put into a database?

[bonski]

text.txt

Datalogs:
Date: 2007/6/11
Time: 13:9:3
Device ID: Data Logger
About total Numbers: 001891
===================
=====================
Record: 1
Event Type: 3
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 37.527237
Latitude: 1.342335
Longitude: 103.776921
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 3
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 47.526634
Latitude: 1.342375
Longitude: 103.776858
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
 

Try to modify this script as per your requirement.
read_text.php

<?php
$filename = "text.txt";
$fd = fopen ($filename, "r");
$contents = fread ($fd,filesize ($filename));
fclose ($fd);
 
$delimiter = "=====================";
$splitcontents = explode($delimiter, $contents);
 
foreach( $splitcontents as $record )
{
 
echo "$record<hr>";
}
 
?>
 

this is the same method your going to use with your new problem..

take not of this..

[PHP]$delimiter = "=====================";
$splitcontents = explode($delimiter, $contents);[/PHP]

this is how you extract it from text file...
delimiter is the one that separates your data...
in this format, the delimiter you going to extract is this $delimiter = "=====================";

Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000
=====================
Record: 3
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 47.526634
Latitude: 1.342375
Longitude: 103.776858
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000

results to this...

// first data... inside an array
Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000

// 2nd data inside an array
Record: 3
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 47.526634
Latitude: 1.342375
Longitude: 103.776858
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000

now... to extract each data inside.. so that it will fit in your table with their corresponding fields..
use delimiter $delimiter = "\n"; means new line..

[PHP]$delimiter = "\n";
$data_contents = explode($delimiter, $splitcontents[$i]);[/PHP]

//notice that $splitcontents[$i] is in array already.. 'cause your doing this with an array inside an array..

Record: 2
Event Type: 1
Year: 2007
Month: 6
Day: 7
Hour: 5
Minute: 9
Second: 42.526936
Latitude: 1.342367
Longitude: 103.776861
Altitude: 0.000000
PDOP: 50.000000
HDOP: 50.000000
Satellite No: 3
Speed(KMs/hr): 0.000000
Direction: 0.000000

now the result is would line by line.. now use the same method.. but with a delimiter $delimiter = ':';

remember.. its an array within an array... have fun.. ^___^