What are some alternative solutions to using jQuery/Ajax to check for updates in PHP and MySQL?

Using PHP and MySQL, an alternative solution to using jQuery/Ajax to check for updates is to implement long polling. Long polling involves the client making a request to the server, and the server holding the request open until new data is available or a timeout occurs. This allows for real-time updates without the need for constant polling. 

<?php
// Server-side code for long polling
while(true) {
    $latestData = fetchDataFromDatabase(); // Function to fetch latest data from MySQL
    if($latestData) {
        echo json_encode($latestData);
        break;
    }
    usleep(1000000); // Wait for 1 second before checking again
}
?>

Keywords

PHP MySQL polling long polling WebSockets

Related Questions