/export_log.php
PHP | 34 lines | 21 code | 3 blank | 10 comment | 3 complexity | ff6eb3134f76978e9d7afd46d0a796c3 MD5 | raw file
Possible License(s): BSD-3-Clause
- #!/usr/bin/php -f
- <?php
- /**
- * Log table data export into CSV file
- *
- * @author Rad Cirskis (nad2000@gmail.com)
- */
- require_once 'DataSource.php';
- /**
- * Log table data export into CSV file
- * @param string $fileName
- */
- function exportLog( $fileName ) {
- $result = DataSource::getLogStmt();
- $row = $result->fetch(PDO::FETCH_ASSOC) ;
- if ( $row )
- {
- $logId = $row['LogId'];
- $csv = fopen( $fileName, 'w');
- fputcsv ( $csv , array_keys( $row ) );
- while ( $row )
- {
- fputcsv ( $csv , $row);
- if (isset($row[0])) $logId = $row[0];
- $row = $result->fetch(PDO::FETCH_NUM);
- }
- fclose($csv);
- DataSource::storeLastLogId($logId);
- }
- }
- exportLog('log.csv');