小编典典

将var_dump保存到文本文件中

sql

我有用于SQL查询的PHP代码

<?

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

?>

此代码在浏览器上打印我的数据库名称,如何将数据库名称保存到文本文件中

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

阅读 337

收藏
2021-04-15

共1个答案

小编典典

您可以使用输出缓冲功能来捕获输出并将其写入文件。

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