Jump to content

How to delete a record


alhakimy
 Share

Recommended Posts

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

form.JPG.a5cff079e997eaf45d9634e9a058865f.JPG

 

what should I do To delete the record When pressed Del
 

thank you

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...