Ben Nozar
asked on
Bootstrap - BootBox - PHP - MYSQL - Response Trigger
HI
I have a PHP/MYSQL page, where the form and the insert query is all in one page. I am trying using BootBox to call a modal/alert to show up when the form is successfully inserted and want the modal to get triggered by the SQL response. Note insert is just post not done via ajax code.
if($_POST['item_Name']!='' ){
$insItem = $dbCon->prepare("INSERT INTO TBL_item (itemName, itemWeight, itemCost) VALUES(:itemName, :itemWeight, :itemCost)");
$insClient->bindparam(":it emName",$_ POST['item _Name'], PDO::PARAM_STR);
......
......
$$insItem ->execute();
if($insClient){
$response="fail";
}else{
$response="pass";
}
echo $response;
}
<script type="text/javascript">
$(document).ready(function () {
.done(function(response) {
bootbox.dialog({
className: "Success_CSS",
size: "small",
title: "Action!",
message: response});
})
.fail(function() {
bootbox.alert('MyMessageHe re');
})
</script>
I appreciate any help in advance
Thanks
Ben
I have a PHP/MYSQL page, where the form and the insert query is all in one page. I am trying using BootBox to call a modal/alert to show up when the form is successfully inserted and want the modal to get triggered by the SQL response. Note insert is just post not done via ajax code.
if($_POST['item_Name']!=''
$insItem = $dbCon->prepare("INSERT INTO TBL_item (itemName, itemWeight, itemCost) VALUES(:itemName, :itemWeight, :itemCost)");
$insClient->bindparam(":it
......
......
$$insItem ->execute();
if($insClient){
$response="fail";
}else{
$response="pass";
}
echo $response;
}
<script type="text/javascript">
$(document).ready(function
.done(function(response) {
bootbox.dialog({
className: "Success_CSS",
size: "small",
title: "Action!",
message: response});
})
.fail(function() {
bootbox.alert('MyMessageHe
})
</script>
I appreciate any help in advance
Thanks
Ben
ASKER
In this code I am trying to invoke the BootBox.Js Alert. Previously was using BootStrap Modal with PHP to show the Alert/Modal, but I like to standardise the codes so I am trying to adapt to BootBox.js
Previously:
[?php if($_GET['response']=='pas s') { ?]
<div class="modal modal-alert fade" id="successModal" tabindex="-1" role="dialog" aria-labelledby="myModalLa bel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</butt on>
<h3><i class="glyphicon glyphicon-thumbs-up"></i>S uccess</h3 >
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
[?php }elseif($_GET['response']= ='fail'){ ?]
<div class="modal modal-alert fade" id="warningModal" tabindex="-1" role="dialog" aria-labelledby="myModalLa bel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</butt on>
<h3><i class="glyphicon glyphicon-thumbs-down"></i > Error </h3>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
[?php } ?]
Previously:
[?php if($_GET['response']=='pas
<div class="modal modal-alert fade" id="successModal" tabindex="-1" role="dialog" aria-labelledby="myModalLa
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</butt
<h3><i class="glyphicon glyphicon-thumbs-up"></i>S
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
[?php }elseif($_GET['response']=
<div class="modal modal-alert fade" id="warningModal" tabindex="-1" role="dialog" aria-labelledby="myModalLa
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</butt
<h3><i class="glyphicon glyphicon-thumbs-down"></i
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
[?php } ?]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked perfectly, not sure why i did not take the same approach as i did with first bootstrap modal as you did.
Tank You, Well Done. Much appreciated.
Tank You, Well Done. Much appreciated.
ASKER
Thanking You
You are welcome!
Open in new window