How to automatically load images using PHP JSON

I am new to this and I would be grateful if someone can help. The code below I use to pull texts from mysql database and works fine to fetch the data without refreshing the page. What I am trying to do now is do the same for the images stored in the database but they are not displaying.

<?php 

    include_once('db.php');

    $sql = "SELECT * FROM images";
    $res = mysqli_query($conn, $sql);
    $result = array();

    while( $row = mysqli_fetch_array($res) )
        array_push($result, array('image1'  => $row['image1']));

    echo json_encode(array("result" => $result));
    ?>


   

 $(document).ready(function () {
        done();
    });     

    function done() {
        setTimeout(function () {       
            updates();
            done();
        }, 200);
    }

    function update_content() {
      $.getJSON("showImages.php", function (data) {
        $("#Imageslider").empty();
        $.each(data.result, function () {
          $("#Imageslider"").append("<img" +this['image1'] + "/>");
        });
        setTimeout(function () {
          update_content();
        }, 1000);
      });
    }

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Too many functions

In the code below I am assuming that your PHP produces this

{ "result" : [ { "image1":"someurl"},{ "image1":"someurl"}] }

If so, you can do

function update_content() {
  $.getJSON("showImages.php", function(data) {
    $("#Imageslider").html(
      data.result.map(({image1}) => `<img src="${image1}" />`).join("")
    );
    setTimeout(update_content, 3000); // if you want to update the interface every 3 seconds
  })
}
$(function() {
  update_content()
})

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0