mysql_connect('servername','username','password');

mysql_select_db('databasename');

$sql = "LOAD DATA LOCAL

INFILE 'data.csv'

INTO TABLE data

FIELDS

       TERMINATED BY ','

       OPTIONALLY ENCLOSED BY '\"'";

$insert = mysql_query($sql);

if($insert)

  echo 'success';

else

  die('error : ' . mysql_error());

?>

<?PHP
date_default_timezone_set("Asia/Jakarta");

//Array Hari
$array_hari = array(1=>"Senin","Selasa","Rab
u","Kamis","Jumat",
"Sabtu","Minggu");
$hari = $array_hari[date("N")];
//Format Tanggal
$tanggal = date ("j");

//Array Bulan
$array_bulan = array(1=>"Januari","Februari","Maret",
"April", "Mei",
"Juni","Juli","Agustus","September","Oktober",
"November","Desember");
$bulan = $array_bulan[date("n")];

//Format Tahun
$tahun = date("Y");
//Menampilkan hari dan tanggal
echo $hari . "," . $tanggal."-" . $bulan."-" . $tahun;
?>