sql - delete button in PHP website behaving like static when clicked

Question

i have a simple delete button in PHP which uses simple SQL query to delete the data from database, I have used the following code:

$myid = $this->uri->segment('3');
if (isset($_POST['submit'])){
    $ret = mysqli_query($con,"delete * from smart_category where name='$myid'");
    header("Location: https://cloudclassmate.com/jewelry-catalogue/admin/viewcategory");
}

<div style="margin-left:38%" class="clearfix">
    <a href="https://cloudclassmate.com/jewelry-catalogue/admin/viewcategory"> 
        <button type="button" class="cancelbtn bemine">Cancel</button></a>
    <form action="" method="post" ><button type="submit" name="submit"  class="deletebtn bemine">Delete</button></form>
</div>

the problem here is if I click the delete button, its not responding, nothing is happening. the button is like static. can anyone please tell me what could be wrong here

question from:https://stackoverflow.com/questions/66064196/delete-button-in-php-website-behaving-like-static-when-clicked

Answer 1

If any Javasscript is not involved, than just put form action. Also send myid in the request or in URI. please see below:

<div style="margin-left:38%" class="clearfix">
    <a href="https://cloudclassmate.com/jewelry-catalogue/admin/viewcategory"><button type="button" class="cancelbtn bemine">Cancel</button></a>
    <form action="abc.php" method="post" ><button type="submit" name="submit"  class="deletebtn bemine">Delete</button></form>
</div>