Delete Script Not Working
Posted: Thu Jan 29, 2009 10:24 pm
I've used this code before but now that I've transferred servers it's not working. If anyone could take a look at this and see what the deal is I'd greatly appreciate it. Thanks!
Code: Select all
<?php session_start (); ?>
<style type="text/css">
.bodyspan3 {
color: #FFFFFF;
font-weight: bold;
background-color: #666666;
}
</style>
<h3>Delete Users</h3>
<?php
$host="localhost"; // Host name
$username="***"; // Mysql username
$password="****"; // Mysql password
$db_name="login"; // Database name
$tbl_name="users"; // Table name
$logged_in = $_SESSION['logged_in'];
$level = $_SESSION['level'];
$alternate = "2";
if ($logged_in && $level == '1') {
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM `$tbl_name` ORDER BY `username` ASC";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
<table border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table>
<tr bgcolor="#666666">
<td align="center"></td>
<td align="center"><span class="bodyspan3">Username</span></td>
<td align="center"><span class="bodyspan3">Name</span></td>
<td align="center"><span class="bodyspan3">Level</span></td>
<td align="center"><span class="bodyspan3">Active</span></td>
</tr>
<?php
while($r=mysql_fetch_array($result)){
$db_id = $r["id"];
$db_first = $r["first"];
$db_last = $r["last"];
$db_username = $r["username"];
$db_level = $r["level"];
$db_active = $r["active"];
if ($alternate == 1) {
$color = "#CCCCCC";
$alternate = 2;
} else {
$color = "#FFFFFF";
$alternate = 1;
} if ($db_level == 0) {
$userlvl='Member';
} elseif ($db_level == 2) {
$userlvl = 'Moderator';
} else {
$userlvl='Admin';
} if ($db_active == 0) {
$active2='<a href="edit.php?id='.$db_id.'&enable=1" style="color:#FF0000;">No</a>';
} else {
$active2='<a href="edit.php?id='.$db_id.'&enable=0" style="color:#339900;">Yes</a>';
}
echo '<tr bgcolor="'.$color.'">
<td align="center"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="'.$db_id.'"></td>
<td><span>'.$db_username.'</span></td>
<td><span>'.$db_first.' '.$db_last.'</span></td>
<td><span>'.$userlvl.'</span></td>
<td><span>'.$active2.'</span></td>
</tr>';
}
?>
<tr>
<td colspan="5" align="center"><input name="delete" type="submit" id="delete" value="Delete" class="input2"></td>
</tr>
<?
if($delete && $level == '1'){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}
}
if($result){
echo "Member(s) deleted";
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>
<?php
} else {
echo '<h1>Forbidden</h1><p class="logintxt">You are not authorized to view this page</p>';
}
?>