How do I save the output of this code into a file? (PHP) [closed]

by

You can use the fopen and fwrite PHP functions to do that.

It would be something like this:

<?php

// Here we create a file handler
$myfile = fopen("newfile.txt", "w") or die("Unable to open file!");

foreach($tables as $table)
{
    echo "<h2>" . $table[0] . "</h2>";
    // Here, we write the value of $table[0] and a new line in the file
    fwrite($myfile, "Table " . $table[0] . "\n");

    $query = "DESCRIBE " . $table[0];
    $result = $mysqli->query($query);

    $columns = $result->fetch_all();

    foreach($columns as $column)
    {
        echo $column[0]. '<br />';
        fwrite($myfile, " - " . $column[0] . "\n");
    }
}
fclose($myfile);

?>

Note: I strongly recommend you to use prepared statements for the SQL queries.

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. PHP PDO and Mysql [closed]
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Save PHP array to MySQL?
  5. implement LIKE query in PDO
  6. PHP PDO prepared statement — MySQL LIKE query
  7. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  8. How can I use mysqli_fetch_array() twice?
  9. Best practice multi language website
  10. Executing multiple SQL queries in one statement with PHP
  11. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  12. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  13. Easy way to export a SQL table without access to the server or phpMyADMIN
  14. using nulls in a mysqli prepared statement
  15. How can I count the numbers of rows that a MySQL query returned?
  16. How to join two tables with ssp.class.php
  17. How to run the PHP script at scheduled time
  18. How to handle error for duplicate entries?
  19. How to handle PDO exceptions [duplicate]
  20. MySql PHP select count of distinct values from comma separated data (tags)
  21. mysql_insert_id() returns 0
  22. Copy file from remote server or URL [duplicate]
  23. How do I get database column names in Laravel?
  24. PDO and MySQL Fulltext searches
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. mysql_connect VS mysql_pconnect [closed]
  27. Difference between mysql_fetch_array and mysql_fetch_row?
  28. mysql_fetch_array skipping first row
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment