SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru Raskolnikov's Avatar
    Join Date
    Jul 2003
    Location
    USA
    Posts
    606
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query Status Display

    I know this topic has been beat in to the ground as i have found quite a few treads on it. however they all deal with file download or file upload.

    does anyone have a good way to keep the user entertained a mySql query is being made.

    I have a database that query's rather slow. even just a motion graphic or something while it is loading the page would be nice.

    part of it has to do with my server's amount of RAM. low budgets mean i have to make do with what i got till July. (it is for an intranet - only connected to about 12 other computers)

    any help would be appreciated.

  2. #2
    Umm. PHP Guru....Naaaah jaswinder_rana's Avatar
    Join Date
    Jul 2004
    Location
    canada
    Posts
    3,193
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try this. might be what you looking for
    Goto this website http://www.trafficzap.com/pagerank.php
    and enter any url to search google rank. while its searching for it, it opens a little popup which has a image in it which looks like a progress bar(kind of).

    you can do something like this, in the same way or different way.

    hope this helps
    ---------------------------
    Errors = Improved Programming.
    My Site

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2004
    Location
    Ontario, Canada
    Posts
    99
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That's a great idea jaswinder_rana. Simple yet effective. Another option that I could think of is:

    1) Upon clicking on the link, they are directed to a loading.php page which has a status graphic.

    2) This loading page will make the query and store the results somewhere and, when complete, will redirect to the next page which has the results.

    It's kind of complex so I would recommend using the idea above, but this was just a thought.
    Brock Ferguson
    Lead Developer, Caribou CMS
    A Subscription/Membership CMS and Ecommerce Platform - FREE Trial

  4. #4
    SitePoint Guru Raskolnikov's Avatar
    Join Date
    Jul 2003
    Location
    USA
    Posts
    606
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    jaswinder...

    I like the way that works. However, the loading box never disapeared. THat is something i could probably deal with, but do you know how you would code it to close the window automatically when the page is done loading?

    Thanks

  5. #5
    Umm. PHP Guru....Naaaah jaswinder_rana's Avatar
    Join Date
    Jul 2004
    Location
    canada
    Posts
    3,193
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    now, i am not sure about this. i think they use refence to that window and then when they are done loading (whatever they load), they use that reference and close the window. this question might go in javascript section.
    ---------------------------
    Errors = Improved Programming.
    My Site


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •