save var_dump into text file [closed]

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" }

Answer 1

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());