How to delete a record

[alhakimy]

I use google for translation

I have this code

 

<?php
//step one connect with database
$connect = new mysqli ("localhost","root","0220","test");
?>

<?php
// insert step
$id=$_POST['id'];
$name=$_POST['name'];
$pass=$_POST['pass'];

$sql = "INSERT INTO users (id, name, pass)VALUES ('$id', '$name', '$pass')";
if($_POST['enter']) {
    
    // not null text
    if(empty($id)||empty($name)||empty($pass)){
    echo "You did not enter the required fields.";
    die;
}
if ($connect->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $connect->error;
}}
?>

<?php
//step 2 the select query
$qur = "select * from users";
$result = mysqli_query($connect, $qur);
If ( ! $result ){
Die ("error in query"); }
?>

<?php
//step 3 show the data
echo "<table border='1'>";
While ($row= mysqli_fetch_assoc($result)){
Echo "<tr><td>".$row["id"]."</td><td>".$row["name"]."</td><td>".$row["pass"]."</td><td><a href='delete?id=".$row["id"]."'>del</a></td></tr>";}
echo "</table>"
?>

Makes like the  attached picture

 

what should I do To delete the record When pressed Del
 

thank you

[justsomeguy]

On your delete page, you can access $_GET['id'] to get the ID that you passed in the URL.  You can either delete immediately, or show a confirmation page to make sure they meant to do that, or whatever you'd like to do.  With the database ID you can just use a regular delete query to delete the record with that ID.

[alhakimy]

Thank you justsomeguy

Now when the deletion process
Do not delete directly when press the Delete
But after pressing Refresh the page is deleted

[justsomeguy]

If you need help with your code, we'll need to see the actual code you're using for the delete page.