There is a form in which the information is being edited, after pressing the "Save" button, the edited information is saved, but to see this edited information in the form, the page must be updated again, how to make an automatic form update?

<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Ρ€Π΅Π΄Π°ΠΊΡ‚ΠΈΡ€ΠΎΠ²Π°Π½ΠΈΠ΅ ΠΊΠ»ΠΈΠ΅Π½Ρ‚Π°</title> </head> <body> <?php include_once("db1.php"); $id = $_GET['id']; $rezult=mysql_query("SELECT * FROM klienti WHERE id='$id' "); $row = mysql_fetch_assoc($rezult); if (isset($_POST['save'])) { $klient = strip_tags(trim($_POST['klient'])) ; $op_firma=strip_tags(trim($_POST['op_forma'])) ; $naimen=strip_tags(trim($_POST['naimen'])) ; $otrasl=strip_tags(trim($_POST['otrasl'])) ; $telefon=strip_tags(trim($_POST['telefon'])) ; $email=strip_tags(trim($_POST['email'])) ; $kont_lico=strip_tags(trim($_POST['kont_lico'])) ; $dolznost=strip_tags(trim($_POST['dolznost'])) ; mysql_query(" UPDATE klienti SET klient='$klient', op_forma='$op_firma', naimen='$naimen',otrasl='$otrasl',telefon='$telefon',email='$email',kont_lico='$kont_lico',dolznost='$dolznost' WHERE id='$id' "); mysql_close(); } ?> <form method="post" action="edit.php?id=<?php echo $id; ?>" id="form"> ΠΊΠ»ΠΈΠ΅Π½Ρ‚<br/> <input type="text" name="klient" value="<?php echo $row['klient'] ; ?>" /><br/> ОП_Ρ„ΠΎΡ€ΠΌΠ° <br/> <input type="text" name="op_forma" value="<?php echo $row['op_forma'] ; ?>" /> <br/> <!-- cols="10" rows="10" --> НаимСн <br/> <input type="text" name="naimen" value="<?php echo $row['naimen'] ; ?>" /><br/><br/> ΠΎΡ‚Ρ€Π°ΡΠ»ΡŒ <br/> <input type="text" name="otrasl" value="<?php echo $row['otrasl'] ; ?>" /><br/><br/> telefon <br/> <input type="text" name="telefon" value="<?php echo $row['telefon'] ; ?>" /><br/><br/> email <br/> <input type="text" name="email" value="<?php echo $row['email'] ; ?>" /><br/><br/> ОП Ρ„ΠΈΡ€ΠΌΡ‹ <br/> <input type="text" name="kont_lico" value="<?php echo $row['kont_lico'] ; ?>"/><br/><br/> ОП Ρ„ΠΈΡ€ΠΌΡ‹ <br/> <input type="text" name="dolznost" value="<?php echo $row['dolznost'] ; ?>" /><br/><br/> <input type="hidden" name="date" value="<?php echo date ('Ym-d');?>" /> <input type="hidden" name="time" value="<?php echo date ('H:i:s');?>" /> <input type="submit" name="save" value="Π‘ΠΎΡ…Ρ€Π°Π½ΠΈΡ‚ΡŒ" /> </form> </body> </html>

    2 answers 2

    Obviously, it is necessary that the extraction of data from the database should follow after updating

     ... $id = $_GET['id']; // ΠŸΠ΅Ρ€Π΅Π½Π΅ΡΡ‚ΠΈ Π·Π° ΠΎΠ±Π½ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ // $rezult=mysql_query("SELECT * FROM klienti WHERE id='$id' "); // $row = mysql_fetch_assoc($rezult); if (isset($_POST['save'])) { $klient = strip_tags(trim($_POST['klient'])) ; $op_firma=strip_tags(trim($_POST['op_forma'])) ; $naimen=strip_tags(trim($_POST['naimen'])) ; $otrasl=strip_tags(trim($_POST['otrasl'])) ; $telefon=strip_tags(trim($_POST['telefon'])) ; $email=strip_tags(trim($_POST['email'])) ; $kont_lico=strip_tags(trim($_POST['kont_lico'])) ; $dolznost=strip_tags(trim($_POST['dolznost'])) ; mysql_query("UPDATE klienti SET klient='$klient', op_forma='$op_firma', naimen='$naimen',otrasl='$otrasl',telefon='$telefon',email='$email',kont_lico='$kont_lico',dolznost='$dolznost' WHERE id='$id'"); } // Π’Π΅ΠΏΠ΅Ρ€ΡŒ ΠΈΠ·Π²Π»Π΅ΠΊΠ°ΡŽΡ‚ΡΡ самыС свСТиС Π΄Π°Π½Π½Ρ‹Π΅, насколько это Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎ $rezult=mysql_query("SELECT * FROM klienti WHERE id='$id' "); $row = mysql_fetch_assoc($rezult); mysql_close(); ...

      After successful editing, redirect to the same page and that's it.

       header('Location: '.$_SERVER['PHP_SELF']);