Skip to main content
P
Prince Mike
Inspiring
April 19, 2019
Answered

Show alert message after updating record

  • April 19, 2019
  • 2 replies
  • 5356 views

Hello All,

Please could someone kindly review my code and advice where I am wrong. Below is a code on how to show an alert message after updating a record  but it seems not to work. I use similar code for insert and its working well but on Update its not showing any message

Below is the UPDATE  code

<?php

if(isset($_POST['submit']))

{

$ass_id=$_POST['ass_id'];

$txpaid=$_POST['txpaid'];

$editedby=$_POST['editedby']; 

$dateedited=$_POST['dateedited'];

mysql_select_db ($database_DB,$DB);

$qur="UPDATE tbl_assess SET txpaid='$txpaid', editedby='$editedby', dateedited='$dateedited' WHERE ass_id=$ass_id";

$retval = mysql_query($qur,$CRIRS_DB) or die(mysql_error());

if ($retval == true) {

$result='<div class="alert alert-success">Your assessment was successfully posted</div>';

}else {

$result='<div class="alert alert-danger">Sorry there was an error posting your assessment. Please try again</div>';

}

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

}

?>

Here is the code above my form that shows the message

<div class="col-sm-10 col-sm-offset-2">

            <?php echo $result; ?>   

</div>

Your review tips is highly appreciated...

Thank you in anticipation.

Mike

This topic has been closed for replies.
Correct answer osgood_

Start a php SESSION by inserting session_start(); BEFORE anything else on your page:

<?php

session_start();

?>

Obviously you then have a connection to your database.

Below is the code to execute once the 'submit' button has been clicked: (include the correct variable id name for your $_POST - $***_id=$_POST['***_id']; and your sql query WHERE ***_id=$***_id in the code below)

<?php

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

$***_id=$_POST['***_id'];

$txpaid=$_POST['txpaid'];

$editedby=$_POST['editedby'];

$dateedited=$_POST['dateedited'];

$qur="UPDATE tbl_assess SET txpaid='$txpaid', editedby='$editedby', dateedited='$dateedited' WHERE ***_id=$***_id";

mysql_select_db($database_DB, $DB);

$retval = mysql_query($qur, $DB);

if($retval) {

$_SESSION['result'] = '<div class="alert alert-success">Your assessment was successfully posted</div>';

}else {

$_SESSION['result'] = '<div class="alert alert-danger">Sorry there was an error posting your assessment. Please try again</div>';

}

mysql_close($DB);

}

?>

Insert the below in the page where you want your 'result' message to appear:

<?php

if(isset($_SESSION['result'])) {

echo $_SESSION['result'];

unset($_SESSION["result"]);

}

?>

The other way to do this is use Ajax to process the form and send the response 'data' from the php processing page back to the form page.

2 replies

B i r n o u
B i r n o u
Legend
August 18, 2021

there was question, that seams to have been removed ?....

O
osgood_
Legend
April 19, 2019

You need to store the '$result' message in a php $_SESSION variable because you are returning to the same page once the form update button is clicked and the $result variable wont be set until you click the form update button again. Everytime the page reloads php resets itself to zero unless you store information in session variables.

Give me a shout in the forum if you want a code example using a $_SESSION

P
Prince MikeAuthor
Inspiring
April 23, 2019

Dear osgood_,

I really appreciate your response.

Please I will need some code example on how to use the $_SESSION.

Thank you so much....

Mike

O
osgood_Correct answer
Legend
April 23, 2019

Start a php SESSION by inserting session_start(); BEFORE anything else on your page:

<?php

session_start();

?>

Obviously you then have a connection to your database.

Below is the code to execute once the 'submit' button has been clicked: (include the correct variable id name for your $_POST - $***_id=$_POST['***_id']; and your sql query WHERE ***_id=$***_id in the code below)

<?php

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

$***_id=$_POST['***_id'];

$txpaid=$_POST['txpaid'];

$editedby=$_POST['editedby'];

$dateedited=$_POST['dateedited'];

$qur="UPDATE tbl_assess SET txpaid='$txpaid', editedby='$editedby', dateedited='$dateedited' WHERE ***_id=$***_id";

mysql_select_db($database_DB, $DB);

$retval = mysql_query($qur, $DB);

if($retval) {

$_SESSION['result'] = '<div class="alert alert-success">Your assessment was successfully posted</div>';

}else {

$_SESSION['result'] = '<div class="alert alert-danger">Sorry there was an error posting your assessment. Please try again</div>';

}

mysql_close($DB);

}

?>

Insert the below in the page where you want your 'result' message to appear:

<?php

if(isset($_SESSION['result'])) {

echo $_SESSION['result'];

unset($_SESSION["result"]);

}

?>

The other way to do this is use Ajax to process the form and send the response 'data' from the php processing page back to the form page.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices