Save var_dump to text file

Question

I have 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 will print my database name in a browser how can I save the database name in a 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" } 

Answer 1

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

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

Answer 2

Do not use var_dump for this, use serialization as follows:

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

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

Answer 3

 <? $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; ?> 

Answer 4

This should work

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

You can 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