<meta charset="UTF-8">
<link href="./style.css" type="text/css" rel="stylesheet">
<script src="./jquery.js"></script>
<?php
$titel = $_POST["promoter"];

$dir = 'sqlite:phpliteAdmin_v1-9-5/testdaten';
$dbh = new PDO($dir) or die ("cannot open the database");

$sth = $dbh->prepare("SELECT * FROM neueUser");
$sth->execute();

/* Fetch all of the remaining rows in the result set */
$result = $sth->fetchAll();

$text= "Titel,Vorname,Nachname,Email,PLZ,Ort,Arztnummer,Facharzt,zweiter Facharzt\n";

//echo "Titel,Vorname,Nachname,PLZ,Ort,Facharzt,zweiter Facharzt,Promoter\n";
foreach($result as $row){
$text.=  $row['titel'].','.$row['vorname'].','.$row['nachname'].','.$row['email'].','.$row['plz'].','.$row['ort'].','.$row['arztnummer'].','.$row['facharzt'].','.$row['zweiterFacharzt'].','.$titel."\n";
//echo $row['titel'].','.$row['vorname'].','.$row['nachname'].','.$row['plz'].','.$row['ort'].','.$row['facharzt'].','.$row['zweiterFacharzt']."\n";
}

$file= fopen("user.csv","w") or die("unable to open file");
fwrite($file,$text);
fclose($file);

 ?>
<?php
require './class.phpmailer.php';
require './class.smtp.php';


define('GUSER', 'pmleads@esanum.de'); // GMail username
define('GPWD', 'T1n4turner'); // GMail password

function smtpmailer($to, $from, $from_name, $subject, $body) {
	global $error;
	$mail = new PHPMailer();  // create a new object
	$mail->IsSMTP(); // enable SMTP
	$mail->SMTPDebug = 0;  // debugging: 1 = errors and messages, 2 = messages only
	$mail->SMTPOptions = array(
		'ssl' => array(
			'verify_peer' => false,
			'verify_peer_name' => false,
			'allow_self_signed' => true
		)
	);
	$mail->SMTPAuth = true;  // authentication enabled
	$mail->SMTPSecure = 'ssl'; // secure transfer enabled REQUIRED for GMail
	$mail->Host = 'smtp.gmail.com';
	$mail->Port = 465;
	$mail->Username = GUSER;
	$mail->Password = GPWD;
	$mail->SetFrom($from, $from_name);
	$mail->Subject = $subject;
	$mail->Body = $body;
	$mail->AddAddress($to);
	$mail->AddAttachment('./user.csv');
	if(!$mail->Send()) {
		$error = 'Mail error: '.$mail->ErrorInfo;
		return false;
	} else {
		$error = 'Message sent!';
		return true;
	}
}

$text='Promoter '.$titel.' hat die Daten im Anhang versendet';

if (smtpmailer('pmleads@esanum.de', 'pmleads@esanum.de', 'Promoter', 'Messedaten', $text)) {
	// do something
}
if (!empty($error)) echo $error;

?>
<script>

//window.location.href='./Registrierung.php';

</script>