<?php
// Koneksi MySQLi Procedural
$db['host'] = "localhost"; //host
$db['user'] = "root"; //username database
$db['pass'] = ""; //password database
$db['name'] = "login"; //nama database

$koneksi = mysqli_connect($db['host'], $db['user'], $db['pass'], $db['name']);
if (mysqli_connect_errno()) {
 trigger_error('Koneksi ke database gagal: '  . mysqli_connect_error(), E_USER_ERROR); // Jika koneksi gagal, tampilkan pesan "Koneksi ke database gagal"
}

    $date = date('Y-m-d');
    $kontrak = "kontrak";
    $query1="SELECT * FROM pelanggan WHERE tanggal_aktif=DATE(NOW())
GROUP BY tanggal_aktif;";
    $daftar=mysqli_query($koneksi, $query1) or die (mysqli_error());

    $laporan="<h4><b>Data Pelanggan</b></h4>";
    $laporan .="<br/>";
    $laporan .="<table width=\"100%\" border=\"1\" align=\"center\" cellpadding=\"3\" cellspacing=\"0\">";
    $laporan .="<tr style=\"bgcolor: blue;\">";
    $laporan .="<td>Customer Name</td><td>MRC ID</td><td>MRC USD</td>";
    $laporan .="</tr>";
    while($dataku=mysqli_fetch_object($daftar))
    {
        $laporan .="<tr>";
        $laporan .="<td>$dataku->nama_pelanggan</td><td>$dataku->mrc_idr</td><td>$dataku->mrc_usd</td>";
        $laporan .="</tr>";
    }
    $laporan .="</table>";
    $laporan .="<h5><a href='http://wwwhakkoblogs.com'> Copyright &copy 2016</a></h5>";

    require_once("phpmailer/class.phpmailer.php");
    require_once("phpmailer/class.smtp.php");

    $sendmail = new PHPMailer();
    $sendmail->setFrom('syazel.friends@gmail.com','List Data Karyawan'); //email pengirim
    $sendmail->addReplyTo('arizkyhapp@niqoweb.com','List Data Karyawan'); //email replay
    $sendmail->addAddress('arizkyhapp@gmail.com','Hakko Bio Richard'); //email tujuan
    $sendmail->addBCC('arizkyhapp@gmail.com'); //email tujuan yang di BCC
    $sendmail->Subject = 'Customer Hari ini'; //subjek email
    $sendmail->Body=$laporan; //isi pesan dalam format laporan
    $sendmail->isHTML(true);
    if(!$sendmail->Send())
    {
        echo "Email gagal dikirim : " . $sendmail->ErrorInfo;
    }
    else
    {
        echo "Email berhasil terkirim!";
    }
?>