CREATE TABLE `user` (
`id` int(8) NOT NULL auto_increment,
`user_id` varchar(255) NOT NULL default '',
`nick` varchar(255) NOT NULL default '',
`vorname` varchar(255) NOT NULL default '',
`nachname` varchar(255) NOT NULL default '',
`strasse` varchar(255) NOT NULL default '',
`plz` varchar(255) NOT NULL default '',
`ort` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pubdate` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ;
dblogin.php
<?php
$server = 'localhost';
$benutzer = 'DEIN BENUTZERNAME';
$passwort = 'DEIN PASSWORT';
$datenbank = 'DEINE DATENBANK';
$verbindung= mysql_connect($server,$benutzer,$passwort) or die ('Verbindungsaufnahme mit MySQL-Server fehlgeschlagen!'
;
mysql_select_db($datenbank,$verbindung) or die ('Verbindungsaufnahme mit Datenbank fehlgeschlagen'
;
?>
newsletter.php
<?php
error_reporting(E_ALL);
$file = "Member Newsletter / Rundschreiben";
include_once('dblogin.php'
;
include_once('header.php'
;
if (isset($_POST['senden']))
{
$message = $_POST['message'];
$subject = $_POST['subject'];
$from = "DEINE MAIL";
strip_tags($message);
strip_tags($subject);
$putzen = array("ö" => "&ouml;", "ä" => "&auml;", "ü" => "&uuml;",
"Ö" => "&Ouml;", "Ä" => "&Auml;", "Ü" => "&Uuml;",
"ß" => "ss", "\"" => """, "'" => "",
"\\" => "", ":" => ":"
;
$subject = strtr($subject, $putzen);
$message = strtr($message, $putzen);
$abfrage = "SELECT * FROM user";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
mail($row->email,$subject,$message,"From: $from"
;
}
echo "
<h1 class='admintitel'>Rundschreiben i.o.</h1>
<table id='smalltab'> <tbody> <tr> <td>
Der Newsletter $subject <br /> $message <br /> wurde erfogreich versendet
</td> </tr> </tbody> </table>
";
}
else
{
echo "
<form action='".$_SERVER['PHP_SELF']."?".time()."' method='post' enctype='multipart/form-data'>
<table id='tab-normal'><tbody><tr>
<td class='normal-label'>Titel:</td>
<td><input type='text' name='subjekt' class='normal-input' /></td>
</tr> <tr>
<td class='normal-label'>Text:</td>
<td><textarea name='message' rows='10' cols='10' class='normal-input'></textarea></td>
</tr> <tr>
<td class='normal-label'>&nbsp;</td>
<td><input type='submit' name='senden' value='Absenden' class='subi' /></td>
</tr> </tbody> </table>
</form>
";
}
include_once('footer.php'
;
?>
newsletter-anmelden.php
<?php
ini_set('arg_separator.output','&amp;'
;
require_once ( dirname(__FILE__) . "/deutsch.php" );
include_once('dblogin.php'
;
include_once('header.php'
;
if (isset($_POST['senden']))
{
if($_REQUEST['vorname'] == ""
{echo "<h1>".VORNAMEFEHLER."</h1><form action='".$_SERVER['PHP_SELF']."' method='post' > <input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>";include 'footer.php'; exit;}
if($_REQUEST['ort'] == ""
{echo "<h1>".ORTFEHLER."</h1><form action='".$_SERVER['PHP_SELF']."' method='post' > <input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>";include 'footer.php'; exit;}
if($_REQUEST['plz'] == ""
{echo "<h1>".PLZFEHLER."</h1><form action='".$_SERVER['PHP_SELF']."' method='post' > <input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>";include 'footer.php'; exit;}
if($_REQUEST['email'] == ""
{echo "<h1>".EMAILFEHLER."</h1><form action='".$_SERVER['PHP_SELF']."' method='post' > <input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>";include 'footer.php'; exit;}
$vorname = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$vorname );
$name = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$name );
$nick = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$nick );
$strasse = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$strasse );
$ort = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$ort );
$email = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$email );
$url = preg_replace( "/(content-type:|bcc:|cc:|to:|from
/im", "",$url );
$vorname = $_REQUEST['vorname'];
$name = $_REQUEST['name'];
$nick = $_REQUEST['nick'];
$strasse = $_REQUEST['strasse'];
$plz = $_REQUEST['plz'];
$ort = $_REQUEST['ort'];
$email = $_REQUEST['email'];
$url = $_REQUEST['url'];
if ($_POST['email'] != '' && !ereg("^([a-zA-Z0-9\.\_\-]+)@([a-zA-Z0-9\.\-]+\.[A-Za-z][A-Za-z]+)$", $email))
{ /* else... */
echo "<h1>".EMAILFEHLER."</h1> <form action='".$_SERVER['PHP_SELF']."' method='post' >
<input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>"; include 'footer.php'; exit;/* wird die Fehlermeldung ausgegeben */
}
$user_id = time();
$sql = "INSERT INTO user (user_id, url, vorname, nachname, strasse, plz, ort, email, pubdate) VALUES ('$user_id', '$url', '$vorname','$name', '$strasse', '$plz', '$ort', '$email', NOW())";
// Ausführen der Query
$result = mysql_db_query($datenbank,$sql,$verbindung);
$num = mysql_affected_rows();
if ($num>0)
{
echo "<h1>".DATENOKAY."</h1>";
/*DEIN DANKESTEXT*/
}
else
{
echo "<h1>".DATENFEHLER."</h1>
<form action='".$_SERVER['PHP_SELF']."' method='post' > <input type='submit' name='zurueck' value='".ZURUECK."' class='formtab-submit'/> </form>
";
}
$strEmpfaenger = $email;
$from = "".EMAILVON."";
$strSubject = "".ANMELDUNGSUBJEKT."";
$strMailtext = "".LIEBER." $vorname $name,\n
".ANMELDUNGDANKE."\n
$user_id\n
$from";
mail($strEmpfaenger, $strSubject, $strMailtext,"From: $from"
or die("".EMAILTOT.""
;
mysql_close();
}
else
{
echo "<div class='admintext'><h1>".REGISTRATION."</h1>";
/*DEIN DANKESTEXT*/
echo "</div>
<form action='". $_SERVER['PHP_SELF']."' name='registration' method='post' enctype='multipart/form-data'>
<table cellspacing='0' cellpadding='1' id='formtab'><tbody>
<tr><td class='td-label'>
".VORNAME.":<span class='pflichtfelder'>&nbsp;*</span>
</td><td class='td-input'>
<input type='text' name='vorname' value='".$_REQUEST['vorname']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".NACHNAME.":
</td><td class='td-input'>
<input type='text' name='name' value='".$_REQUEST['name']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".NICK.":
</td><td class='td-input'>
<input type='text' name='nick' value='".$_REQUEST['nick']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".STRASSE.":
</td><td class='td-input'>
<input type='text' name='strasse' value='".$_REQUEST['strasse']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".PLZ.":<span class='pflichtfelder'>&nbsp;*</span>
</td><td class='td-input'>
<input type='text' name='plz' value='".$_REQUEST['plz']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".ORT.":<span class='pflichtfelder'>&nbsp;*</span>
</td><td class='td-input'>
<input type='text' name='ort' value='".$_REQUEST['ort']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".EMAIL.":<span class='pflichtfelder'>&nbsp;*</span>
</td><td class='td-input'>
<input type='text' name='email' value='".$_REQUEST['email']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
".WEBSITE.":
</td><td class='td-input'>
<input type='text' name='url' value='http://".$_REQUEST['url']."' class='input-gr' />
</td></tr><tr><td class='td-label'>
&nbsp;
</td><td class='td-input'>
<input type='submit' name='senden' value='".REGISTRATION."' class='formtab-submit' onClick='return registrationtest()' />
<span class='pflichtfelder'>&nbsp;&nbsp;&nbsp;*&nbsp;Pflichtfelder</span>
</td></tr>
</tbody></table>
</form>";
}
include_once('footer.php'
;
?>