“PHP Scripting - Foreach line (of data)” – Forum Thread – Discuss

PHP Scripting - Foreach line (of data)

This is an open discussion with 6 replies, filed under General.

Search

You are looking at page 1 of 1

- FabioPittol
- 29 Oct 11, 1:48 am
- Comment #1

I'm creating a little web app for client here found my self needing to do some PHP scripting, but I'm kinda noob on PHP and as I'm familiarized with you guys I decided to ask for help here. The problem is:

I have this data

0001    01/10/2011  CLIENT X    100,00
0002    05/10/2011  CLIENT Y    150,00
0003    10/10/2011  CLIENT Z    120,00

And I need to render it like this

Document: 0001
Date: 01/10/2011
Client: CLIENT X
Value: 100,00

Document: 0002
Date: 05/10/2011
Client: CLIENT Y
Value: 150,00

Document: 0003
Date: 10/10/2011
Client: CLIENT Z
Value: 120,00

I've already managed to do this with only one line of data by doing the following

<?php 
$data  = "0001  01/10/2011  CLIENT X    100,00";

$array = preg_split("/[t]+/",$data);

echo "Document: ";
echo $array[0];
echo "<br/>Date: ";
echo $array[1];
echo "<br/>Client: ";
echo $array[2];
echo "<br/>Value: ";
echo $array[3];
?>

But turns out I just can't figure out how to do this with multiple lines of data.

Any ideas?

*Sorry for the Off-Topic anyway...

- ashooner
- 29 Oct 11, 2:08 am
- Comment #2

I think you'll want to run an initial preg_split using the source data's newline character, then loop through it with the working code sample you posted.

- FabioPittol
- 29 Oct 11, 4:52 am
- Comment #3

Could you give me an example of this syntax ashooner?

When I said I'm a noob in PHP I meant it! lol

- phoque
- 29 Oct 11, 8:34 pm
- Comment #4

<?php 
$data  = "0001  01/10/2011  CLIENT X    100,00
0001  01/10/2011  CLIENT X    100,00";

$list = explode("\n",$data);

foreach($list AS $data) {
    $array = preg_split("/[\t]+/",$data);
    if(count($data) > 3) { // ignore empty/too short lines
        echo "Document: " . $array[0] . "<br/>";
        echo "Date: " . $array[1] . "<br/>";
        echo "Client: " . $array[2] . "<br/>";
        echo "Value: " . $array[3];
    }
}

- FabioPittol
- 29 Oct 11, 11:01 pm
- Comment #5

Thanks phoque

One weird thing is according to print_r($array); all the indexes are 0, so $array[1] (and so on) returns an error :/

Array ( [0] => 0001 01/10/2011 CLIENT X 100,00 ) Array ( [0] => 0002 05/10/2011 CLIENT Y 150,00 ) Array ( [0] => 0003 10/10/2011 CLIENT Z 120,00 )

- FabioPittol
- 29 Oct 11, 11:14 pm
- Comment #6

It seems that the regex on preg_slip it's not working well after the explode. Maybe I should try to replace the whitespaces with colons, explode by linebreak and then use the regex spliting by colons. I'll give it try..

- FabioPittol
- 29 Oct 11, 11:36 pm
- Comment #7

Made it!

Just for the record, ended up like this

<?php 
//Raw data separeted with tabs and linebreaks
$raw  = "0001   01/10/2011  CLIENT X    100,00
0002    05/10/2011  CLIENT Y    150,00
0003    10/10/2011  CLIENT Z    120,00";

//Replacing tabs for colons
$data = preg_replace("/[t]+/",":",$raw);

//Separating each line to be read by foreach
$list = explode("n",$data);

//Just icing xD
echo "<hr/>";

//Rendering the separeted data from each line
foreach($list AS $data) {
    $array = preg_split("/:/",$data);
        echo "Document: " . $array[0] . "<br/>";
        echo "Date: " . $array[1] . "<br/>";
        echo "Client: " . $array[2] . "<br/>";
        echo "Value: " . $array[3] . "<hr/>";
}
?>

Big thanks to ashooner and phoque

Create an account or sign in to comment.

Symphony.