Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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->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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement