[blackcoder00]

guys im wonder how can i create some button that delete data from a table i didn't find how could i do it so i have replaced the button with <a> tag ==><a href="edit.php?id= . $$row["name"] for the where condition delete from list where id = '$_GET['name']'

index.php file

PHP Code


<?php 
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

  $sql = "DELETE FROM list where name = '$id'";


if (mysqli_query($conn, $sql)) {


  echo "succes delete you can back <a href='index.php' back </a>";

  
} else {
  echo "_error_: " . $sql . "<br>" . mysqli_error($conn);
} 


updatetable.php file

PHP Code


<?php 
 while($row = mysqli_fetch_assoc($result)) {
    echo "<tr><td>"."<a href='php/updatetable.php?id=" . $row["name"]. " </a></td><td> " . $row["description"]. "</td><td> " . $row["matiere"]. "</td><td>".$row["date"]."</td><td>".$row["jour"]."</td><td>".$row["time"]."</td></tr></form>";
  }
} else {
  echo "0 results";
}
echo"</tbody></table></div>";

?>

[HFDone]

delete the row in the db and load the table again

[blackcoder00]

i want to create a buttuon to select a specific item to delete it in the table

[HFDone]

so add button and onclick put the code to delete it and load the table again

[blackcoder00]

so add button and onclick put the code to delete it and load the table again

can you show me some example please

[HFDone]

search for html table delete row by id

[Squito]

https://stackoverflow.com/questions/2906...ike-a-link

[blackcoder00]

https://stackoverflow.com/questions/2906...ike-a-link

dude i want to create a button that delete a specific row from database like the example in the picture

[Squito]

And I provided a solution, that you have to change slightly to work the way you want it. If I do it all for you, you are going to miss the 'figuring out' part of the process, which is eventually a bad thing.

[HFDone]

https://stackoverflow.com/a/46325093

[blackcoder00]

And I provided a solution, that you have to change slightly to work the way you want it. If I do it all for you, you are going to miss the 'figuring out' part of the process, which is eventually a bad thing.

thank you alot dude i will try it <3

[Backbone]

I do it like this.
On table:

Code

- loop on result
- get the row id
- placed the row id on a href link of delete button

Example: <a href="?action=delete&id=ROW_ID">Delete</a>

On back-end code:

Code

- Check for the action and id query param
- Do the delete query using the id query param

[blackcoder00]

I do it like this.
On table:

Code

- loop on result
- get the row id
- placed the row id on a href link of delete button

Example: <a href="?action=delete&id=ROW_ID">Delete</a>

On back-end code:

Code

- Check for the action and id query param
- Do the delete query using the id query param

your idea is pretty good thank you aloot

[DyMa]

your idea is pretty good thank you aloot

friendly reminder to use prepared statement for this