如何读取文本并获取字符串以转换JSON文件php

Question

I want to get some string in text file and divide then converting to JSON file this is my text file, data.txt

"5 minute input rate 134000 bits/sec, 164 packets/sec

5 minute output rate 1320000 bits/sec, 150 packets/sec"

I want get a string to array and make a JSON file maybe like this:

$time= "5 minute "
$input= "input rate 134000 bits/sec"
$output= "output rate 1320000 bits/sec"
$array[koneksi]= json_decode('[.".$time.":".$input.]');

this is my code in PHP

<?php
$lines = file('var/www/datakom/data.txt');
$title = 'data';
    foreach ($lines as $line_num => $line) {
        echo htmlspecialchars($line) . "<br />
"; }
?>

Please help me. thanks a lot

Answer 1

try using a regex sth like this :

<?php

//helpfull function
function preg_grep_keys( $pattern, $input, $flags = 0 )
{
    $keys = preg_grep( $pattern, array_keys( $input ), $flags );
    $vals = array();
    foreach ( $keys as $key )
    {
        $vals[$key] = $input[$key];
    }
    return $vals;
}

function parseFile(){
      $pattern='/(?<time>\d+)\s+(?<time_unit>\w+)\s+(?<direction>\w+)\s+(.*?)(?<rate>\d+)\s+(?<rate_unit>\w+)(.*?)(?<packets>\d+)/i';
       $lines = file('var/www/datakom/data.txt');
       $title = 'data';
       $json_data=array();
       foreach ($lines as $line_num => $line) {
         preg_match($pattern,$line,$result);
         $json_data[]=preg_grep_keys('/time|time_unit|direction|rate|rate_unit|packets/',$result);
       }

    return json_encode($json_data);
}

?>

you need to invoke parseFile() function to parse the file , which will return a json "string". I am not sure you need json string or array . You can change the return statement to return json string or two-dimentional array e.g

 return json_encode($json_data);

 or 

 return  $json_data;

Note: I have not tested it , please give it a try and let me know