From txt to php (highest, lowest and average numbers)

[denisrobot]

Hello!
I have a text.txt file that looks something like:
A: 324
B: 63
C: 632
D: 24
E: 76
etc

I need to get the data from the txt file into the php so that it goes in order from highest to the lowest number, like:
C: 632
A: 324
E: 76
etc.
And I also need to write the highest, lowest and average numbers separately.
Could someone please write me a code for this?

Thanks in advance! 🙂

[paulnaj]

Hi Dennis,

Have you tried yourself? What went wrong?

P.

[denisrobot]

Yeah, I'm not exactly sure how to do it since I began to study PHP this semester. I tried explode, arrays etc. But I don't know how to separate the numbers from the letters and make each one of them a separate element. Then I suppose I could use "echo min(array)" or something. Also I slept for 2 hours last night and been working with PHP all day today, so my brain just refuses to think. And this assignment is due tomorrow :/

[paulnaj]

Ok,

$lines = file('text.txt'); to open text file and return an array of rows (lines)
$number = (int)trim(array_pop(explode(':', $line))); will get you the number, which you can append to an array.
sort($numbers) to sort the array afterwards.

Have a go, and come back if things don't work out.

P

[denisrobot]

Thanks!
But if you could please append the $number variable to array as well? I'm sure I will be able to go frm there. I just can't add it! Never really tried it with variables. And arrays is my weak place in php right now.

[paulnaj]

//Having created ...
$numbers = array();

// Use [] to append to the end of an array ...
$numbers[] = $number;

P.

[denisrobot]

Ahh, whenever I get something to work, something else stops to work. Nothing works now...
I'm not sure what I should put into [] now! I'm confused haha.

[paulnaj]

Hi Denis,

Paste up the code you are trying so we can see!

P

[denisrobot]

It's pretty much what you gave me. I changed it back since couple of things I tried didn't work.

$lines = file('text.txt');
$number = (int)trim(array_pop(explode(':', $line)));
$numbers = array(); 
$numbers[] = $number; // confused about this one.

I will be back in a few hours, need to get some rest to get my brain to work again 🙂

[paulnaj]

You need to loop through the lines, and for each line, extract the number and append it to the numbers array.

Look up foreach() in the manual (along with all the other functions mentioned so you know what they mean).

[denisrobot]

I wrote it in a bit different way. Now the problem is with how I add stuff into the arrays apparently.

Here's the code:

$lines = file("text2.txt");
$array = array();
foreach($lines as $line)
{
	if(preg_match_all('/([\d]+)/',$line,$match))
	{
    foreach($match as $number)
    $array[] = $number;
	}
}
echo '<pre>'; print_r($array);echo "</pre>";

Here's the result:

Array
(
    [0] => Array
        (
            [0] => 100
        )

[1] => Array
    (
        [0] => 100
    )

[2] => Array
    (
        [0] => 35
    )

[3] => Array
    (
        [0] => 35
    )

[4] => Array
    (
        [0] => 234
    )

[5] => Array
    (
        [0] => 234
    )

[6] => Array
    (
        [0] => 73
    )

[7] => Array
    (
        [0] => 73
    )

[8] => Array
    (
        [0] => 12
    )

[9] => Array
    (
        [0] => 12
    )

[10] => Array
    (
        [0] => 37
    )

[11] => Array
    (
        [0] => 37
    )

)

It repeats twice and is inside another array!

[dagon]

$match is a multi d array but you dont need to loop it, and you are going to lose your letters with that preg_match

[denisrobot]

dagon;10966096 wrote:

$match is a multi d array but you dont need to loop it, and you are going to lose your letters with that preg_match

I need to lose the letters because I need to find min and max numbers in my array, so that's why I'm using preg_match.
I just need my $match array look something like:

          

            [0] => 100

        [1] => 35

        [2] => 234

        [3] => 73

        [4] => 12

        [5] => 37

Could some please fix my code for that? I have to be done with this thing very soon :queasy:

[dagon]

<?php
$lines = array('A: 324','B: 63','C: 632','D: 24','E: 76');
$data = array();
foreach($lines as $line){
    $bang = explode(': ',$line);

{

    $data[] = $bang[1];
}
}

rsort($data);

echo '<pre>';
print_r($data);
echo "</pre>";

$highest = $data[0];
echo $highest."\n";
$lowest = end($data);
echo $lowest."\n";

$average = array_sum($data)/count($data);
echo $average."\n";
?>

[denisrobot]

dagon;10966098 wrote:

<?php
$lines = array('A: 324','B: 63','C: 632','D: 24','E: 76');
$data = array();
foreach($lines as $line){
    $bang = explode(': ',$line);

{

    $data[] = $bang[1];
}
}

rsort($data);

echo '<pre>';
print_r($data);
echo "</pre>";

$highest = $data[0];
echo $highest."\n";
$lowest = end($data);
echo $lowest."\n";

$average = array_sum($data)/count($data);
echo $average."\n";
?>

Cheers! That helped a lot.
It's a lot easier than I thought 🙂