$ _ROW 'id' remove user from Get doesn't work

I have the following code to load users into a table: register.php

here I want to delete users. Only the second script deleteUsers.php

doesn't work.

Can anyone help me?

register.php`

<?php               
    $edit = 'edit:';
    $account = 'Username:';
    $account = '<font size="4">'.$account.'</font>';
    $password1 = 'Password:';
    $password1 = '<font size="4">'.$password1.'</font>';
    $id = 'id:';
    $id = '<font size="4">'.$id.'</font>';
      //check db connection
     if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
      } 
       // Take everything from table and fill in $result
       $sql = "SELECT * FROM login";
       $result = $conn->query($sql);

       echo"<table border=4><tr><td>$account</td><td>$password1</td><td>$id</td><td>edit</td><td>delete</td></tr>";

        if ($result->num_rows > 0) {
        // Take all data
        while($row = $result->fetch_assoc()) {

        echo"<tr><td>".$row['username']."</td><td>".$row['password']."</td><td>".$row['id']."</td><td><a href='/editUser.php'> edit </a> </td><td> <a href='/deleteUser.php'> delete</a> </td></tr>";

           }
            } else {
            // nothing in DB is 0 results
             echo "0 results";
             }
            echo"</table>";
             $conn->close();




                        ?>

      

You see that there is a delete button that redirects to deleteUser.php

This is the page you find here, unfortunately the delete function does not work:

<?php

require_once("/db_conn.php");

 // check if the 'id' variable is set in URL, and check that it is valid
 if (isset($_GET['id']) && is_numeric($_GET['id']))
 {
 // get id value
(isset($_GET['id'])

 // delete the entry
$result = mysql_query("DELETE FROM login WHERE id =$id")
 or die(mysql_error());


 // redirect back to the view page
 header("Location: register.php");
 }
 else
 // if id isn't set, or isn't valid, redirect back to view page
 {
echo "doesn'twork";
 }

?>

      

+3


source to share


3 answers


you need to pass id

while($row = $result->fetch_assoc()) {

                                    echo"<tr><td>".$row['username']."</td><td>".$row['password']."</td><td>".$row['id']."</td><td><a href='/editUser.php'> edit </a> </td><td> <a href='/deleteUser.php?id=". $row['id']."'> delete</a> </td></tr>";

                            }

      



on deleteuser.php

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

      

0


source


You need to pass the id variable:



while($row = $result->fetch_assoc()) 
{
    echo"<tr><td>".$row['username']."</td><td>".$row['password']."</td><td>".$row['id']."</td><td><a href='/editUser.php'> edit </a> </td><td> <a href='/deleteUser.php?id=" . $row['id'] . "'> delete</a> </td></tr>";
 }

      

+1


source


$id=$_GET['id'];

must deliver upon request

-1


source







All Articles