retrieving data from db based on php's $_GET var with jquery/ajax?

Question

Disclaimer

I have searched for duplicates, but I can't seem to find them. I am surprised because this seems to be a big issue. I most likely am missing something big though.

Problem/Question

I am having the userid passed into through the url via php, myOtherScript.php?userid=1. How can I get that variable to be passed via ajax so that I may query the database with that userid, echo it out and return it to the page?

This is in global.js file

jQuery

$.ajax({
    url: "myScript.php",
    data: "userid="  - This is what I need: $_GET['userid'] - ,
    success: function( data ) {
        $('#myDiv').html( data );
    }
});

Solution

WIth the help of bstakes and this answer, I was able to figure it out with this function: (top answer)

function getParameterByName(name) {
    name = name.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");
    var regexS = "[\\?&]" + name + "=([^&#]*)";
    var regex = new RegExp(regexS);
    var results = regex.exec(window.location.href);
    if(results == null)
        return "";
    else
        return decodeURIComponent(results[1].replace(/\+/g, " "));
}

Thanks for the answers guys!

genesis · Accepted Answer · 2011-07-26 17:04:29Z

2

$.ajax({
    url: "myScript.php",
    data: "userid=<?php echo intval($_GET['userid']); ?>",
    success: function( data ) {
        $('#myDiv').html( data );
    }
});

edited Jul 26, 2011 at 17:04

answered Jul 26, 2011 at 15:50

genesis

51.1k20 gold badges99 silver badges127 bronze badges

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

7 Comments

Phil Over a year ago

Is that a safe/best practice type way of doing it? Does jQuery have a function to pull data from the url?

a1ex07 Over a year ago

@Phil: The safe practice is to use sessions, store user_id (and maybe some other data) in $_SESSION when user successfully logs in, and get it from there.

Phil Over a year ago

This solution does not work. You can't have PHP in a JS script.

genesis Over a year ago

@Phil: did you try it? Delete your downvote and try it first -.-

Phil Over a year ago

I want to keep the PHP and the JS separate. You can't do that with your current solution.

|

fire · Accepted Answer · 2011-07-27 08:17:39Z

You could also try using the search attribute of the window.location object.

If the url is http://www.mysite.com/display.php?userid=7 window.location.search will return "?userid=7". You will obviously need to remove the leading "?", but be aware that if there are additional GET paramaters, separated with ampersand '&', those will be included as well.

So, with a bit of additional Javascript, you can split on the '&', which gets you an array of "key=val", then you can spilt on the equal sign and create an object with {key : val}. Then you could use that object to access the query string params.

var qs = window.location.search.substring(1),
    pieces = qs.split('&'),
    i,
    qsObj {},
    tmp;
for ( var i in pieces ) {
   tmp = pieces[i].split('=');
   qsObj[tmp[0]] = tmp[1];
}

See https://developer.mozilla.org/En/Window.location for additional information on the window.location.

fire · Accepted Answer · 2011-07-26 15:53:58Z

1

If you want to keep the JS seperate, put it in a function that accepts the user id...

function do_something(user_id) {
    $.ajax({
        url: "myScript.php",
        data: "userid=" + user_id,
        success: function( data ) {
            $('#myDiv').html( data );
        }
    });
}

Then just call do_something($_GET['user_id']);

answered Jul 26, 2011 at 15:53

fire

21.5k18 gold badges82 silver badges116 bronze badges

2 Comments

Phil Over a year ago

This only works if you bring the function in the .php script. I want to be able to keep it in a separate JS script and still retrieve the $_GET vars.

fire Over a year ago

Well I wouldn't recommend doing it this way but in javascript you can pick out the query strings using good old location.href. There's some jquery plugins to make this easier, try plugins.jquery.com/project/query-object

Community · Accepted Answer · 2017-05-23 12:02:56Z

1

You might have to move the script inline on the PHP file then you echo out the $_GET['userid'] in the data area of your ajax call.

just found this: how to get GET and POST variables with JQuery?

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jul 26, 2011 at 15:50

David Nguyen

8,5182 gold badges35 silver badges50 bronze badges

Collectives™ on Stack Overflow

retrieving data from db based on php's $_GET var with jquery/ajax?

4 Answers 4

7 Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related