php retrieve data from text file

Question

Imagine I have a certain text file like this:

 Welcome to the text file!
 -------------------------
 Description1: value1
 Description2: value2
 Description containing spaces: value containing spaces
 Description3: value3

Storing this data into a text file would be easy, like this:

 $file = 'data/preciousdata.txt';
 // The new data to add to the file
 $put = $somedescription .": ". $somevalue;
 // Write the contents to the file, 
 file_put_contents($file, $put, FILE_APPEND | LOCK_EX);

With a different description and value every time I write to it.

Now I would like to read the data, so you would get the file:

 $myFile = "data/preciousdata.txt";
 $lines = file($myFile);//file in to an array

Lets say I just wrote "color: blue" and "taste: spicy" to my text file. I don't know on which lines they are, and I want to retrieve the value of the "color:" description.

Edit Should I let php "search" though the file, return the number of the line that contains the "description", then put the line in a string and remove everything for the ":"?

Something like ready line by line and then remove all the chars before the ":"? — Aurelio De Rosa
– Aurelio De Rosa, Commented Jun 30, 2013 at 15:31
use JSON. json_encode and json_decode instead of writing your own parser. Other options are serialize and XML — Pinoniq
– Pinoniq, Commented Jun 30, 2013 at 15:33

Ivanka Todorova · Accepted Answer · 2013-06-30 15:40:55Z

9

With explode you can make an array containg the "description" as a key and the "value" as value.

$myFile = "data.txt";
$lines = file($myFile);//file in to an array
var_dump($lines);

unset($lines[0]);
unset($lines[1]); // we do not need these lines.

foreach($lines as $line) 
{
    $var = explode(':', $line, 2);
    $arr[$var[0]] = $var[1];
}

print_r($arr);

edited Jun 30, 2013 at 15:40

answered Jun 30, 2013 at 15:34

Ivanka Todorova

10.3k17 gold badges71 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Aurelio De Rosa Over a year ago

You can also trim like this: $arr[$var[0]] = trim($var[1]);

Ivanka Todorova Over a year ago

@AurelioDeRosa this is a good advice. Now he can do whatever he wants. $var[0] is the "Description1", "Descrption2" (etc...) and $var[1] holds the value. :)

Sumurai8 Over a year ago

Use the limit argument of explode ($var = explode(':', $line, 2);)

Marcin Krawiec · Accepted Answer · 2013-06-30 15:39:41Z

I don't know how you want to use those values later on. You can load data into an associative array, where the descriptions are keys:

// iterate through array
foreach($lines as $row) {
    // check if the format of this row is correct
    if(preg_match('/^([^:]*): (.*)$/', $row, $matches)) {
        // get matched data - key and value
        $data[$matches[1]] = $matches[2];
    }
}
var_dump($data);

Please note that this code allows you to fetch values with colons.

If you are not sure if the descriptions are unique you can store values as an array:

// iterate through array
foreach($lines as $row) {
    // check if the format of this row is correct
    if(preg_match('/^([^:]*): (.*)$/', $row, $matches)) {
        // get matched data - key and value
        $data[$matches[1]][] = $matches[2];
    }
}
var_dump($data);

This prevents from overwriting data parsed earlier.

agustinsantiago · Accepted Answer · 2013-06-30 15:36:48Z

0

Since $lines is an array, you should loop it looking for the ":" and separating the line in two: description and value.

Then:

<?php
$variables = array();
unset($lines[0]); //Description line
unset($lines[1]); //-------

foreach ($lines as $line) {
    $tempArray = explode( ": ", $line ); //Note the space after the ":", because
                                           values are stored with this format.
    $variables[$tempArray[0]] = $tempArray[1];
}
?>

There you have in variables an array, whose keys are the descriptions and values are your values.

answered Jun 30, 2013 at 15:36

agustinsantiago

1041 silver badge8 bronze badges

Comments

andre.barata · Accepted Answer · 2013-06-30 15:48:28Z

0

You could use a regular expression to split the line and retrieve the parte after ":" or just yse the explodecommand which returns an array of the string split by every ":" such as:

foreach ($lines as $line_num => $line) {
    $split_line = explode(":", $line);
    // echo the sencond part of thr string after the first ":"
    echo($split_line[1])
    // also remove spaces arounfd your string
    echo(trim($split_line[1]));
}

edited Jun 30, 2013 at 15:48

answered Jun 30, 2013 at 15:39

andre.barata

6633 silver badges11 bronze badges

Collectives™ on Stack Overflow

php retrieve data from text file

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related