How to pass a javascript variable to php using getJSON

Question

I'm trying to create a page that lists some notifications according to the user id.

I have this Javascript function to get the results as JSON

  var url="http://localhost/app/demo/getNotifications.php";
    $$.getJSON(url, function (result) {
      $$.each(result, function (i, field) {

        var nID = field.id;
        var nDonor = field.donor_id;

        // APPENDS DATA TO LISTFVIEW
        $$("#notlistview").append("HTML HERE");
      });

    });

And this is the php file:

<?php
include "db1.php";

$USERID = " ";

$data=array();
$q=mysqli_query($con,"SELECT * FROM blood_donations WHERE requester_id='USERID'  ORDER BY `id` DESC");
while ($row=mysqli_fetch_object($q)){
 $data[]=$row;
}
echo json_encode($data);
?>

My question is how do I pass a value from javascript to fill in the $USERID in the php file with the sent Value?

I only need to retrieve the results related to the USERID, so if you have another way, that's fine too.

your code is vulnerable to sql injection attacks;

hassan
– hassan

2017-03-22 21:40:55 +00:00
Commented Mar 22, 2017 at 21:40 — hassan
– hassan, Commented Mar 22, 2017 at 21:40

hassan · Accepted Answer · 2017-03-22 21:41:59Z

1

You use the builtin global $_GET to retrieve parameters:

<?php
if (isset($_GET['userid'])) {
    $USERID = $_GET['userid'];
} else {
    $USERID = " ";
}
?>

And to pass the value from jQuery:

$.getJSON(url,
{
    userid: myUserID 
},
function (result) {
        // your result function
});

edited Mar 22, 2017 at 21:41

hassan

8,3282 gold badges28 silver badges40 bronze badges

answered Mar 22, 2017 at 21:34

Jeff B

30.1k7 gold badges64 silver badges91 bronze badges

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

1 Comment

Fala Over a year ago

Thank you! let me give it a try and get back to you.

Simon K · Accepted Answer · 2017-03-22 21:37:05Z

1

Change this...

$$.getJSON(url, function (result) {

To this...

$$.getJSON(url, {userID:123}, function (result) {

Set 123 to whatever value you want.

Then in your PHP get your variable from $_GET['userID']

Be careful. Your script is vulnerable to SQL injection.

answered Mar 22, 2017 at 21:37

Simon K

1,5231 gold badge9 silver badges10 bronze badges

3 Comments

Fala Over a year ago

Thank you for your answer, same as first answer which I already tried! But I really appreciate you taking the time to help me.

Simon K Over a year ago

No problem. I'm new to stack overflow. I find it frustrating when I have taken time to answer a question and half way though, writing the answer, someone else comes in with the same answer before me and steals my thunder! Ah well!

Fala Over a year ago

Haha, yeah it happened to me before! this is how it is, first correct answer and you're obligated to mark it as complete, lol. Thanks and sorry again.

Collectives™ on Stack Overflow

How to pass a javascript variable to php using getJSON

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related