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;
?>
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());
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
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.
<?
$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;
?>