database checker

scion

Im still somewhat new with php, but i thought i'd take my chance with making my own tagboard, i want it to refresh on its own, just not every some odd seconds, but everytime there is a post. I believe the way i would have to do this is start a timer and have it check the amount of rows in a database, and if the rows are greater than when last checked, it refreshes the page. Can somone point me in the direction to do that? i don't want the whole thing done, just a boost should do fine (:

Gary_King

It's not possible to have the page refresh once there is a new post. You should use the refresh meta tag instead, to refresh every 30 seconds or so.

This is because, the HTML page is static, and yes, the PHP is dynamic and can check the database, but only if the page refreshes in the first place.

So, in short, no this is not possible, sorry.
As I said, I'd suggest using the refresh meta tag to refresh every few seconds or so.

scion

can't something be done with javascript and php?

Gary_King

I guess there MUST be someway to do this, but in your case, why not just stick with something simple, unless it's for a very professional website or something 🙂

scion

no, for now its to be used as a 'chatboard' maybe in the future i'll do something like hosting them and what not shrug

artic

the only way i can think of is this, but it would time out sooner or later.

<?php

$lastsql = mysql_num_rows($sql);
    for($x=1; $x>0; $x++){
        if(count(mysql_num_rows($sql)) > $lastsql){
           $data = mysql_fetch_array($sql);
           $lastsql = mysql_num_rows($sql);
           echo "<textarea>$data</textarea>";
        }
    }

this is in no way a complete script thats ready to use. but this should give you an idea. i hope im right.

Gary_King

Originally posted by artic
the only way i can think of is this, but it would time out sooner or later.
<?php

$lastsql = mysql_num_rows($sql);
    for($x=1; $x>0; $x++){
        if(count(mysql_num_rows($sql)) > $lastsql){
           $data = mysql_fetch_array($sql);
           $lastsql = mysql_num_rows($sql);
           echo "<textarea>$data</textarea>";
        }
    }
this is in no way a complete script thats ready to use. but this should give you an idea. i hope im right. [/B]

Okay, but it still doesn't achieve the auto-refresh function he wanted, although this is a good start 🙂

scion

yeah, i kinda figured it'd be like that to check the amount of rows in the database and compare it with the last time it was just, my main problem would basically be timers :\

Gary_King

As I said, I think it's best to just preset timers to 30 seconds 🙂