<?php

require_once("PHPMailerAutoload.php"); // path to the PHPMailerAutoload.php file.

$servername = "localhost";
$username = "*";
$password = "*";
$dbname = "*";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Prisijungta";
echo "<br>";
$conn->set_charset('utf8');

$sql = "SELECT data.id, data.min_mok, data.kt_mok, data.nuolaida, data.viet_sk, data.viet_sms, data.viet_int, data.tarp_ry, data.tarptin_ry, data.pap_pas, data.pas_be_pvm, data.suma_be_pvm, data.pvm, data.suma, data.limitas, data.moketi, data.name, list.mail FROM data INNER JOIN list ON data.id=list.id";
$result = $conn->query($sql);

 if ($result->num_rows > 0){
    while ($row = $result->fetch_assoc()) {
        $userEmail = $row["mail"];
        $sname = $row["name"];


        $subject = "Telefono saskaita";
        $content = "Laba diena, $sname. Testuojame.";
        $mail = new PHPMailer();
        $mail->CharSet = 'UTF-8';
        $mail->IsSMTP();
        $mail->Mailer = "smtp";
        $mail->Host = "smtp.is.lt";
        $mail->Port = "587"; // 8025, 587 and 25 can also be used. Use Port 465 for SSL.

        $mail->SMTPAuth = true;
        $mail->SMTPSecure = 'none';
        $mail->Username = "i9020kn";
        $mail->Password = "agv751m7";

        $mail->From     = "admin@raseiniai.lt";
        $mail->FromName = "IT Skyrius";
        $mail->AddAddress($userEmail);
        $mail->AddReplyTo("it@raseiniai.lt", "IT Skyrius");

        $mail->Subject  = $subject;
        $mail->MsgHTML($content);
        $mail->WordWrap = 80;
        $mail->IsHTML(true);
        $mail->SMTPDebug = 1;


        if(!$mail->Send()) {
             echo 'Message was not sent.';
             echo 'Mailer error: ' . $mail->ErrorInfo;
             exit;
        } else {
             echo 'Message has been sent.';
        }
    }
}

?>