Javascript popup after php / mysql database update

Question

What I have is php that updates the database field after a client signs a form. This works, but I want it to redirect to a new page after it is confirmed that the user signed it by clicking OK. It they click CANCEL it will leave them on the same page.

<?php
    $username = 'joeblow';
    require_once ("/mypath/include/connnect_db.php");
?>

    <p>Please only submit this after above form is completely signed.</p>
    <form id="item_complete" method="post">
      <input name="submit" type="submit" form="item_complete"  value="Submit After Signing">
    </form>
<?php
    if(isset($_POST['submit'])) {  //if the submit button is clicked
        $complete = 'c';
        $query = "UPDATE mytbale SET mycolumn='c' WHERE username='$username'";
        mysqli_query($con,$query) or  die("Cannot Update");
        echo "<script> confirmFunction(); </script>";
    }
    require_once ("/mypath/include/disconnect_db.php");
?>
    <script type="text/x-javascript">
        function confirmFunction(){
            var r=confirm("Confirm that you have signed the form!");
            if (r==true){
              window.open("http://smartpathrealty.com/smart-path-member-page/");
              }
            else {
              }
            }
    </script>

My problem is the javascript function does not execute after the php updtates the database.

I appreciate any advice or comments you have about this.

PHP executes on the server. Javascript executes on the client. What you want is impossible. You can NOT have server-side PHP code trigger a client-side alert and then WAIT for the client to respond. — Marc B
– Marc B, Commented Mar 3, 2014 at 21:26
Is there anyway to redirect to back to a page after the user submits the form. I am very open to suggestions. — tashworth19191
– tashworth19191, Commented Mar 3, 2014 at 21:37

Community · Accepted Answer · 2017-05-23 10:31:57Z

2

The problem is that you are using separate <script> tags and calling the function before it is defined. These two together do not work well. Also, I'm pretty sure that <script type="text/x-javascript"> does not work anyway since it's outdated and that you want <script type="text/javascript">

You can do the following:

Move function up and fix x-javascript:

<?php
    $username = 'joeblow';
    require_once ("/mypath/include/connnect_db.php");
?>
<p>Please only submit this after above form is completely signed.</p>
<form id="item_complete" method="post">
    <input name="submit" type="submit" form="item_complete"  value="Submit After Signing">
</form>
<script type="text/javascript">
    function confirmFunction(){
        var r=confirm("Confirm that you have signed the form!");
        if (r==true){
          window.open("http://smartpathrealty.com/smart-path-member-page/");
          }
        else {
          }
        }
</script> 
<?php
if(isset($_POST['submit'])) {  //if the submit button is clicked
    $complete = 'c';
    $query = "UPDATE mytbale SET mycolumn='c' WHERE username='$username'";
    mysqli_query($con,$query) or  die("Cannot Update");
    echo "<script> confirmFunction(); </script>";
}
require_once ("/mypath/include/disconnect_db.php");
?>

Fiddle: Fiddle

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Mar 3, 2014 at 21:35

Anonymous

12.1k7 gold badges37 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tashworth19191 Over a year ago

This helped me find a solution that I post on bottom.

Anonymous Over a year ago

Okay, great. I'm glad I could help.

Cjmarkham · Accepted Answer · 2014-03-03 21:29:04Z

1

You could post the form via ajax and in your php you can return a response to the javascript. That was you could use a callback to fire the new window.

Heres a jquery example:

$.post('/myscript.php', {foo: 'bar'}).done(function (response) {

window.open(......);

});

answered Mar 3, 2014 at 21:29

Cjmarkham

9,7336 gold badges52 silver badges85 bronze badges

1 Comment

tashworth19191 Over a year ago

Sorry, I am not followign this at all.

Ducane · Accepted Answer · 2014-03-03 21:32:12Z

0

I believe you are using same page for landing and updating. What you need is to update your echo to add an onload.

echo "<script> window.onload=confirmFunction(); </script>";

Hope this what you are looking for.

answered Mar 3, 2014 at 21:32

Ducane

1291 silver badge7 bronze badges

2 Comments

tashworth19191 Over a year ago

This loads the confirmation before the submit button is clicked.

Ducane Over a year ago

I meant to add it the echo from your code snippet. You only have 1 which is inside if(isset($_POST['submit'])) {.....}, why would it run by default ?

user2793390 · Accepted Answer · 2014-03-03 21:49:28Z

0

<script type="text/javascript">
    function confirmFunction(){
        var r=confirm("Confirm that you have signed the form!");
        if (r==true){
          window.open("http://smartpathrealty.com/smart-path-member-page/");
          }
        else {
          }
        }
</script> 
<?php
if(isset($_POST['submit'])) {  //if the submit button is clicked
    $complete = 'c';
    $query = "UPDATE mytbale SET mycolumn='c' WHERE username='$username'";
    mysqli_query($con,$query) or  die("Cannot Update");
    echo "<script> confirmFunction(); </script>";
}
require_once ("/mypath/include/disconnect_db.php");
?>

<script type="text/javascript">


    window.onload = function(){
        <?php
            if(submitted){
                echo "confirmFunction();";
            }
        ?>
    }
</script>

edited Mar 3, 2014 at 21:49

answered Mar 3, 2014 at 21:28

user2793390

7811 gold badge7 silver badges29 bronze badges

2 Comments

tashworth19191 Over a year ago

This loads the confirmation before the submit button is clicked.

user2793390 Over a year ago

@user3376610 I updated my answer for your single page solution. The idea is to make the content of window.onload dependent on a variable set when your SQL transaction completes. Of course, multiple page solutions like others suggested would be much cleaner.

Jeff B · Accepted Answer · 2014-03-03 21:59:57Z

0

Try:

if (r==true) {
    window.open("http://smartpathrealty.com/smart-path-member-page/");
}
else {
    window.location = "PAGE THAT YOU WANT"; 
}

edited Mar 3, 2014 at 21:59

Jeff B

9,14220 gold badges68 silver badges146 bronze badges

answered Mar 3, 2014 at 21:33

Adam

1,69414 silver badges18 bronze badges

1 Comment

tashworth19191 Over a year ago

This part of script already works correctly, just trying to figure out how after the person submits the form and all the php is executed next the user will see a pop up confirmation window.

Collectives™ on Stack Overflow

Javascript popup after php / mysql database update

5 Answers 5

2 Comments

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related