Skip to content

Instantly share code, notes, and snippets.

View janschoepke's full-sized avatar

Jan Schöpke janschoepke

  • Wölfersheim, Germany
View GitHub Profile
@janschoepke
janschoepke / export_csv.php
Created June 20, 2017 15:55
MySQL CSV Export via PHP (PHP7 ready)
<?php
/* vars for export */
// database record to be exported
$db_record = 'XXX_TABLE_NAME_XXX';
// optional where query
$where = 'WHERE 1 ORDER BY 1';
// filename for export
$csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
// database variables