<?php

$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.');

$filename = '/var/www/dighelaw.com/www/mdcc/csv_exports/mdcc_export.csv';

header('Content-Type: text/csv');
header("Content-Disposition: attachment; filename={$filename}");
header('Pragma: no-cache');

$sql = $_REQUEST['sql'];
$sql .= " INTO OUTFILE '{$filename}'";

$st = $dbh->prepare($sql);
if ( $st->execute() ) {
	readfile($filename);
} else {
	$errors = $st->errorInfo();
	print_r($errors);
}

unlink($filename);

?>