Read a txt file by php and mysql and viewed by each user

Question

Read a txt file by php and mysql and viewed by each user

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (0 votes)

4

I'm a beginner PHP programmer, I accepted a challenge from a job and I'm in need of help right now. They send me a monthly expense report for each user in a single file (a list), in the txt format. I need to convert the rows separately from each user, so he can visualize his total expenses in a total. I would like some PHP command, linked with a MySQL database, so that it can view your spending.

Note: The file received in txt is a list of all users. Below a part of the file received so they can understand.

000001 | 06 | 2015 | 001 | MONTHLY JUNE 2015 | 000000003000 | D 000001 | 06 | 2015 | 002 | CLUB CRUZEIRO DO SUL | 000000004500 | D 000005 | 06 | 2015 | 001 | CREDIT RETURN TO PARTNER | 000000007500 | C

Separated by the pipe are first the user id, month and then the year, the order, the entity and (by removing zeros) the amount spent on each entity.

php

asked by anonymous 27.10.2015 / 18:12

3 answers

1

I made a simple script to get the data of the text file in the format that you sent, follows:

<?php 

$handle = fopen("dados.txt", "r");
if ($handle) {
    $total = 0;
    while (($line = fgets($handle)) !== false) {

        $data = explode("|",$line);

        echo "ID: ".$data[0]."</br>";
        echo "Mês: ".$data[1]."</br>";
        echo "Ano: ".$data[2]."</br>";
        echo "Ordem: ".$data[3]."</br>";
        echo "Entidade: ".$data[4]."</br>";
        echo "Valor: R$".number_format($data[5],2)."</br>";
        echo "Cod: ".$data[6]."</br>";
        $total+=$data[5];       
    }

    echo '</br>Total: R$' . number_format($total, 2);

    fclose($handle);
} else {
} 

?>

Just so you have an idea, but you can save it to the database as well.

27.10.2015 / 19:01

0

You can write each column in the database to make a explode() through the pipe, if not many rows you can use file() to open the file as an array.

<?php

$linhas = file('gastos');//abre o arquivo como um array 
$sql = "INSERT INTO tabela (c1, c2, c3, c4, c5, c6, c7) values ";

//define o padrão do insert
$pls = '('. str_repeat('?,', 7) .'),';
$sql .= trim(str_repeat($pls, count($linhas)), ',');

//monta o array com os valores a serem inseridos
$valores = array();
foreach($linhas as $item){
    $valores = array_merge($valores, explode('|', $item));
}



$db = new PDO('mysql:host=localhost;dbname=test', 'usuario', 'senha');
$stmt = $db->prepare($sql);
if(!$stmt->execute($valores)){
    echo '<pre>';
    print_r($stmt->errorInfo());
}

27.10.2015 / 19:15

Maven with Proguard Get search result in google with JQuery

score 0 · Accepted Answer

Here's a way to do this:

function readMyFile($file) {
    $data = file_get_contents($file);
    $collection = explode("\n",$data);
    $collection = array_filter($collection);

    $keys = array(
                 'id_usuario',
                 'mes',
                 'ano',
                 'ordem',
                 'entidade',
                 'valor_gasto',
                 'categoria'
                 );
    $return = array();
    if (count($collection)) {
       foreach ($collection as $linha => $collection_pipes) {

       $resultLine = explode('|',$collection_pipes);

      $resultMap[$linha] = array_map(function($a, $b) {
                                        if ($a == 'valor_gasto') {
                                             //remove os zeros
                                            $b = (int) $b; 
                                        }
                                     return array($a => trim($b));
                                    },$keys, $resultLine);
          /* se for remover o índice 0,
             coloque o trecho do código abaixo aqui */
      }
   }

return $resultMap;
}

$saida = readMyFile('seuarquivo.txt');

//sua saída
   echo '<pre>';
    print_r($saida);

Whereas your file breaks lines, the output will be:

To remove the duplicate numeric index, just put this snippet of code inside foreach :

   $resultMap[$linha] =  array('id_usuario'=>$resultMap[$linha][0]['id_usuario'],
                                'mes'=>$resultMap[$linha][1]['mes'],
                                'ano'=>$resultMap[$linha][2]['ano'],
                                'ordem'=>$resultMap[$linha][3]['ordem'],
                                'entidade'=>$resultMap[$linha][4]['entidade'],
                                'valor_gasto'=>$resultMap[$linha][5]['valor_gasto'],
                                'categoria'=>$resultMap[$linha][6]['categoria']);

Or if you prefer, put this after the foreach:

$resultMap =  array_map(function($arr) {
                 return array_merge($arr[0],$arr[1],$arr[2],$arr[3],$arr[4],$arr[5],$arr[6]);
}, $resultMap);
return $resultMap;

The other way to do this is:

function readMyFile($file) {

$content = fopen($file, "r");
if ($content) {
    $total = 0;
   $collection = array();
    while (($line = fgets($content)) !== false) {

        $data = explode("|",$line);
        $collection[$total] = array(
                 'id_usuario' => $data[0],
                 'mes'        => $data[1],
                 'ano'        => $data[2],
                 'ordem'      => $data[3],
                 'entidade'   => $data[4],
                 'valor_gasto'=>(int) $data[5],
                 'categoria'  => $data[6]
                 );

        $total++;       
    }
     return $collection;
    fclose($content);
} 
$collection = readMyFile('seuarquivo.txt');
 echo '<pre>';
  print_r($collection);