PHP Ádmin script
Jeg har denne kode.Der står i linie 133-136 noget om option select, men denne kode vises ikke på min admin side.
Nogen der kan forklare og rette?
<?php
session_start();
include "level4_check.php";
$msg = "To edit a record click on the user name, to list by order click on titles.<br>YOU CANNOT EDIT ADMIN IN DEMO MODE.";
if(isset($_POST['Amend'])) {
$username = $_POST['username'];
$userlevel = $_POST['userlevel'];
$userid = $_POST['userid'];
$result = mysql_query("Update login_table set user_name='$username', user_level='$userlevel' where userid=".$_POST['userid']);
$msg = "Record is updated<br>To edit a record click on the user name";
$edit = "";
}
if(isset($_POST['Submit']))
{
$total = $_POST['total'];
$td = 0;
$i = 0;
for($i = 1; $i <= $total; $i++)
{
if(isset($_POST["d$i"]))
{
mysql_query("DELETE FROM login_table WHERE userid=".$_POST["d$i"],$con);
$td++;
}
}
$msg = "$td record(s) slettet!<br>Klik på brugernavn, for at rette";
}
if ($order == "") {$order = "userid";}
$result = mysql_query("Select * from login_table ORDER BY '$order'",$con);
$num = mysql_num_rows($result);
$n = 0;
?>
<html>
<head>
<title>Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#E1DEFE">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th class="header" scope="col"><div align="left" style="margin-left:10px;">OFE FORUM</div></th>
</tr>
</table>
<form name="form1" method="post" action="">
<p class="smallTextBlack"><?php echo $msg; ?><br>USER LEVELS:<BR>1 = (HIGH RESTRICTION - CAN ACCESS LEVEL 1 ONLY)<BR>2 = (MEDIUM RESTRICTION - CAN ACCESS BOTH LEVELS 2 & 1)<BR>3 = (LOW RESTRICTION - CAN ACCESS BOTH LEVELS 3, 2 & 1)<BR>4 = (ADMIN AND ALL LEVELS)</p>
<table width="100%" border="0" cellpadding="1" cellspacing="1" bordercolor="#000000">
<tr bgcolor="#A39FF6" class="standardText">
<td width="5%" background="images/bar.gif"><div align="center" class="smallTextWhite">DELETE</div></td>
<td width="5%" background="images/bar.gif"><div align="center"><a class="standardText" href="admin.php?order=userid">ID</a></div></td>
<td width="20%" background="images/bar.gif"><div align="center"><a class="standardText" href="admin.php?order=user_name">USER NAME</a> </div></td>
<td width="20%" background="images/bar.gif"><div align="center" class="smallTextWhite">PASSWORD </div></td>
<td width="5%" background="images/bar.gif"><div align="center"><a class="standardText" href="admin.php?order=user_level">LEVEL</a></div></td>
<td width="20%" background="images/bar.gif"><div align="center"><a class="standardText" href="admin.php?order=user_email">EMAIL</a></div></td>
<td width="5%" background="images/bar.gif"><div align="center" class="smallTextWhite">USER IP </div></td>
<td width="20%" background="images/bar.gif"><div align="center"><a class="standardText" href="admin.php?order=date">DATE REGISTERED</a> </div></td>
</tr>
<?php while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$n++;
?>
<tr>
<td width="5%"><div align="center"><?php if ($row['userid'] <> "185") { ?>
<input type="checkbox" name="d<?php echo $n;?>" value="<?php echo $row['userid'];?>"><? } ?>
</div></td>
<td width="5%"><?php echo $row['userid'];?></td>
<td width="20%"><?php if($row['userid'] > "1") { ?><a href="admin.php?edit=<?php echo $row['user_name']?>"><?php } echo $row['user_name'];?></a></td>
<td width="20%"><?php echo $row['user_pass'];?></td>
<td width="5%"><center><?php echo $row['user_level'];?></center></td>
<td width="20%"><?php echo $row['user_email'];?></td>
<td width="10%"><?php echo $row['user_ip'];?></td>
<td width="20%"><center><?php echo $row['date'];?></center></td>
</tr>
<?php
}?>
</tr>
<div align="center"></div>
</table>
<input type="submit" name="Submit" value="Delete"> <input name="total" type="hidden" id="total" value="<?php echo $n?>">
<p> </p></form>
<!-- FORM FOR AMENDMENT -->
<?php if ($edit) {$msg = "Edit record below";
if ($edit == "admin") {$msg = "You cannot edit Admin in this demo"; exit ();}
$result = mysql_query("Select * from login_table WHERE user_name = '$edit'",$con);
$row = mysql_fetch_array($result)
?>
<form name="form2" method="post" action="">
<div class="smallTextBlack">Edit user :-</div>
<table width="60%" border="0" cellpadding="1" cellspacing="1" bordercolor="#000000">
<tr bgcolor="#999999" class="smallTextWhite">
<td background="images/bar.gif"><div align="center" class="smallTextWhite">ID</div></td>
<td background="images/bar.gif"><div align="center" class="smallTextWhite">USER NAME </div></td>
<td width="20%" background="images/bar.gif"><div align="center" class="smallTextWhite">USER LEVEL </div></td>
<td background="images/bar.gif"><div align="center" class="smallTextWhite">DATE REGISTERED </div></td>
</tr>
<tr>
<td width="5%"><center><?php echo $row['userid'];?></center></td>
<td width="15%"><input type="username" name="username" value="<?php echo $row['user_name'];?>"></a></td>
<td width="15%">Change level:
<select name="userlevel"> <option>1</option>
<option>2</option>
<option>3</option>
<option>4</option></select>
<span class="smallErrorText">CURRENTLY SET AT LEVEL: <?php echo $row['user_level'];?></span></td>
<td width="10%"><div align="center"><?php echo $row['date'];?></div>
</td>
</tr>
</table>
<input type="hidden" name="userid" value="<?php echo $row['userid'];?>">
<input type="Submit" name="Amend" value="Update"></form>
<?php }?>
<p><a href="index.php">Back to index page</a></p>
</body>
</html>
