Bdtjtk

<?php

/* vars for export */

// database record to be exported

$db_record = 'baa';

// optional where query

// $where = 'WHERE 1 ORDER BY 1';

// filename for export

$tanggal = date("d-m-Y", strtotime('NOW'));

//$csv_filename = 'backup_data_'.$db_record.'_'.date('Y-m-d').'.csv';

$csv_filename = 'backup_data_'.$db_record.'_'.$tanggal.'.csv';

// database variables

$hostname = "localhost";

$user = "root";

$password = "";

$database = "test";

$port = 3306;

$conn = mysqli_connect($hostname, $user, $password, $database, $port);

if (mysqli_connect_errno()) {

    die("Failed to connect to MySQL: " . mysqli_connect_error());

}

// create empty variable to be filled with export data

$csv_export = '';

// query to get data from database

$query = mysqli_query($conn, "SELECT FILE_NAME, SERVER_ID, SENT, RECEIVED, PACKET_LOST, AVG_RTT, MIN_RTT, MAX_RTT, INSERT_DATE, TRANS_DATE FROM baa WHERE (INSERT_DATE BETWEEN '2018-12-01 00:00:01' AND '2018-12-01 00:30:00') AND FILE_NAME='sabu.txt'");

$field = mysqli_field_count($conn);

// create line with field names

for($i = 0; $i < $field; $i++) {

    $csv_export.= mysqli_fetch_field_direct($query, $i)->name.';';

}

// newline (seems to work both on Linux & Windows servers)

$csv_export.= '

';

// loop through database query and fill export variable

while($row = mysqli_fetch_array($query)) {

    // create line with field values

    for($i = 0; $i < $field; $i++) {

        $csv_export.= '"'.$row[mysqli_fetch_field_direct($query, $i)->name].'";';

    }

    $csv_export.= '

';

}

// Export the data and prompt a csv file for download

header("Content-type: text/csv");

header("Content-Disposition: attachment; filename=".$csv_filename."");

echo($csv_export);



/*function outputCsv($fileName, $assocDataArray)

{

    ob_clean();

    header('Pragma: public');

    header('Expires: 0');

    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');

    header('Cache-Control: private', false);

    header('Content-Type: text/csv');

    header('Content-Disposition: attachment;filename=' . $csv_filename);    

    if(isset($assocDataArray['0'])){

        $fp = fopen('/xampp/htdocs/backup', 'w');

        fputcsv($fp, array_keys($assocDataArray['0']));

        foreach($assocDataArray AS $values){

            fputcsv($fp, $values);

        }

        fclose($fp);

    }

    ob_flush();

}

*/

$query = mysqli_query($conn, "SELECT FILE_NAME, SERVER_ID, SENT, RECEIVED, PACKET_LOST, AVG_RTT, MIN_RTT, MAX_RTT, INSERT_DATE, TRANS_DATE FROM baa WHERE (INSERT_DATE BETWEEN '2018-12-01 00:00:01' AND '2018-12-01 00:30:00') AND FILE_NAME='sabu.txt'");