Display Queries On Success

saint4

I'm building an installer and in one of the steps that creates the tables and the step after which inserts the data. What i would like is, as its running a query it says so and then once successful starts the next query but also states its doing so.

Example;

[start 1st query]
Creating members table... OK[its done, now next query]
[start 2nd query]
Creating contact table... OK[done, next query & so forth]

If it then fails to do a query it would say so

Creating sessions table... Failed

I dont want the page to load and then the queries are listed as ok. i want it to display dynamically when each query is being done.

Can someone point me in the right direction, thanks.

atokatim

try something like this :

Starting query 1 :
<?
if(mysql_query("YOUR_QUERY")) {
  echo "Done.";
} else {
  echo "Failed!";
}
?>
<br>
Starting query 2 :
<?
if(mysql_query("YOUR_QUERY")) {
  echo "Done.";
} else {
  echo "Failed!";
}
?>

hope that is what you are asking for 😃

saint4

I didn't think it would be as simple as that.

I would have thought that once the page loaded with what you gave as an example it would just do it all at the same time. So all the creating table_name wouldn't load one after the after but all at the same time which isn't what i'm looking for.

If you could clarify which one it would do.

1) one after the after.
2) all at the same time.

I'll also want it to stop if a query failed.

atokatim

The page will not load all at once unless the queries are completed within a split second. The "Starting query 1 :" will show on the page first before the query is executed. once the query is complete, it will show the result...either "Done" or "Failed". if the query fails, i added the exit; command to make it stop the entire script. If it is a success, it will then begin with the next sequence and then show "Starting query 2 :"

Updated code:

Starting query 1 :
<?
if(mysql_query("YOUR_QUERY")) {
  echo "Done.";
} else {
  echo "Failed!";
  exit;  //  This will make the script stop if the query fails
}
?>
<br>
Starting query 2 :
<?
if(mysql_query("YOUR_QUERY")) {
  echo "Done.";
} else {
  echo "Failed!";
  exit;  //  This will make the script stop if the query fails
}
?>

saint4

What you gave doesn't do what i want.

The Page loads the first thing you see is

Creating Table admins...

Second later it shows

Creating Table admins... OK

Now the screen shows

Creating Table admins... OK
Creating Table members...

and so forth

leatherback

Saint: What do you want? You want to stop between each step in the process? If so.. Why do you want things to process SLOWER than possible?

If you see all appearing in one flash, that means that all is processed much more quickly than your connections can handle: All the output is displayed in one go.

Sxooter

you probably need the flush() command in there.

You might also need to turn off output buffering