[Resolved] How to assign labels to array columns

skeetley

Hi, I am very new to PHP and am trying to write my first script. This is what I have so far:

<?php    include 'http://weatheroffice.ec.gc.ca/data/conditions/currcond.met';
    $filename = 'http://weatheroffice.ec.gc.ca/data/conditions/currcond.met';    

    $array_of_lines   = file($filename);
    $string_from_file = file_get_contents($filename);
    for($i=0;$i<count($array_of_lines);$i++) {
    echo $array_of_lines[$i];
    echo "<br>";
}
?>

What this code does, and it was tricky to figure out for me, is go read the data file from a different site and re-print everything. Now what I want to do is assign labels to each column in the array so that I can query the array by the city column, elimate columns such as the Hdx column and change the out put of a column based on the number such as the Wx column. So how do I assign labels to these columns in my array?

Thanks!
Shayne

bad76

Hi,
you can't assign label to column... you can try to split column
with explode() or with preg_match_all() commands.
The second one is powerfull, but if the first is enough, i hint
you to use it, is easiest to use.

see you

skeetley

Ok so right now I have

<?php include 'http://weatheroffice.ec.gc.ca/data/conditions/currcond.met';
    $filename = 'http://weatheroffice.ec.gc.ca/data/conditions/currcond.met';
    $array_of_lines   = file($filename);
    $string_from_file = file_get_contents($filename);
?>

which for some reason unknown to me, prints the whole array like this:
#City Date/Time Temp Dew Vsby Wx Rh Chill Hdx Dir Spd Gust Cld Pres Day WC(index) WAE 2003/09/30 16:00 8.4 7.1 24.1 0 92.0 -99.0 -99.0 0 0 -99 0 1021.7 1 18 WAG 2003/09/30 16:00 19.5 -99.0 -99.0 0 -99.0 -99.0 -99.0 190 31 55 -99 -99.0 1 19 WAH 2003/09/30 16:00 17.5 12.4 -99.0 0 72.0 -99.0 -99.0 230 22 31 -99 1018.2 1 17 WAJ 2003/09/30 15:00 13.3 6.4 9.6 0 63.0 -99.0 -99.0 260 42 57 -99 1020.4 1 10 WAV 2003/09/30 16:00 6.1 1.1 -99.0 0 70.0 -99.0 -99.0 0 0 -99 -99 1026.3 1 17 WBA 2003/09/30 15:00 6.6 5.4 -99.0 0 92.0 -99.0 -99.0 170 18 -99 -99 -99.0 1 3 WBD 2003/09/30 16:00 4.6 -3.5 -99.0 0 56.0 -99.0 -99.0 350 1 -99 -99 -99.0 1 6 WBE 2003/09/30 15:00 7.5 2.8 14.4 0 72.0 -99.0 -99.0 300 29 42 -99 1014.6 1 3 WBF 2003/09/30 etc.......

so to be able to manipulate each field in each line of the array you recommend I use the explode comand. So somehere in this code I should have something like

 
$explode = explode(".", $string_from_file);

Is this correct? Please forgive my ignorance and thanks for your help.

Shayne

skeetley

OK, I admit it, I am retarded. I have no idea what I am doing here at all. Maybe someone can give me some much needed direction here, a lot of much needed directions actually.

I want my script to go to this file: http://weatheroffice.ec.gc.ca/data/conditions/currcond.met I want to ignore the top label line. I want it then to put each line in an array so that I can query it by the row (city) and display certain elements of the data. I think I can code in the stuff to do with manipulating the data, but for the life of me I cannot get the data into the array as I need it. The explode command looks useful, but I don't think I am there yet...

skeetley

OK, here we go. I was wrong trying to use the include function here. This code below seems way better to me:

<?php
$FileArray = file ("http://weatheroffice.ec.gc.ca/data/conditions/currcond.met");
for ($i = 0 ; $i < count($FileArray); $i++)
echo "line #".$i." ".$FileArray[$i]."<p>";
?>

Now I just have to figure out that explode command. Any helpful tips?

bad76

Originally posted by skeetley
Ok so right now I have [...]
#City Date/Time Temp Dew Vsby Wx Rh Chill Hdx Dir Spd Gust Cld Pres Day WC(index) WAE 2003/09/30 16:00 8.4 7.1 24.1 0 92.0 -99.0 -99.0 0 0 -99 0 1021.7 1 18 WAG 2003/09/30 16:00 19.5 -99.0 -99.0 0 -99.0 -99.0 -99.0 190 31 55 -99 -99.0 1 19 WAH 2003/09/30 16:00 17.5 12.4 -99.0 0 72.0 -99.0 -99.0 230 22 31 -99 1018.2 1 17 WAJ 2003/09/30 15:00 13.3 6.4 9.6 0 63.0 -99.0 -99.0 260 42 57 -99 1020.4 1 10 WAV 2003/09/30 16:00 6.1 1.1 -99.0 0 70.0 -99.0 -99.0 0 0 -99 -99 1026.3 1 17 WBA 2003/09/30 15:00 6.6 5.4 -99.0 0 92.0 -99.0 -99.0 170 18 -99 -99 -99.0 1 3 WBD 2003/09/30 16:00 4.6 -3.5 -99.0 0 56.0 -99.0 -99.0 350 1 -99 -99 -99.0 1 6 WBE 2003/09/30 15:00 7.5 2.8 14.4 0 72.0 -99.0 -99.0 300 29 42 -99 1014.6 1 3 WBF 2003/09/30 etc.......
 
$explode = explode(".", $string_from_file);
[...] [/B]

I think you can try with $explode = explode(" ", $string_from_file); because i look always any blank between two field.

And echo a "<br>" after each output.

(But when you get that output, try to look at html code (rigth-click on page, HTML...), you have to look if there are tags.)

All this sound like that:

<?php
$FileArray = file ("http://weatheroffice.ec.gc.ca/data/conditions/currcond.met");
for ($i = 0 ; $i < count($FileArray); $i++)
{
  $explode = explode(" ", $FileArray[$i]); 
  echo "<br>line #".$i;
  for ($j = 0 ; $j < count($explode); $j++)
    echo $j.") ".$explode[$j];
}
?>

skeetley

Thank you, thank you, thank you, thank you, thank you!!!!!