Retrieving updated information from database (PHP)

Question

Retrieving updated information from database (PHP)

I'm currently working on a piece of code that pulls data from my database. However, I'd like this data to automatically 'refresh' every 5 seconds so that any new entries meeting specific criteria will appear without needing to refresh the entire page.

$sql = "SELECT * FROM items WHERE reference = '1' ORDER BY datePosted asc LIMIT 5";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
      $title = $row["titel"];
      $description = $row["description"];
  }
} else {
    echo "Nothing found";
}

I've been exploring AJAX and PHP methods to achieve this, but haven't quite cracked it yet. Any tips or guidance would be greatly appreciated!

php ajax

Answer 1

Answer №1

You can implement a solution like the following;

<div id='contentToUpdate'></div>

<script type="text/javascript">
    setInterval(function(){
        LoadContent(); // this function will be executed every 5 seconds
    }, 5000);

    function LoadContent(){
        $.ajax({
            type:"POST",
            url: "/path/to/script.php",
            data: {GenerateContent: true, PostName2: 'value2'},
            success: function(result){
                $("#contentToUpdate").html(result);
            },
            error: function(result){
                alert('Something went wrong');
            },
            complete: function(result){
                // This will run regardless of the above
            }
        });
    }
</script>

In the PHP file that handles the Ajax request, you might have something similar to this;


if(isset($_POST['GenerateContent'])){
    $aResults = array();
    $sql = "SELECT title, description FROM items WHERE reference = '1' ORDER BY datePosted asc LIMIT 5";
    $result = $conn->query($sql);
    
    while($row = $result->fetch()){
        $aResults[] = array('title' => $row['title'], 'description' => $row['description']);
    }

    if(!empty($aResults)){
        foreach ($aResults as $iKey => $aResult) {
            echo "<p>";
            echo "Title: ".$aResult['title']."<br>\n";
            echo "Description: ".$aResult['description']."<br>\n";
            echo "</p>";
        }
    }else{
        echo 'No results available';
    }
    exit;
}

Answer 2

You can implement a solution like the following;

<div id='contentToUpdate'></div>

<script type="text/javascript">
    setInterval(function(){
        LoadContent(); // this function will be executed every 5 seconds
    }, 5000);

    function LoadContent(){
        $.ajax({
            type:"POST",
            url: "/path/to/script.php",
            data: {GenerateContent: true, PostName2: 'value2'},
            success: function(result){
                $("#contentToUpdate").html(result);
            },
            error: function(result){
                alert('Something went wrong');
            },
            complete: function(result){
                // This will run regardless of the above
            }
        });
    }
</script>

In the PHP file that handles the Ajax request, you might have something similar to this;


if(isset($_POST['GenerateContent'])){
    $aResults = array();
    $sql = "SELECT title, description FROM items WHERE reference = '1' ORDER BY datePosted asc LIMIT 5";
    $result = $conn->query($sql);
    
    while($row = $result->fetch()){
        $aResults[] = array('title' => $row['title'], 'description' => $row['description']);
    }

    if(!empty($aResults)){
        foreach ($aResults as $iKey => $aResult) {
            echo "<p>";
            echo "Title: ".$aResult['title']."<br>\n";
            echo "Description: ".$aResult['description']."<br>\n";
            echo "</p>";
        }
    }else{
        echo 'No results available';
    }
    exit;
}

Answer 3

Answer №2

Here is a simple example using jQuery to send AJAX requests:

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script>
setInterval(function()
{ 
    $.ajax({
      type:"POST",
      url:"path/to/script.php",
      success:function(data)
      {
          //handle the response data here
      },
      error:function(e){
         console.log("An error occurred");
      }
    });
}, 5000); // Repeat every 5 seconds (5000 milliseconds) 
</script>

Answer 4

Here is a simple example using jQuery to send AJAX requests:

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script>
setInterval(function()
{ 
    $.ajax({
      type:"POST",
      url:"path/to/script.php",
      success:function(data)
      {
          //handle the response data here
      },
      error:function(e){
         console.log("An error occurred");
      }
    });
}, 5000); // Repeat every 5 seconds (5000 milliseconds) 
</script>

Answer 5

Answer №3

Here is an example using jQuery to load data dynamically:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

function loadData(){
    $('#table').load('yourScript.php',function (response, status, xhr) {
         // handle the response and set the data
    });
}

loadData(); // This runs on page load

setInterval(function(){
    loadData(); // This runs every 5 seconds
}, 5000);

Answer 6

Here is an example using jQuery to load data dynamically:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

function loadData(){
    $('#table').load('yourScript.php',function (response, status, xhr) {
         // handle the response and set the data
    });
}

loadData(); // This runs on page load

setInterval(function(){
    loadData(); // This runs every 5 seconds
}, 5000);

Retrieving updated information from database (PHP)

Answer №1

Answer №2

Answer №3

Similar questions

Troubleshooting problem with jQuery autocomplete UI and JSON integration

Retrieving information from an ImmutableMultiDict in Flask

Cleaning up database queries in MySQL without the use of prepared statements (PHP + outdated MySQL module)

Unable to successfully add data into an SQL database using PHP

Alter information within jQuery AJAX success function

What is the process for displaying the identification number in a descending sequence?

Error parsing XML with SAX in PHP: memory exhausted at line x

PHP - mysterious echo `<<<` operator

Make sure to review the requirements listed in a comma-separated format

What is the best way to retrieve these values using PHP?

What is the best way to show a partial based on the variable in the index function of my controller?

Displaying information stored in a database as notifications in the notification icon within the HTML/PHP header

Steps for storing div content (image) on server

Trouble with $http response not appearing in AngularJS application

Receiving NaN in javascript when attempting to calculate the sum using a text input field

Retrieve information from a database by utilizing AJAX and store it in a JavaScript array

What is the best way to print a canvas element once it has been modified?

Issue with Javascript/Jquery functionality within a PHP script

When using form.serialize() in Django forms, an empty object is being sent

What is the best way to send a List in the model as a parameter for an AJAX request?