Message after submitting and refresh to main page

Question

I want that after submitting a message appears and after three seconds refresh to main page. Need some suggestions to Code this.

Here the main Code with no message:

<!DOCTYPE html>
<html>
<meta http-equiv="content-type" content="text/html" />  
<meta charset="utf-8" />
<?php
require_once("db.inc.php");
?>
<link rel="stylesheet" type="text/css" href="styles2.css" />
</head>
<body>
<?php




if(isset($_POST['selected_name'])){



$stmt = $mysqli->prepare("DELETE FROM artikel WHERE anr=?");
    $stmt->bind_param('i', $_POST['selected_name']);
    $stmt->execute();
    $stmt->close();

if ()

}

?>
<form action="" method="POST">
<p>Artikel:
<?php

$stmt = $mysqli->prepare("SELECT anr, name FROM artikel");
$stmt->execute();
$stmt->bind_result($anr, $name);
echo "<select name='selected_name'><br />";
while ($stmt->fetch ()) {
echo '<option value='.$anr.'>'.$anr.' | '.$name.'</option>'; 

}

echo "</select>"; 





?>
<input type="submit" value="Datensatz löschen" />
</form>
</body>
</html>

For me it's not clear how to Code the if condition in order to let appear the message only after submitting.

you could use a meta refresh method. you can read http://stackoverflow.com/questions/768431/how-to-make-a-redirect-in-php - I.e.: `` — Funk Forty Niner, Jun 27 '16 at 14:26
The problem is not refresh but how to code a message after submitting — Marco, Jun 27 '16 at 14:28
you wrote *"and after three seconds refresh to main page"* - So, echo a message after the code executes successfully and put the meta under it — Funk Forty Niner, Jun 27 '16 at 14:28
I've echo the message, but after submitting it remains on the main page, also after refreshing — Marco, Jun 27 '16 at 14:29
then show us in your question how you're doing that. If it's not working then you may very well have errors. — Funk Forty Niner, Jun 27 '16 at 14:30

score 0 · Answer 1 · answered Jun 27 '16 at 19:07

I have Code it this way:

<?php




if(isset($_POST['selected_name'])){



$stmt = $mysqli->prepare("DELETE FROM artikel WHERE anr=?");
    $stmt->bind_param('i', $_POST['selected_name']);
    $stmt->execute();
    $stmt->close();

   echo "<h2>Artikel gelöscht</h2>";



}
 header ("refresh:3; url=test.php");

?>
 <form action="" method="POST">
<p>Artikel:
 <?php

$stmt = $mysqli->prepare("SELECT anr, name FROM artikel");
 $stmt->execute();
$stmt->bind_result($anr, $name);
echo "<select name='selected_name'><br />";
while ($stmt->fetch()) {
 echo '<option value='.$anr.'>'.$anr.' | '.$name.'</option>';

}


echo "</select>";





 ?>
<input type="submit" name="submit" value="Datensatz löschen" />
</form>
</body>
</html>

But this way the message don't disappear and the page refresh every three seconds, even if i don't submit

Message after submitting and refresh to main page

1 Answers1