用于删除用户帐户的按钮

Question

I have a table that produces a list of user accounts from mysql db. I would like a button that can delete a user from this list.

Here is my form:

<td><form action="empdelete.php">
 <?php echo "<input type='text' name='employee' value='".$employee['username']."'/><button type='submit' class='btn btn-default'>Delete</button>"?>
        </form></td>;

Here is my empdelete.php:

<?php 
if($_POST['submit'])
{
    mysql_connect("host","username","pword") or die(mysql_error()); 


   mysql_select_db("db") or die(mysql_error()); 


   $username = $_POST['username'];


   $result=mysql_query("DELETE FROM employee WHERE username='$username'") or die(mysql_error()); 

    //confirm
   echo "Employee Deleted"; 
}
?>

The table name is employee and the column name is username. It doesn't seem to be working.. any suggestions?

Answer 1

You can use a normal link and pass the username as a GET parameter

<?php 
    echo '<a href="empdelete.php?username='.$employee['username'].'">Delete</a>';
?>

And then in your PHP you can take the value and make your delete

<?php 

if($_GET['username']) {

    mysql_connect("host","username","pword") or die(mysql_error()); 
    mysql_select_db("db") or die(mysql_error()); 

    $username = $_GET['username'];
    $result=mysql_query("DELETE FROM employee WHERE username='$username'") or die(mysql_error()); 

    echo "Employee Deleted"; 

}

?>

** be careful though - your approach leaves you open to SQL injection attacks, you should read up about these **