auto deleting rows from MySQL on refresh forms

I have a simple search form to show results on next page using html/php

<form role="form" method="post" action="results.php" name="report">

Click to expand...

On on the results.php page, I used POST to get the values of the form. everything works just fine. The issue is when I can hit back and submit that form again, few times. I notices my MYSQL database rows are decreasing. I think this could be result of my submitting an form and hitting back.

is this correct? whats the solution?

results.php

$ExpenseItem=$_POST['ExpenseItem'];


$rtype=$_POST['requesttype'];

Click to expand...

Your question is not clear.

You are right to access post forms field data with the $_POST variable (as you noted it just works fine).

A search form anyway should execute only a SELECT mysql statement in your DB.
If your script is doing any DELETE statements on executing this form (highly unusual), then this could be indeed the cause.

But I rather guess that your row count is decreasing for an other reason...

You can enable the queries log and investigate what exactly is going on:
https://tableplus.com/blog/2018/10/how-to-show-queries-log-in-mysql.html
I hope this helps.

I have shared hosting plan and it wont allow to me log MySQL queries

yea it doesn’t make sense why my db rows would decrease without Delete query

my php code isn’t Wordpress but it could be this

https://wordpress.stackexchange.com/questions/380646/why-last-row-deleted-when-refresh-page