Ryan D Ryan D - 1 month ago 7
Ajax Question

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

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?

Answer

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'];