How to save while result to txt file?

Question

Generates txt, but saves only the last entry of the database and in the precise case of all data.

$querymail = mysql_query("select mat,nome from usuario ");

while($data = mysql_fetch_array($querymail)) {
    $log = str_pad($data[0], 10, "0", STR_PAD_LEFT);
    $log1 = str_pad($data[1], 40, " ", STR_PAD_RIGHT);

    $linhas = "log1$log2.";         
}

Answer 1

The file_put_contents command writes a string to a file, if this file does not yet exist it creates the file

    while($data = mysql_fetch_array($querymail)) {
       $log = str_pad($data[0], 10, "0", STR_PAD_LEFT);
       $log1 = str_pad($data[1], 40, " ", STR_PAD_RIGHT);

        $linhas .= $log. " " .$log1."\n";         
    }

file_put_contents('arquivo.txt', $linhas);

If you just want to add a value in an already created file, you will have to use a third parameter with the value FILE_APPEND, so:

file_put_contents('arquivo.txt', $linhas, FILE_APPEND);