I am using <?php echo $_SERVER['PHP_SELF']; ?>
in form.
After submit form when I refresh page it submit form again and again.
Kindly help me avoid resubmit of form on refresh page.
here is PHP code:
if (isset($_POST["patientName"])){
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO `inpatient`(`patientId`, `patientName`, `guardianName`,
`age`, `gender`, `mobile`, `address`, `city`, `symptoms`, `reference`, `date`, `time`, `doctorName`, `email`)
VALUES('$patientId', '$patientName', '$guardianName', '$age', '$gender', '$mobile', '$address', '$city', '$symptoms',
'$reference', '$date', '$time', '$doctorName', '$email')";
$conn->exec($sql);
}
echo '
<div style="position:absolute; bottom:0; left:0; z-index:1000; " class="alert alert-icon-left alert-success alert-dismissible fade in mb-2" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">x</span>
</button>
<strong>Well done!</strong> You successfully entered the <a href="#" class="alert-link">Patient</a> data.
</div>
';
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
I don't want to use header. I'm printing success message on same page