Before div after query

Question

I have a form and its action triggers the loading of data from a table. I want the action to return and display a loading gif while the query is still running.

php:

if(isset($_POST['button']))
{
    echo '<div id="loading"></div>';
    for($x=0; $x<10000; $x++)
    {
        $conn->query("SELECT * FROM table");
    }

}

html:

My current code doesn't show the loading gif until the query has already run.

You miss some basics here: PHP is first process by your server, then the result is sent to your browser when all your script is processed. You need to check on AJAX for what you want to do. — vard
– vard, Commented May 18, 2015 at 13:19
What about outputting the page then populating the page with the data via AJAX? learn.jquery.com/ajax — chris85
– chris85, Commented May 18, 2015 at 13:19
You need AJAX to do this kind of stuff. learn JavaScript and jQuery. In your JavaScript code, hide the loader at the beginning. then only show it when you make an AJAX request to the server. — Akar
– Akar, Commented May 18, 2015 at 13:27

Community · Accepted Answer · 2017-05-23 11:58:09Z

0

In order for you to display a loading image in the browser while your SQL query is running, you need to separate the displaying of the loading image from executing the query. The way you have it right now, php will not return your loading '' until the query completes.

The simplest way is for the loading to be initiated via javascript, which would inject the loading image into your html and fire off an AJAX request to the server. Then when the AJAX call returns the data, the receiving javascript callback would replace the loading image with your data.

Some similar questions that can get you on your way:

Load data from database + ajax + php

Loading data from database with php and pure ajax in a textbox

How to show ajax loading gif animation while the page is loading?

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered May 20, 2015 at 22:43

Arne Claassen

14.5k5 gold badges71 silver badges109 bronze badges

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

Collectives™ on Stack Overflow

Before div after query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related