如何将文本输出到文件？

Question

Here's my current code:

$link = mysqli_connect("localhost", "username", "password", "database");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s
", mysqli_connect_error());
    exit();
}

$query = "SELECT id, title FROM titles WHERE type = 'movie' ORDER BY id ASC";

if ($result = mysqli_query($link, $query)) {

    while ($row = mysqli_fetch_assoc($result)) {
        printf ("%s-%s
", $row["id"], $row["title"]);
    }

    mysqli_free_result($result);
}

mysqli_close($link);

Using printf is correctly printing all the rows from my MySQL table.

However, instead of printing it, I want to write it to a text file. Is this possible to do with printf or should I be doing something else?

Answer 1

if you want to write it to the disk, on the server, you should look into fopen(), fwrite() and fclose()

also you could use file_put_contents, but that would require you to prepare all the content before writing it to the file (which could lead to high memory usage if you have lots of records) or if you go with the "append" mode, writing 1 line at a time, you'll have all the overhead of opening and closing the file each time

if you want to make the browser download it, instead of just showing the content, then you need to add a header to the response

header('Content-Disposition: attachment; filename="'.$filename.'"');

preferably adding some content type before it. for example, in your case:

header('Content-type: text/plain');