Deleting row from table and database PHP/MySQL via image button

Question

I am trying to call a function within a php file that will fire a query to delete a row from a table and the database but can't seem to get it working

here is the button:

<td><a href="../service/deleteModule.php?id='.$row['id'].'"><img src="../web/img/delete.png" height='25' onclick="delete()" width='25' alt='delete'/></a></td>

Looks like you're going to need some JavaScript and PHP. Or do you have that already? — Jay Blanchard, Mar 02 '15 at 20:12
What is the current behavior, and what is the expected behavior? — Tripp Kinetics, Mar 02 '15 at 20:12
Well... shooting in the dark, your `` tag seems wrong. Assuming this code is inside a `` — bcesars, Mar 02 '15 at 20:14
public function delete($deletemodule){ return $this->moduleDao->deleteModule($deletemodule); } the onclick="delete()" function call doesn't get called, it is in a different file to the html code — Peter Connolly, Mar 02 '15 at 20:18

score 2 · Answer 1 · answered Mar 02 '15 at 20:42

You could use an XMLHttpRequest in JavaScript.

myWebpage.html

var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
    if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
        // Row deleted successfully
        alert(xmlhttp.responseText)
    }
}
xmlhttp.open("GET", "deleteRow.php?rowWhichNeedsToBeDeleted=" + rowId, true);
xmlhttp.send();

myPHP.php

<?php
    $rowId = $_GET["rowWhichNeedsToBeDeleted"];
    Code to delete row...
    echo "Success";
?>

More information is at: http://www.w3schools.com/php/php_ajax_php.asp

Hope this helps.

serverNewbie · Answer 2 · 2015-03-02T20:51:00.833

Call your php script by putting the button in a form and placing the php script in the form's action, which is called when the button is clicked.

<form method="post" action="delete.php">
  <td>
    <input type="image" name="delete" src="../web/img/delete.png"/>
 </td>
</form>

Update And call the specific function by using the isset method

<?php
 function delete()
 {
    function code here..
 }
if(isset($_POST['delete']))
 {
    delete();
 }
?>

Deleting row from table and database PHP/MySQL via image button

2 Answers2