Jump to content

How to delete a record


Recommended Posts

I use google for translation

I have this code


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

// insert step

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

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

//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

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

  • Create New...