Tweet
echo"<tr>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\">$row[id]</font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\">$row[usr]</font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=loeschen&id=$row[id]\">User Löschen</a></font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=aendern&id=$row[id]\">User ändern</a></font></td>
</tr>";
Moderator
<?php
//ausgabe.php
include ("db_file");
?>
<html>
<body>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10%" bgcolor="cecece"><font face="Arial" color="Red">UserID</font></td>
<td width="70%" bgcolor="cecece"><font face="Arial" color="red">User Name</font></td>
<td width="10%" bgcolor="cecece"><font face="Arial" color="Red">Löschen</font></td>
<td width="10%" bgcolor="cecece"><font face="Arial" color="Red">Ändern</font></td>
</tr>
<?
// User aus der Datenbank holen
$res = mysql_query("SELECT * FROM users")or die(mysql_error());
while($row=mysql_fetch_array($res))
{
// Farbwechsler
if (($counter++ % 2) != 0)
{
$bg="#999999";
}
else
{
$bg="#CCCCCC";
}
echo'<tr>
<td bgcolor="$bg"><font face="Arial" color="black">$row[id]</font></td>
<td bgcolor="$bg"><font face="Arial" color="black">$row[usr]</font></td>
<td bgcolor="$bg"><font face="Arial" color="black"><a href="tuwas.php?action=loeschen&id=$row[id]">User Löschen</a></font></td>
<td bgcolor="$bg"><font face="Arial" color="black"><a href="tuwas.php?action=aendern&id=$row[usr]">User ändern</a></font></td>
</tr>';
}
?>
</table>
</body>
</html>
echo "<tr>
<td bgcolor=\"",$bg,"\"><font face=\"Arial\" color=\"black\">",$row->id,"</font></td>
<td bgcolor=\"",$bg,"\"><font face=\"Arial\" color=\"black\">",$row->usr,"</font></td>
<td bgcolor=\"",$bg,"\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=loeschen&id=",$row->id,"\">User Löschen</a></font></td>
<td bgcolor=\"",$bg,"\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=aendern&id=",$row->usr,"\">User ändern</a></font></td>
</tr>";
}
echo"<tr>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\">$row[id]</font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\">$row[usr]</font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=loeschen&id=$row[id]\">User Löschen</a></font></td>
<td bgcolor=\"$bg\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=aendern&id=$row[usr]\">User ändern</a></font></td>
</tr>";
echo "<tr>
<td bgcolor=\"".$bg."\"><font face=\"Arial\" color=\"black\">".$row->id."</font></td>
<td bgcolor=\"".$bg."\"><font face=\"Arial\" color=\"black\">".$row->usr."</font></td>
<td bgcolor=\"".$bg."\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=loeschen&id=".$row->id."\">User Löschen</a></font></td>
<td bgcolor=\"".$bg."\"><font face=\"Arial\" color=\"black\"><a href=\"tuwas.php?action=aendern&id=".$row->usr."\">User ändern</a></font></td>
</tr>";
}
<?php
//tuwas.php
include ("db_file");
?>
<html>
<body>
<?php
// hier wird der User gelöscht
if($action== "loeschen")
{
$res = mysql_query("DELETE FROM users WHERE $id")or die(mysql_error());
$num = mysql_affected_rows();
if ($num>0)
{
echo '<font face="Arial" color="red"><b>Der User wurde gelöscht.</b></font>';
}
}
// hier wird der User geändert
if($acion == "aendern")
{
$res = mysql_query("SELECT * FROM users WHERE $id")or die(mysql_error());
while($row = mysql_fetch_array($res))
{
echo'<form action="tuwas.php?action=jetzt" method="post">
<input type="hidden" name="id" value="$row[id]">
<table width="50%" border="0">
<tr>
<td width="20%">User Name:</td>
<td width="80%">$row[usr]</td>
</tr>
<tr>
<td width="20%">User eMail:</td>
<td width="80%"><input type="text" name="eMail" value="$row[usr]"></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" value="User ändern"></center></td>
</tr>
</table>
</form>';
}
}
// hier wird der User in der Datenbank geändert
if($action=="jetzt")
{
$res = mysql_query("UPDATE users SET usereMail='$eMail' WHERE userID='$id'")or die(mysql_error());
$num = mysql_affected_rows();
if ($num>0)
{
echo '<font face="Arial" color="red"><b>Der User wurde geändert.</b></font>';
}
}
?>
</body>
</html>
$res = mysql_query("DELETE FROM users WHERE id='$id'")or die(mysql_error());
Kommentar