extract a text file using php

guys how just want to know how do i capture the data on a text file and save it into mysql database



sample text file.




---------------------------------------------
Firm: AAA Trader: 333

The quick brown fox
Deal Confirm Ticket

Contra: 777 Trader: 333
Confirm: 10,828 08/10/2007 12:09
Order: 3024773 P/C: C L/F: F

Account: AB Board: S

Bought: MRT 200,000 @ 53.5
---------------------------------------------
Firm: AAA Trader: 333

The quick brown fox
Deal Confirm Ticket

Contra: 777 Trader: 333
Confirm: 10,828 08/10/2007 12:09
Order: 3004772 P/C: C L/F: F

Account: AD Board: C

Sold: MRT 205,000 @ 57.5
---------------------------------------------
Firm: AAA Trader: 333

The quick brown fox
Deal Confirm Ticket

Contra: 777 Trader: 333
Confirm: 10,812 08/10/2007 12:09
Order: 3004766 P/C: C L/F: F





I want to save the values of :

Firm
Trader
Contra
Confirm
date
time
order
P/C
L/F

 

<?php

$contents = file_get_contents('textfile.txt');

preg_match('/Firm: (.+) Trader: (.+)/', $contents, $m);
list(, $data['firm'], $data['trader']) = $m;

... follow pattern

preg_match('~Order: (.+) P/C: (.+) L/F: (.+)~', $contents, $m);
list(, $data['order'], $data['p-c'], $data['l-f']) = $m;

print_r($data);

?>

PHP:

 

Thanks for that. i also wanted to know this. very handy