you could Redirect to a "finish" page that shows the "last" DB entry what you have.
it could be a new page type. this page type could have a function in ..._controler like this:
function ShowTheLastContact() {
$Epics = new DataObjectSet();
$result5 = DB::query("SELECT * FROM MyOwnContactForm ORDER BY ID DESC LIMIT 1");
if($result5) {
foreach($result5 as $value5) {
$Datum = date("d.m.Y",$value5['Date']);
$Uhrzeit = date("H:i",$value5['Date']);
$eintraege = array(
'ID' => $value5['ID'],
'Name' => $value5['Name'],
'Email' => $value5['Email'],
'Message' => nl2br(htmlspecialchars($value5['Message'])),
'Datum' => $Datum,
'Uhrzeit' => $Uhrzeit
);
$Epics->push(new ArrayData($eintraege));
}
}
return $Epics;
}
and then you can show the last entry wioth this code in your .ss file of the page type:
<% control ShowTheLastContact %>
$Datum - $Uhrzeit<br ><br >
$Email- $Uhrzeit<br ><br >
From: <strong>$Name</strong><br ><br >
Message: $Message<br ><br >
<% end_control %>
But this is not very good, because every user who visits THIS "finish" page can see the last entry.. so contact messages from other users.
hmm.. you could make it, that this finish page just shows the last entry ONE TIME and then never again.
(before: -> I HOPE U DONT USE THE "USERDEFINEDFORM PAGE TYPE".. because you can do much more with your system when u write the forms by your self. --> look at all threads i postet.. there must be some nice helpings..)
soo..
you should add a new DB field to your contact DB.. its called maybe: "ShowMe".. this should be set to "1" with an hidden field in the ContactForm.
and now you can EDIT your function like this:
...
...
foreach($result5 as $value5) {
if($value5['ShowMe'] == 1) {
DB::query("UPDATE MyOwnContactForm SET ShowMe = '0' WHERE ID= '".$value5['ID']."');
$Datum = date("d.m.Y",$value5['Date']);
...
...
} else {
$value5['ID'] = "";
$value5['Name'] = "";
$value5['Email'] = "";
$value5['Message'] = "";
$Datum = "";
$Uhrzeit = "";
}
do you understand? so "ShowMe" will set to "0" after first watch.. the finish page will be empty when someone goes to it. just, when you redirect to the page after inserting a new contactForm, then he will se it.
###########################
#########################
# ITS NOT TESTED - ITS NOT TESTED#
#######################
######################
#####################
####################
###################
##################
#################
###############
##############
############
##########
########
######
####
##
#