How to add Tabs and Line Breaks from Array using file_put_contents

Question

I am connecting to a SQLite database. I use the following query to get the results:

$db = new SQLite3('sshTunnel.sqlite');
$results = $db->query('SELECT * FROM TUNNEL');

Now, I want to add tabs and line breaks from the row array using file_put_contents in PHP:

while ($row = $results->fetchArray(SQLITE3_ASSOC))
{
    file_put_contents($file, $row, FILE_APPEND).PHP_EOL;
}

The results are displayed unformatted in one line:

TestTestTest   Test   Test   Test

I wish to have this structure:

Test   Test   Test
Test   Test   Test

Where is the mistake?

Please elaborate on how your data looks like when you pull it. — , Jun 29 '16 at 09:18

score 1 · Answer 1 · answered Jun 29 '16 at 09:25

1

while ($row = mysqli_fetch_row($results))
{
   foreach($row as $value)
   {
     $value .= '|';//use what ever char you what to append
     file_put_contents($file, $value, FILE_APPEND | LOCK_EX);
   }
   file_put_contents($file, '\n', FILE_APPEND | LOCK_EX);
}

answered Jun 29 '16 at 09:25

bluepinto

165
9

Almost. It is still in one line with some errors. Result: Test, Test, Test, \nTest , Test , Test ... – sjantke Jun 29 '16 at 09:31
Update: The line break works with "\n" instead of '\n'. For every row iteration, there are (I do not know why) 4 more tabs added. So with 2 rows, there are 8 tabs. For 3 rows, there are 12 tabs. WTF? :-) – sjantke Jun 29 '16 at 09:41

score 1 · Accepted Answer · answered Jun 29 '16 at 10:05

1

I fixed the problem. trim() made it.

while ($row = $results->fetchArray(SQLITE3_ASSOC))
{
    foreach ($row as $value)
    {
        file_put_contents($file, trim($value) . ", ", FILE_APPEND | LOCK_EX);
    }
    file_put_contents($file, "\n", FILE_APPEND | LOCK_EX);
}

answered Jun 29 '16 at 10:05

sjantke

605
4
9
35

1

probably had extra values in the database, so needed `trim()`, but i like how you put it in one line. god job man! – bluepinto Jun 29 '16 at 12:53
also, i'd run a update query on the record set with trim, else it may/might cause formatting errors when you try and display values. never forget Murphy's Law – bluepinto Jun 29 '16 at 13:01
Thanks, ditto! :-) – sjantke Jun 29 '16 at 13:03

How to add Tabs and Line Breaks from Array using file_put_contents

2 Answers2