Deleting a row with Php & MySQL

user3725879

I am new to php and SQL and just toying around with a project for my own understanding of accessing, updating and deleting data from my Database.

I have managed to show the selected data, create a button to delete a specific Id but really needing some assistance with deleting the selected row or record instead of hard coding in the ID in my delete php script.

Here is an example of my script:

<?php

    $sql = "SELECT id, firstname, lastname, joinDate FROM customers";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row

        while($row =  $result->fetch_assoc()) {
            echo 
                "<div class='trow'>" . 
                $row["id"]. ": " . 
                $row["firstname"] . " " . 
                $row["lastname"]. " " . 
                $row["joinDate"]. " " . 
                "<span class='deleteMember'>
                    <form action='deleteMember.php' method='POST'>
                        <button type='submit'>Delete</button>
                    </form>
                </span>" . " " . 
                "<span class='editMember'><a href='#'>Edit</a></span>" . 
                "<br></div>";
        }

    } else {
        echo "0 results";
    }

    $conn->close();

?>

Here is the delete.php

<?php

    // sql to delete a record
    $sql = "DELETE FROM customers WHERE id='6' ";

    if ($conn->query($sql) === TRUE) {
       header("Location: index.php");
    } else {
        echo "Error deleting record: " . $conn->error;
    }

    $conn->close();

?>

what I would like it to do is, delete the row from which you hit the delete button from and not just delete the row I have specified in the delete.php script. I understand HOW it should work by posting the id but not sure how to do it.

Pranay Aher

Do like this

<?php

    // sql to delete a record
    $sql = "DELETE FROM customers WHERE id='".$_GET['id']."' ";

    if ($conn->query($sql) === TRUE) {
       header("Location: index.php");
    } else {
        echo "Error deleting record: " . $conn->error;
    }

    $conn->close();

?>

<?php

    $sql = "SELECT id, firstname, lastname, joinDate FROM customers";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row

        while($row =  $result->fetch_assoc()) {
            echo 
                "<div class='trow'>" . 
                $row["id"]. ": " . 
                $row["firstname"] . " " . 
                $row["lastname"]. " " . 
                $row["joinDate"]. " " . 
                "<span><a href='deleteMember.php?id=".$row['id']."'>Delete</a></span>" . 
                "<span class='editMember'><a href='#'>Edit</a></span>" . 
                "<br></div>";
        }

    } else {
        echo "0 results";
    }

    $conn->close();
?>

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related