How can I pass a php variable to an external php file im getting data from with ajax?

Question

I have 2 files, index.php and ajax.php, I am retrieving data from ajax.php to display in index.php via ajax.. I would like to pass the username to ajax.php to use in my sql statement.. How can I achieve this?

index.php -

$profile_user =$_GET['user'];

    $(document).ready(function(){
        $('.loader').hide();
        var load = 0;
        var nbr = "<?php echo $nbr;?>";
        $(window).scroll (function(){
            if($(window).scrollTop() == $(document).height() - $(window).height()){
                $('.loader').show();
                load++;
                if(load * 5 > nbr){
                    $('.messages').text("No more to see..");
                    $('.loader').hide();
                }else{

                $.post("ajax.php", {load:load},function(data){
                    $(".images").append(data);
                    $('.loader').hide();
                });
                }
            }
        });
    });

ajax.php

$profile_user =$_GET['user'];
$sql = "SELECT * FROM images WHERE  user = '$profile_user'  ORDER BY ID DESC ";

Can I pass the variable in the ajax call?

You seem to be mixing up JavaScript and PHP here in an impossible way. See this question. — Pieter van den Ham
– Pieter van den Ham, Commented Oct 10, 2016 at 17:47
be a lot simpler if you just stored user in session variable instead of passing it all around — charlietfl
– charlietfl, Commented Oct 10, 2016 at 17:51

Robiseb · Accepted Answer · 2016-10-10 17:49:11Z

1

Add the PHP variable in the AJAX call

$.post("ajax.php", {
  load: load,
  user: '<?php echo $profile_user; ?>'
},function(data){

And change $_GET by $_POST in your ajax.php file, like this

$profile_user = $_POST['user'];

answered Oct 10, 2016 at 17:49

Robiseb

1,6062 gold badges17 silver badges19 bronze badges

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

1 Comment

Ryan D Over a year ago

Works like a champ Thanks a million!

Solrac · Accepted Answer · 2016-10-10 17:51:07Z

0

You need to POST that data:

            $.post('ajax.php', {load:load, user: '"<?php echo $_GET['user'];?>"'},function(data){
                $('.images').append(data);
                $('.loader').hide();
            });

answered Oct 10, 2016 at 17:51

Solrac

93010 silver badges26 bronze badges

Comments

Hemant Manwani · Accepted Answer · 2016-10-10 17:52:58Z

0

You can change

$.post("ajax.php", {load:load},function(data){
                    $(".images").append(data);
                    $('.loader').hide();
                });

to

$.post("ajax.php", {load:load, user:user},function(data){
                        $(".images").append(data);
                        $('.loader').hide();
                    });

And in ajax.php after getting mysql result just encode the array in json format and echo it.

$data = mysql_query($sql);
echo json_encode($data);exit;

answered Oct 10, 2016 at 17:52

Hemant Manwani

1288 bronze badges

Collectives™ on Stack Overflow

How can I pass a php variable to an external php file im getting data from with ajax?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related