How can PHP be used to automatically save a text file with SQL data using a timestamp in the file name?

To automatically save a text file with SQL data using a timestamp in the file name, you can use PHP to fetch the SQL data, create a text file with the data, and include a timestamp in the file name. This can be achieved by using functions like file_put_contents() to create the text file and date() to generate the timestamp. 

<?php
// Fetch SQL data
$sqlData = "SELECT * FROM your_table";
// Execute SQL query and fetch data into $result

// Generate timestamp
$timestamp = date('Y-m-d_H-i-s');

// Create text file with SQL data
$fileContent = '';
foreach ($result as $row) {
    $fileContent .= implode(',', $row) . "\n";
}
$fileName = 'data_' . $timestamp . '.txt';
file_put_contents($fileName, $fileContent);

echo "Text file saved with SQL data using timestamp in the file name!";
?>

Keywords

PHP text file SQL data timestamp automatic saving

Related Questions