按HTML按钮截断MySQL表[重复]

Question

This question already has an answer here:

• MySql. After HTML button is clicked - TRUNCATE database table 2 answers

I am trying to create an HTML button, that, when pressed, it will truncate a MySQL table. I used the answer given here. The button works, but the problem is that when I refresh the page, the command is triggered and the table gets truncated, even though I have not pressed the truncate button. How can I fix that? I only have one .php file.

The code so far is:

<?php
$dbc = mysqli_connect('localhost', 'username', '', 'DB_name')
  or die('Error connecting to MySQL server.');
?>

<form method="post" action="<?php mysqli_query($dbc, 'TRUNCATE TABLE `my_table`')   ?>">
    <input name="submit_button" type="submit" value=" Truncate Table " />
</form>

I would not consider my question as a duplicate, because in the other question, there is a redirection to an other .php page.

</div>

Answer 1

Use something like this

<?php
$dbc = mysqli_connect('localhost', 'username', '', 'DB_name') or die('Error connecting to MySQL server.'); 
if(isset($_POST['submit_button']))
{
    mysqli_query($dbc, 'TRUNCATE TABLE `my_table`');
    header("Location: " . $_SERVER['PHP_SELF']);
    exit();
}

?>
<form method="post" action="">
    <input name="submit_button" type="submit" value=" Truncate Table " />
</form>