PHP POST data to another page using AJAX

Question

I currently have a form in PHP that gets validated using JQuery and the data is submitted to the DB. During the INSERT I'm getting the ID of the user that was inserted.
On success, it redirects the user to the next page which I then want to display the $user_id. I know I should be using get or some other method but unsure how to go about it with my current set up. Any help would be appreciated.

JS

                var submitRequest = $.ajax({
                     type: "POST",
                     url: "submit.php",
                     data: user_data
                });

                submitRequest.done(function(msg)
                {
                    //success
                   // / console.log('success');
                   window.location.href = "nextpage.php";
                });

PHP

$query_user ="INSERT INTO mytable(name,email) VALUES ('".$name."', '".$email."' )";
$sql_user =mysql_query($query_user) or die (mysql_error());
$user_id = mysql_insert_id();

nextpage.php

//How can I get it to display $user_id?

Why shouldn't I use mysql_* functions in PHP?

Phil
– Phil

2014-08-06 07:01:30 +00:00
Commented Aug 6, 2014 at 7:01 — Phil
– Phil, Commented Aug 6, 2014 at 7:01

Khushboo · Accepted Answer · 2014-08-06 06:47:36Z

1

Try below :-

PHP

$query_user ="INSERT INTO mytable(name,email) VALUES ('".$name."', '".$email."' )";
$sql_user =mysql_query($query_user) or die (mysql_error());
$user_id = mysql_insert_id();
echo $user_id;

JS

submitRequest.done(function(msg)
                {
                    //success
                   // / console.log('success');
                   window.location.href = "nextpage.php?id="+msg; // msg will consist userid
                });

nextpage.php

$userid = $_GET["id"];

answered Aug 6, 2014 at 6:47

Khushboo

1,8191 gold badge11 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

PHP POST data to another page using AJAX

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related