$mysqli = new MySQLi($mysql['host'],$mysql['user'],$mysql['pass'],$mysql['db']) or die($mysqli->error);
$account="someemail@gmail.com";
$password="somepass";



include("lib/phpmailer/PHPMailerAutoload.php");

        function FilterInput($string)
    {
        $string = htmlentities($string);
        $string = mysqli_real_escape_string($string);
        return $string;
    }
    function random_string($length) {
        $key = '';
        $keys = array_merge(range(0, 9), range('a', 'z'));

    for ($i = 0; $i < $length; $i++) {
        $key .= $keys[array_rand($keys)];
    }

    return $key;
}



    if(isset($_POST['passwordForgot']))
    {
        $email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
        if (filter_var($email, FILTER_VALIDATE_EMAIL) === false) {
        }
        $result = $mysqli->query('SELECT id, mail from users WHERE mail = "'. $email. '"');
        if (mysqli_num_rows($result) > 0)
        {

            while ($row = mysqli_fetch_assoc($result))
            {

                $token = random_string(50);
                $mysqli->query('INSERT INTO `nabbo_tokens` (`user_id`, `token`) VALUES ("'. $row['id']. '", "'.$token. '")');
                $mysqli->query('INSERT INTO `nabbo_token_logs` (`user_id`, `action`) VALUES ("'. $row['id']. '", "changed password via token")');



                $mail = new PHPMailer();

                $mail->IsSMTP();
                $mail->CharSet = 'UTF-8';
                $mail->Host = "smtp.gmail.com";
                $mail->SMTPAuth= true;
                $mail->Port = 465;
                $mail->Username= $account;
                $mail->Password= $password;
                $mail->SMTPSecure = 'ssl';
                $mail->From = "kpro.server@gmail.com";
                $mail->FromName= "Runo Hotel - Müşteri Hizmetleri";
                $mail->isHTML(true);
                $mail->Subject = "Müşteri Hizmetleri – Şifremi unuttum";
                $mail->Body = 'body message';
                $mail->addAddress($email);
                $mail->SMTPDebug = 0;
                $geluktWachtwoord = true;
                $geluktWachtwoord = "Basari";
            if(!$mail->send()){
 die ("Mailer Error: " . $mail->ErrorInfo);
            }

            }
        }
        else{
                $errorWachwoordLog = true;
                $errorWachwoordLog = "Geçersiz bir e-posta adresi girdiniz.";

        }

    }

?>