After clicking on submit, a record is entered in the database, but if you refresh the page, the post is duplicated. At first, I made a script with a redirect to the same page and an alert, but only the alert with the message worked, but the redirect did not occur. Then I tried to redirect through onclick, but for some reason, it was necessary to click a second time after the data were recorded so that the redirect occurred. I looked for solutions, but they either did not work or were too complex for my understanding. How to solve?

Submission

<input type="submit" value="отправить" onclick="window.open('news.php','_self');" />

php

 <?php $title=$_POST['title']; $textarea=$_POST['textarea']; $img=$_POST['img']; $db = new PDO ('mysql:dbname=posting; host=localhost',"admin","1234"); $sql="insert into `news` (title,textarea,img) values (:title,:textarea,:img)"; $sth=$db->prepare($sql); $sth->bindValue(':title', $title); $sth->bindValue(':textarea', $textarea); $sth->bindValue(':img', $img); $sth->execute(); ?>
  • Well, add a check. For example, in theory there should not be entries with the same heading - bad for SEO. Add in the database a unique index for this field. When adding - check. - n.osennij
  • For some reason I can not add auto-increment to the title - it does not save. - Vladislav Morgunov
  • Yes, I didn’t understand how to add a unique index, but I did filtering by title and text, and now the records are not duplicated! Thank you. - Vladislav Morgunov
  • not auto-increment. Namely index. What do you use to work with the database? - n.osennij
  • Question solved. Thank you! - Vladislav Morgunov

0