/export_log.php

#!/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');