Record Insert Success or Unsuccessful message

Please how can I add a success message that reads thus "Record Inserted Successfully" whenever my records are inserted into the database or "Record insert was not Successfully"

Here is my code

<?php
if ($_SERVER["REQUEST_METHOD"] === "POST") {
$InsertQuery = new WA_MySQLi_Query($SFT);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "findings";
$InsertQuery->bindColumn("indg_id", "i", "".((isset($_POST["indg_id"]))?$_POST["indg_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("ind_id", "i", "".((isset($_POST["ind_id"]))?$_POST["ind_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("question", "s", "".((isset($_POST["question"]))?$_POST["question"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("findings", "s", "".((isset($_POST["findings"]))?$_POST["findings"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("conclusion", "s", "".((isset($_POST["conclusion"]))?$_POST["conclusion"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("recomdns", "s", "".((isset($_POST["recomdns"]))?$_POST["recomdns"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("addedby", "s", "".((isset($_POST["addedby"]))?$_POST["addedby"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("fin_id");
$InsertQuery->execute();
$InsertGoTo = "dlis";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>

Thank you

Add a url parameter to your success redirect and then show the success message when the url parameter exists like:

<?php

if (isset($_GET["success"])) {

?>

Success Message Here

<?php

}

?>

Originally Said By: Ray Borduin

  Add a url parameter to your success redirect and then show the success message when the url parameter exists like:

php:

<?php

if (isset($_GET["success"])) {

?>

Success Message Here

<?php

}

?>

  

Thank you so much but I am not sure I know how to add a url parameter to my success redirect. Please help me with the full code including the URL Parameter you mentioned.

Thank you

$InsertGoTo = "yoursuccesspage.php?success";

Originally Said By: Ray Borduin

  $InsertGoTo = "yoursuccesspage.php?success";  

Thank you so so much.

Now putting all together I should get this right

<?php
if ($_SERVER["REQUEST_METHOD"] === "POST") {
$InsertQuery = new WA_MySQLi_Query($SFT);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "findings";
$InsertQuery->bindColumn("indg_id", "i", "".((isset($_POST["indg_id"]))?$_POST["indg_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("ind_id", "i", "".((isset($_POST["ind_id"]))?$_POST["ind_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("question", "s", "".((isset($_POST["question"]))?$_POST["question"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("findings", "s", "".((isset($_POST["findings"]))?$_POST["findings"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("conclusion", "s", "".((isset($_POST["conclusion"]))?$_POST["conclusion"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("recomdns", "s", "".((isset($_POST["recomdns"]))?$_POST["recomdns"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("addedby", "s", "".((isset($_POST["addedby"]))?$_POST["addedby"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("fin_id");
$InsertQuery->execute();
$InsertGoTo = "dli?success";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>

<?php
if (isset($_GET["success"])) {
?>
Success Message Here
<?php
}
?>

Yes, that should work.

Originally Said By: Ray Borduin

  Yes, that should work.  

Hello Sir, this success message is not popping up as expected. It just shows at the top.

Please see image at the bottom. I used the code as it.

<?php
if ($_SERVER["REQUEST_METHOD"] === "POST") {
$InsertQuery = new WA_MySQLi_Query($SFT);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "findings";
$InsertQuery->bindColumn("indg_id", "i", "".((isset($_POST["indg_id"]))?$_POST["indg_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("ind_id", "i", "".((isset($_POST["ind_id"]))?$_POST["ind_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("question", "s", "".((isset($_POST["question"]))?$_POST["question"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("findings", "s", "".((isset($_POST["findings"]))?$_POST["findings"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("conclusion", "s", "".((isset($_POST["conclusion"]))?$_POST["conclusion"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("recomdns", "s", "".((isset($_POST["recomdns"]))?$_POST["recomdns"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("addedby", "s", "".((isset($_POST["addedby"]))?$_POST["addedby"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("fin_id");
$InsertQuery->execute();
$InsertGoTo = "dli?success";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>

<?php
if (isset($_GET["success"])) {
?>
Your application was successfully submitted
<?php
}
?>

Please kindly review and advice.

Thank you so much

You can move that code to wherever you want it to appear. It appears on the top of the page because that is where it was placed.

Originally Said By: Ray Borduin

  You can move that code to wherever you want it to appear. It appears on the top of the page because that is where it was placed.  

OK that is a good one.

Lastly please, is it possible to make it to popup using JS Script alert code??? I want it to popup like a modal.

Is it also possible to add some CSS to it to make it look well formatted???

Thank you

Yes. Create a modal or style it before adding the conditional code to only show when the insert is successful. You can make it look however you want. It is just HTML like anything else on the page.