save var_dump into text file

Question

I have the php code for sql query

<?
$server = "127.0.0.1";
$username = "root";
$password = "1";

$link= connecttodb($server,$username,$password);

function connecttodb($server,$username,$password)
{

    $rez=fopen("test.txt","ab");
    if ($link=mysql_connect ("$server","$username","$password",TRUE))
    {
        fwrite($rez,"".$server." \r\n");
     echo "Connected successfully to >> " .$server ;
  
  $result = mysql_query('SHOW DATABASES');
        echo "<br>";
        while ($row = mysql_fetch_array($result))
        {
            var_dump ($row); }
     }
    }
    ini_set('max_execution_time', 10);
    return $link;
?>

this code print my database name on the browser how I can save the database name into text file

Connected successfully to >> 127.0.0.1
array(2) { [0]=> string(18) "information_schema" ["Database"]=> string(18) "information_schema" } array(2) { [0]=> string(2) "db" ["Database"]=> string(2) "db" } array(2) { [0]=> string(5) "mysql" ["Database"]=> string(5) "mysql" } array(2) { [0]=> string(10) "phpmyadmin" ["Database"]=> string(10) "phpmyadmin" } array(2) { [0]=> string(4) "test" ["Database"]=> string(4) "test" }

If you initiate a connection to the db then you MUST know the name of the db — Professor Abronsius, Aug 12 '16 at 23:36
Please dont use [the `mysql_` database extension](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php), it is deprecated (gone for ever in PHP7) Specially if you are just learning PHP, spend your energies learning the `PDO` database extensions. [Start here](http://php.net/manual/en/book.pdo.php) its really pretty easy — RiggsFolly, Aug 12 '16 at 23:40
@RamRaider if you look at OP's code, he is initializing a connection to the server without specifying the schema. He is attempting to list all databases on the server that he as access to. — , Aug 12 '16 at 23:42
As @RiggsFolly said learn PDO, however the manual might seem a bit overwhelming so you could [this](http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers), it is extremely good and will have up and running in no time. — Script47, Aug 13 '16 at 00:31

score 61 · Accepted Answer · answered Aug 12 '16 at 23:25

61

You can use the output buffering functions to capture output and write it to a file.

ob_flush();
ob_start();
while ($row = mysql_fetch_assoc($result)) {
    var_dump($row);
}
file_put_contents("dump.txt", ob_get_flush());

answered Aug 12 '16 at 23:25

Barmar

741,623
53
500
612

1

`var_dump` is meant for debugging by humans, it's not meant to be parsed by programs. – Barmar Aug 13 '16 at 00:30
please look here http://stackoverflow.com/questions/38928140/save-var-dump-into-text-file-for-multi-server-ip-from-text-file – Yasser Abo Reida Aug 13 '16 at 00:47
1

`serialize($myobj)` as suggested by @Matth3w is a better solution – shogitai Apr 04 '18 at 16:10
5

The code in the question uses `var_dump()`. The question was about how to get the output into a file, not the format of the file. – Barmar Apr 04 '18 at 18:09
2

`$str = print_r($row, true);` when true it returns a string, same with var_dump – jscripter Mar 25 '19 at 02:47
@jscripter That only works for `print_r`, not `var_dump`. – Barmar Mar 25 '19 at 06:55
@jscripter ty so much better – oldboy Aug 02 '19 at 22:35
1

Better solution `file_put_contents('var_dump.txt',var_export($array, true));` – Arthur Veselov Mar 23 '22 at 18:43

score 24 · Answer 2 · answered Aug 12 '16 at 23:25

24

Don't use var_dump for this, use serialize like so:

<?php
$fp = fopen('vardump.txt', 'w');
fwrite($fp, serialize($myobj));
fclose($fp);
?>

To restore it, you can use unserialize($filecontents); by reading it back in from the file.

answered Aug 12 '16 at 23:25

2

Simple, excellent idea. There is also `print_r()` to create a string from any variable which may be easier to read than serialized data. – Alexis Wilke Jul 07 '17 at 00:08

score 0 · Answer 3 · answered Aug 12 '16 at 23:29

<?
$server = "127.0.0.1";
$username = "root";
$password = "1";

$link= connecttodb($server,$username,$password);

function connecttodb($server,$username,$password)
{

$rez=fopen("test.txt","ab");
   if ($link=mysql_connect ("$server","$username","$password",TRUE))
   {
   fwrite($rez,"".$server." \r\n");
    echo "Connected successfully to >> " .$server ;

        $result = mysql_query('SHOW DATABASES');
echo "<br>";
while ($row = mysql_fetch_array($result))
{
fwrite($rez, $row['DatabaseName']); }

    }

}
ini_set('max_execution_time', 10);
return $link;
    ?>

score -3 · Answer 4 · answered Aug 12 '16 at 23:19

-3

This should work

$file = 'somefile.txt';
file_put_contents($file, $some_var);

You may want to serialize the variable first to make it more readable.

But there are several other methods: http://php.net/manual/en/function.file-put-contents.php

answered Aug 12 '16 at 23:19

Andy

102
1
4

save var_dump into text file

4 Answers4

Linked