AJAX (jquery) to run PHP script not working

Question

I am trying to make an ajax call to a php script that outputs images from a directory.

I have this as my php script:

<?php

 $con = @mysqli_connect('myhost','myusername','myuserpass','myuserDB') or die('Could not connect to the database.'." ". __FILE__ ." ". __LINE__);

 $photoFile = mysqli_query($con, 'select photoFile from photoInfo');
  while ($p = mysqli_fetch_array($photoFile)){
    echo '<img class="image" src='."../img/".$p['photoFile'].".jpeg />";
  };
 mysqli_close($con);

?>

And I'm trying to call it like this.

$(document).ready(function() {

   $.ajax({
       url: 'php/getImages.php',
       method: 'get',
       dataType: 'html'
           }).done(function(data){
          $('#imageBox').appendData(data);
     });
  });

What all am I doing wrong? When I run the php script on its own, it brings up the images but when I try to use ajax to call it, nothing happens.

It's seems to be nothing wrong with code. Just try to put complete path in image src and try. — Rajiv Ranjan
– Rajiv Ranjan, Commented Dec 2, 2013 at 5:35

Krish R · Accepted Answer · 2013-12-02 05:35:23Z

1

Can you try this, use $('#imageBox').html(data); instead of $('#imageBox').appendData(data);

<script type="text/javascript">
    $(document).ready(function() {

            $.ajax({
                url: 'php/getImages.php',            
                method: 'get',
                dataType: 'html'
            }).done(function(data){
                $('#imageBox').html(data);
            });
        });

</script>


  <div id="imageBox"></div>

In getImages.php,

    <?php

    $con = @mysqli_connect('myhost','myusername','myuserpass','myuserDB') or die('Could not connect to the database.'." ". __FILE__ ." ". __LINE__);

    $photoFile = mysqli_query($con, 'select photoFile from photoInfo');
    while ($p = mysqli_fetch_array($photoFile)){
        echo '<img class="image" src="../img/'.$p['photoFile'].'.jpeg" />';
    };
    mysqli_close($con);

    ?>

answered Dec 2, 2013 at 5:35

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

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

1 Comment

synapseradio Over a year ago

After cleaning up my php script (Thanks to you and Harish!) switching to .html worked. Thank you!

AAA · Accepted Answer · 2013-12-02 05:30:33Z

0

Try this code:

  while ($p = mysqli_fetch_array($photoFile)){
           $img_arr[]= '<img class="image" src='."../img/".$p['photoFile'].".jpeg />";
  };
echo json_encode($img_arr);
exit;

In javascript

$.get('php/getImages.php',function(data)
  $.each(data,function(k,e){
     html+=e;

});
$('#imageBox').appendData(html);
},'json');

answered Dec 2, 2013 at 5:30

AAA

1427 bronze badges

Comments

Harish Singh · Accepted Answer · 2013-12-02 05:34:44Z

0

$photoFile = mysqli_query($con, 'select photoFile from photoInfo');
while ($p = mysqli_fetch_array($photoFile)){
    $imgpath = "../img/".$p['photoFile'].".jpeg";
    echo '<img class="image" src="'.$imgpath.'" />';
};
mysqli_close($con);

answered Dec 2, 2013 at 5:34

Harish Singh

3,3195 gold badges27 silver badges40 bronze badges

Comments

Pushker Yadav · Accepted Answer · 2013-12-02 05:40:17Z

0

put the breakpoint in data that in coming from server [your php script] and check it, it coming in right format or not.

answered Dec 2, 2013 at 5:40

community wiki

Pushker Yadav

Collectives™ on Stack Overflow

AJAX (jquery) to run PHP script not working

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related