488 lines
23 KiB
PHP
Executable File
488 lines
23 KiB
PHP
Executable File
<?php
|
|
$user_admin=$_COOKIE["user_admin"];
|
|
include("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
|
|
// Rechteüberprüfung
|
|
$db = dbconnect();
|
|
if ($user_admin == ""){ require("index.php"); exit;} //Wenn man nicht angemeldet ist, darf man nicht auf die Seite
|
|
$result = $db->query("SELECT 1 FROM ver_admin_rechte, ver_admin_rechte_zuord , ver_admin where ver_admin_rechte.ver_admin_rolle = ver_admin_rechte_zuord.ver_admin_rolle AND ver_admin_rechte_zuord.vaid = ver_admin.vaid AND ver_admin.user = '$user_admin' AND ver_admin_rechte_zuord.ver_admin_rolle = 'a_mailadr'");
|
|
$row = $result->fetch_array();
|
|
if ($row[0] != 1){ include("kurs/rechte.php"); exit;}
|
|
// Rechteüberprüfung ende
|
|
|
|
if (isset($_GET['action']))
|
|
$action = $_GET['action'];
|
|
else
|
|
$action = "";
|
|
|
|
switch($action){
|
|
default:
|
|
|
|
|
|
echo"
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
|
|
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
|
|
<title>Mailadressen</title>
|
|
<SCRIPT LANGUAGE=\"JavaScript\"><!--
|
|
function initForm()
|
|
{
|
|
// Wenn man mit history.back zurückgeht werden wurden die disabled Felder ignoriert, daher nochmals prüfen,
|
|
// ob Innenverwaltung gesamt angeklickt ist
|
|
if(document.passback.I.checked)
|
|
{
|
|
document.passback.Zweig[0].disabled=true;
|
|
document.passback.Zweig[1].disabled=true;
|
|
}
|
|
}
|
|
//-->
|
|
</SCRIPT>
|
|
</head>
|
|
<body onload=initForm()>
|
|
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
|
|
<tr>
|
|
<td>
|
|
<div align=\"center\">
|
|
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
|
|
<tr>
|
|
<td width=\"10\" background=\"../images/box_e1.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
|
|
<td width=\"95%\" background=\"../images/box_top.gif\">
|
|
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
|
|
<font class=\"hd\">Mailadressen selektieren</font><br>
|
|
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"1%\" background=\"../images/box_l.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td colspan=\"2\"><br>
|
|
<form action="; echo $_SERVER['PHP_SELF'] . "?action=ausgabe1"; echo" method=\"POST\" name=\"passback\">";
|
|
echo "
|
|
<table cellspacing=\"1\" cellpadding=\"1\" width=\"100%\" border=\"0\">
|
|
<tr>
|
|
<td class=\"formdesc\" width=\"60%\">
|
|
Studiengang:
|
|
</td>
|
|
<SCRIPT LANGUAGE=\"JavaScript\"><!--
|
|
function codename() {
|
|
|
|
if(document.passback.I.checked)
|
|
{
|
|
document.passback.Zweig[0].disabled=true;
|
|
document.passback.Zweig[1].disabled=true;
|
|
}
|
|
else
|
|
{
|
|
document.passback.Zweig[0].disabled=false;
|
|
document.passback.Zweig[1].disabled=false;
|
|
}
|
|
}
|
|
//-->
|
|
</SCRIPT>
|
|
<td width=\"40%\">
|
|
<label for=\"I\"><input type=\"checkbox\" onclick=\"codename()\" name=\"I\" value=\"I\" id=\"I\"> Innenverwaltung</label><br>
|
|
<!-- <label for=\"r1\"><input type=\"radio\" name=\"Zweig\" value=\"V\" id=\"r1\"> Nur Innenverwaltung V-Zweig</label><br>
|
|
<label for=\"r2\"><input type=\"radio\" name=\"Zweig\" value=\"W\" id=\"r2\"> Nur Innenverwaltung W-Zweig</label><br> -->
|
|
<label for=\"D\"><input type=\"checkbox\" name=\"D\" value=\"D\" id=\"D\"> Dig. Verw.management</label><br>
|
|
<label for=\"R\"><input type=\"checkbox\" name=\"R\" value=\"R\" id=\"R\"> Rentenversicherung</label><br>
|
|
<label for=\"F\"><input type=\"checkbox\" name=\"F\" value=\"F\" id=\"F\"> Allgemeine Finanzverwaltung</label><br>
|
|
<label for=\"S\"><input type=\"checkbox\" name=\"S\" value=\"S\" id=\"S\"> Steuerverwaltung</label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class=\"formdesc\" width=\"60%\">
|
|
AG:<br>
|
|
<font size=\"1\">(Strg-Taste für Mehrfachauswahl)</font>
|
|
</td>
|
|
<td width=\"40%\">";
|
|
$db = dbconnect();
|
|
$query = "SELECT AG FROM stud GROUP BY AG";
|
|
$result = $db->query ($query)
|
|
or die ("Cannot execute query");
|
|
echo "<p align=\"left\"><select size=\"4\" name=\"ag[]\" multiple>";
|
|
while ($row = $result->fetch_array()){
|
|
echo "<option value=\"".$row['AG']."\">".$row['AG']." </option>\n";
|
|
}
|
|
echo "</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class=\"formdesc\" width=\"60%\">
|
|
Jahrgang:<br>
|
|
<font size=\"1\">(Strg-Taste für Mehrfachauswahl)</font>
|
|
</td>
|
|
<td width=\"40%\">";
|
|
$db = dbconnect();
|
|
$query = "SELECT Jahrgang FROM stud GROUP BY Jahrgang";
|
|
$result = $db->query ($query)
|
|
or die ("Cannot execute query");
|
|
echo "<p align=\"left\"><select size=\"4\" name=\"jahr[]\" multiple>";
|
|
while ($row = $result->fetch_array()){
|
|
echo "<option value=\"".$row['Jahrgang']."\">".$row['Jahrgang']." </option>\n";
|
|
}
|
|
echo "</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align=\"center\" colspan=\"2\">
|
|
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align='center' colspan=\"2\">
|
|
<input title=\"Suchen\" type=\"image\" src=\"../images/suchen.gif\" border=\"0\">
|
|
</td>
|
|
</tr>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
</form>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p><br>
|
|
</p>
|
|
</td>
|
|
<td width=\"1%\" background=\"../images/box_r.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html>";
|
|
|
|
break;
|
|
case "ausgabe1":
|
|
|
|
if ($_POST['I'] == "" and $_POST['R'] == "" and $_POST['F'] == "" and $_POST['S'] == "" and $_POST['D'] == "" ){ // mind. 1 Zweig muss angegeben werden. Getrennt durch and
|
|
echo "
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
|
|
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
|
|
<title>Eingabefehler</title>
|
|
</head>
|
|
<body>
|
|
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
|
|
<tr>
|
|
<td>
|
|
<div align=\"center\">
|
|
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
|
|
<tr>
|
|
<td width=\"10\" background=\"../images/box_e1.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
|
|
<td width=\"95%\" background=\"../images/box_top.gif\">
|
|
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
|
|
<span class=\"sh\">Eingabefehler</span><br>
|
|
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"1%\" background=\"../images/box_l.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td colspan=\"2\"><br>
|
|
<p align=\"center\"><b>Es muss mindestens 1 Zweig ausgefüllt werden</b>
|
|
</p>
|
|
<p align=\"center\"><a href=\"javascript:history.back()\">
|
|
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
|
|
</p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p><br>
|
|
</p>
|
|
</td>
|
|
<td width=\"1%\" background=\"../images/box_r.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html>";
|
|
exit;
|
|
}
|
|
/*
|
|
if ($_POST[ag] == ""){ // mind. 1 AG muss angegeben werden.
|
|
echo "
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
|
|
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
|
|
<title>Eingabefehler</title>
|
|
</head>
|
|
<body>
|
|
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
|
|
<tr>
|
|
<td>
|
|
<div align=\"center\">
|
|
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
|
|
<tr>
|
|
<td width=\"10\" background=\"../images/box_e1.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
|
|
<td width=\"95%\" background=\"../images/box_top.gif\">
|
|
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
|
|
<span class=\"sh\">Eingabefehler</span><br>
|
|
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"1%\" background=\"../images/box_l.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td colspan=\"2\"><br>
|
|
<p align=\"center\"><b>Es muss mindestens eine AG ausgefüllt werden</b>
|
|
</p>
|
|
<p align=\"center\"><a href=\"javascript:history.back()\">
|
|
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
|
|
</p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p><br>
|
|
</p>
|
|
</td>
|
|
<td width=\"1%\" background=\"../images/box_r.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html>";
|
|
exit;
|
|
}
|
|
|
|
if ($_POST[jahr] == ""){ // mind. 1 Jahrgang muss angegeben werden.
|
|
echo "
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
|
|
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
|
|
<title>Eingabefehler</title>
|
|
</head>
|
|
<body>
|
|
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
|
|
<tr>
|
|
<td>
|
|
<div align=\"center\">
|
|
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
|
|
<tr>
|
|
<td width=\"10\" background=\"../images/box_e1.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
|
|
<td width=\"95%\" background=\"../images/box_top.gif\">
|
|
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
|
|
<span class=\"sh\">Eingabefehler</span><br>
|
|
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"1%\" background=\"../images/box_l.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td colspan=\"2\"><br>
|
|
<p align=\"center\"><b>Es muss mindestens ein Jahrgang ausgefüllt werden</b>
|
|
</p>
|
|
<p align=\"center\"><a href=\"javascript:history.back()\">
|
|
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
|
|
</p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p></p>
|
|
<p><br>
|
|
</p>
|
|
</td>
|
|
<td width=\"1%\" background=\"../images/box_r.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html>";
|
|
exit;
|
|
}
|
|
*/
|
|
|
|
$year = $_POST['jahr'];
|
|
for ($i=0;$i<sizeof($year);$i++) {
|
|
$jahr .= "'$year[$i]', ";
|
|
}
|
|
|
|
$class = $_POST[ag];
|
|
for ($i=0;$i<sizeof($class);$i++) {
|
|
$ag .= "'$class[$i]', ";
|
|
}
|
|
|
|
|
|
$akt_zweig = "'$_POST[Zweig]',";
|
|
|
|
if($_POST['Zweig'] != ''){$Zweig =$akt_zweig;}else{$Zweig ='';};
|
|
if($_POST['I'] != ''){$Zweig .="'V','W','I',";}else{$Zweig .='';};
|
|
if($_POST['D'] != ''){$Zweig.="'".$_POST['D']."',";}else{$Zweig.='';};
|
|
if($_POST['R'] != ''){$Zweig.="'".$_POST['R']."',";}else{$Zweig.='';};
|
|
if($_POST['F'] != ''){$Zweig.="'".$_POST['F']."',";}else{$Zweig.='';};
|
|
if($_POST['S'] != ''){$Zweig.="'".$_POST['S']."',";}else{$Zweig.='';};
|
|
|
|
|
|
|
|
$jahr1 = substr($jahr,0,-2); // ', ' --> 2 Zeichen entfernen
|
|
$ag1 = substr($ag,0,-2); // ', ' --> 2 Zeichen entfernen
|
|
$Zweig1 = substr($Zweig,0,-1); // ',' --> 1 Zeichen entfernen
|
|
|
|
|
|
$krit_zweig = str_replace (array("'", "Array"), array(" ", ""), $Zweig1);
|
|
$krit_ag = str_replace (array("'", "Array"), array(" ", ""), $ag1);
|
|
$krit_jahr = str_replace (array("'", "Array"), array(" ", ""), $jahr1);
|
|
|
|
|
|
|
|
|
|
//In älteren PHP Versionen schreibt er array davor, obwohls keins ist, dies wird entfernt, Prob. bei der FH
|
|
$ag = str_replace("Array", '', $ag1);
|
|
$jahr = str_replace("Array", '', $jahr1);
|
|
|
|
if ($_POST['ag'] == ""){ // mind. 1 AG muss angegeben werden, wenn nicht, dann alle
|
|
$ag = "SELECT distinct AG from stud";
|
|
}
|
|
|
|
|
|
if ($_POST['jahr'] == ""){ // mind. 1 Jahrgang muss angegeben werden, wenn nicht, dann alle
|
|
$jahr = "SELECT distinct jahrgang from stud";
|
|
}
|
|
|
|
echo "
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
|
|
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
|
|
<title>Ausgabe Mailadressen</title>
|
|
</head>
|
|
<body onload=\"if(document.Mail)document.Mail.sender.focus();return false;\">
|
|
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
|
|
<tr>
|
|
<td>
|
|
<div align=\"center\">
|
|
<table cellspacing=\"0\" cellpadding=\"0\" width=\"50%\" border=\"0\">
|
|
<tr>
|
|
<td align=\"left\" width=\"1%\" width=\"10\" background=\"../images/box_e1.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td align=\"left\" width=\"98%\" background=\"../images/box_top.gif\" valign=\"top\" colspan=\"2\">
|
|
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
|
|
<font class=\"hd\">Mailadressen</font><br>
|
|
<font class=\"sh\"><b>Studienzweig:</b> $krit_zweig <br>
|
|
<b>AG:</b>"; if($krit_ag == ''){ echo " alle";}else{ " $krit_ag";} echo" <br>
|
|
<b>Jahrgang:</b>"; if($krit_jahr == ''){ echo " alle";}else{ " $krit_jahr";} echo" <br></font>
|
|
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
|
|
<td align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
|
|
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"1%\" background=\"../images/box_l.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td colspan=\"2\">
|
|
<table width=\"100%\" border=\"0\">";
|
|
$db = dbconnect();
|
|
|
|
$query = "SELECT mail
|
|
FROM stud
|
|
WHERE stg IN ($Zweig1)
|
|
AND ag IN ($ag)
|
|
AND jahrgang IN ($jahr)
|
|
AND durchgefallen != 'Y'
|
|
AND hs = 'L'
|
|
ORDER BY uid";
|
|
|
|
# echo $query;
|
|
# exit;
|
|
|
|
$result = $db->query($query)
|
|
or die ("Cannot execute query1");
|
|
while ($row = $result->fetch_array()){
|
|
$mail .= "$row[mail],<br>";
|
|
}
|
|
$mail2 = substr($mail,0,-5); // ',' --> 5 Zeichen entfernen ",<br>"
|
|
echo"
|
|
<tr>
|
|
<td width=\"100%\" valign=\"top\">$mail2</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
<td width=\"1%\" background=\"../images/box_r.gif\">
|
|
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
</tr>
|
|
<tr>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
|
|
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
|
|
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
|
|
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
Sie können den Inhalt der Tabelle kopieren<br>
|
|
und in Ihrem Mailprogramm einfügen!
|
|
<p>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html>";
|
|
} //Ende Action Abfrage
|
|
?>
|