delete record from db via table

Question

i showing my users from database in html table i am make a button for every record in table for delete the record but i do not know how to do that
this is my code:

<table width="200" border="1">

    <?php
    while($row=mysqli_fetch_assoc($result)){
        ?><tr>
            <th scope="col">ID</th>
            <th scope="col">user</th>
            <th scope="row">pass</th>
            <th scope="col">edit</th>

        </tr>


        <td><?php echo $row['id']?></td>
        <td><?php echo $row['user']?></td>
        <td><?php echo $row['pass']?></td>
        <td><a href="delone.php"><button>edit</button></a></td>
        </tr>

        <?php
    }
    ?>


</table>

Harish Kulkarni · Accepted Answer · 2018-05-08 16:17:20Z

1

I think you are providing 'edit' option for every users. if u want to add delete option, that is : 'id, user, pass' of the user will be deleted. To do that just add this below edit option.

<td><a href="delete.php?id=<?php echo $row['id'] ?>" >Delete </a></td>

Now, using sql query you can delete that information from your db.

if (isset($_GET['id'])) {

      // write query to delete from db
}

Now record will be deleted from your Database. Do it carefully! Happy Coding!!!

answered May 8, 2018 at 16:17

Harish Kulkarni

1,64915 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

VIshal Jamwal · Accepted Answer · 2018-05-08 17:07:25Z

First,You have passed $_row in delete query. $_GET['id'] should be passed in palace of $_row.

Second,mysqli_fetch_assoc($result); This statement has no purpose for deletion

Third, use prepare statements to avoid mysql injections and validate $_GET['id'] value

<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
$myConnection= mysqli_connect("localhost","root","") or die ("could not connect to mysql"); 

mysqli_select_db($myConnection, "test") or die ("no database");
	
	//query
if (isset($_GET['id'])) {

      // write query to delete from db
	$sql="DELETE FROM `userpass` WHERE id='$_row'";
}
$result=mysqli_query($myConnection,$sql);
mysqli_fetch_assoc($result);
?>
</body>
</html>

Collectives™ on Stack Overflow

delete record from db via table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related