Call PHP function from a button to delete row from a table

Question

I have the following code inside PHP page that displays data from a table. In the last column I have a delete button that calls a function to delete the corresponding row from the table:

    // Print data from db
    $result = mysql_query("SELECT * FROM questions");
    echo "<table border='1' align='center'>
    <tr>
    <th>ID</th>
    <th>Multiple Choice Question</th>
    <th>Correct answer</th>
    <th>The Tip You Give</th>
    <th>Edit Question</th>
    <th>Delete Question</th>
    </tr>";
    while($row = mysql_fetch_array($result))
    {
        echo "<tr>";
        echo "<td align='center'>" . $row['ID'] . "</td>";
        echo "<td>" . $row['Question'] . "</td>";
        echo "<td align='center'>" . $row['Answer'] . "</td>";
        echo "<td>" . $row['Help'] . "</td>";
        echo "<td align='center'><button type='button' onclick='edit_question()'><img src='images/Edit.png'></button></td>";
        echo "<td align='center'><button type='button' onclick='delete_question($row)'><img src='images/delete.png'></button></td>";
        echo "</tr>";
    }
    echo "</table>";

the function is the following:

    <script>
    function delete_question(int $row_id)
    {
       var r=confirm("Are you sure you want to delete this question?");
       if (r==true)
       {
          alert('<?php 
          $con=mysql_connect("localhost","stesia","stesia","stesia");
          // Check connection
          if (mysql_errno())
          {
             echo "Failed to connect to MySQL: " . mysql_error();
          }
          mysql_query($con,"DELETE FROM questions WHERE ID='".$row_id."'");
          echo "You want to delete the " . $row_id['ID'] . " question!";
          echo "Question deleted!";
          mysql_close($con);
          ?>');
       }
       else
       {
          alert("Question not deleted!");
       }
    }
    </script>

The problem is that the function is called and displays the messages, but the row is not deleted (checked that in mysql also). I have tried some things but no luck. What am I doing wrong here?

javascript is no PHP. do some ajax request.

bwoebi
– bwoebi

2013-05-28 10:58:14 +00:00
Commented May 28, 2013 at 10:58 — bwoebi
– bwoebi, Commented May 28, 2013 at 10:58

ragklaat · Accepted Answer · 2013-05-28 11:04:07Z

2

You cannot do this on client side. You should send an AJAX request to the server (PHP-) side to handle the deletion.

You can find related information here (though these are not showing the best practices, but it helps understanding the concepts): PHP - AJAX and MySQL

answered May 28, 2013 at 11:04

ragklaat

9665 silver badges12 bronze badges

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

Comments

ZeroGS · Accepted Answer · 2013-05-28 11:01:12Z

0

As far as i know onclick only executes JavaScript Code. You could try to put your PHP function into a JavaScript function and execute this from the onclick tag

answered May 28, 2013 at 11:01

ZeroGS

1392 gold badges3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Call PHP function from a button to delete row from a 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