PHP - Can You Make An Sql Every X Seconds With Php?

Have started to program my own cricket management game and wish to have the database update every 60 seconds; this is to facilitate players who are not watching the actual game.

Games are starting (and finishing) at all times so it is not possible to allow the user to be the only one to activate the game code; it is also not possible to only play the games when the human players are online because other games depend on the results.

The only answer I can think of at the moment is to have a copy of firefox running on the server which runs the PHP code to update all current games and have this page automatically refresh every 60 seconds.  Is this even viable?

Any other suggestions?

James

Hi all,
I have a database with some timestamps (in seconds) in it.
Now I want to reverse it to normal readable time and date formats.
Will someone tell me how please.
Thnx Ryflex

I think I'm seriously missing some small thing to get this code to just auto refresh after (x) seconds or after video completes fully. This is for users to watch from a database of other users that submitted url's - right now all I could put a skip button to auto-refresh. If anyone can help or at least point me into the right direction on some snippets I can kind-of work off of.

here is the snippet (kind-of a big snippet)

Code: [Select]
<?
include('header.php');
foreach($_GET as $key => $value) {
$secure[$key] = filter($value);
}
if($_GET['a'] == "skip"){
$sit1 = mysql_query("SELECT * FROM `youtube` WHERE `id`='{$secure['id']}'");
$sit = mysql_num_rows($sit1);
if($sit > 0){
mysql_query("INSERT INTO `viewed` (user_id, site_id) VALUES('{$data->id}','{$secure['id']}')");
}}
?>
<div class="block medium right">
<div class="top"><?if(isset($data->login)) {?>
                  <h1>Earn Coins - Youtube</h1>
            </div>
<div class="content">

<? // fetches all "unplayed" youtube videos for this user //
  $site2 = mysql_query("SELECT * FROM `youtube` WHERE (`active` = '0' AND `points` >= `cpc`) AND `id` NOT IN (SELECT `site_id` FROM `viewed` WHERE `user_id`='{$data->id}') ORDER BY `cpc` DESC LIMIT 0, 1");
  $site = mysql_fetch_object($site2);
  $ext = mysql_num_rows($site2);
if($ext > 0){
?>
<script src="js/swfobject.js"></script>
<script type="text/javascript">
var playing = false;
var fullyPlayed = false;
var interval = '';
var played = 0;
var length = 30;

function YouTubePlaying(){
played += 0.1;
roundedPlayed = Math.ceil(played);
document.getElementById("played").innerHTML = Math.min(roundedPlayed,length);
if (roundedPlayed == length){
if (fullyPlayed == false){
YouTubePlayed();
fullyPlayed = true;
}
}
}
function YouTubePlayed(){
    var response = '<? echo $site->youtube;?>';
var username = "<? echo $data->id;?>";
    $.post("ytreceive.php",
{  data: response + "---" + username},
function(result){
if(!isNaN(result)) {
var curr_val = $('#points').text();
var new_val = parseInt(curr_val)+parseInt(result);
$('#points').text(new_val);
}
}
);
document.getElementById(response).style.visibility = "visible";
}

function onYouTubePlayerReady(playerId){
ytplayer = document.getElementById("myytplayer");
ytplayer.addEventListener("onStateChange", "onYouTubePlayerStateChange");
}
function onYouTubePlayerStateChange(newState){
if (newState == 1){
playing = true;
interval = window.setInterval('YouTubePlaying()',100);
}else{
if (playing) window.clearInterval(interval);
playing = false;
}
}
  function refreshpage()
   {
      window.location.reload();
   }
</script>
<center>
<div style="width: 520px; padding: 10px;">
<h3>"<? echo $site->title;?>"</h3>
View this video for 30 seconds and after that you will receive <? echo $site->cpc;?> coins<br/><br/>
<div id="ytPlayer">You need Flash player 8+ and JavaScript enabled to view this video.</div>
<script type="text/javascript">
var params = { allowScriptAccess: "always" };
var atts = { id: "myytplayer" };
swfobject.embedSWF("http://www.youtube.com/v/<? echo $site->youtube;?>?enablejsapi=1&playerapiid=ytplayer&autoplay=1", "ytPlayer", "425", "356", "8", null, null, params, atts);
</script>
<br/>

<br />Must play for <span id="played">0</span>/10 seconds (<a href="youtube.php?a=skip&id=<? echo $site->id;?>" style="color:blue">Skip</a>)
<div id="<? echo $site->youtube;?>" style="visibility:hidden"><a href="javascript:refreshpage()">View Next Video</a></div>
</div></center>
<?}else{?>
<div class="msg">
<div class="error">Sorry, there are no more coins to be earned at the moment. Please try again later.</div>
<div class="info"><a href="buy.php"><b>Feel like you need more coins? You can purchase them now!</b></a></div></div>
<?}}else{?><script>document.location.href='index.php'</script><?}?>
</div>
</div>
<?include('footer.php');?>

Hi,

I want to update a row when 30sec are passed on a page. If not nothing happens(not updating row).

Example:
You go to example.php>> 30sec pass, update row>> 30sec not over, no update.

it does not necessarily have to be second it can be minutes or hours.
Who can help me?

Hope its clear enough, Thanks.

Ok Let's say I have a timestamp:

1327482941


I want to convert this to output only "60"

im not looking for a whole time_ago function, simply just need to convert a timestamp down to seconds ONLY not having minutes/years/etc no need none of that just purely seconds starting from 1-60

if so how is it possible?

I tried to just

Code: [Select]
$seconds = substr($e,1,4) . "";
$e is my timestamp, I did this because I could just grab the last 2 digits in the timestamp that would be what I want, but that's not possible because it goes 1-90 not 1-60

^_^ help



Here is a code I am trying to make it only spit out 1-60 in seconds

Code: [Select]
function  timeAgo4($timestamp, $granularity=1){
        $difference = $timestamp;
        if($difference < 0) return '0';
        elseif($difference < 86400){
                   $periods = array(60,'' => 1);
                $output = '';
                foreach($periods as $key => $value){
                        if($difference >= $value){
                                $time = round($difference / $value);
                                $difference %= $value;
                                $output .= ($output ? ' ' : '').$time.' ';
                               
                                $granularity--;
                        }
                        if($granularity == 0) break;
                }
                return ($output ? $output : '0').'';
        }
        else return date($format, $timestamp);
}

Hello,

I'm working on a simple project so bear with me, I have a variable called 'wood' on my SQL database, and I want to somehow increase the 'wood' value (int) every 5 seconds... Even when the user is not currently view that page.

So what I'm thinking is saving the current mktime() to my database once - for sake of argument, this is going to be called 'time_cache', as well as the wood(int) variable.

Then, when the user logs in to see how much wood there is, the PHP will, take the mktime() and subtract the 'cache_time' to see how many seconds have passed... Now I want to increase the wood int by 1 every 5 seconds that have passed.

So I guess I need to do a division such as $seconds_passed = (mktime() - $time_cache) / 5. Which will give me the amount of 5 seconds that have passed, right?

Then, surely my $wood will just equal $seconds_passed?

I'm not sure if this is the best way to do something like this? Any one else have an idea? Also, my wood value doesn't 100% work as it give a decimal... I just want the wood value to increase by 1, every 5 seconds.

I have a client who wants to use an animated GIF as his logo.  It's a pretty cool animation but once the animation stops, the "static" logo isn't very clear.  Is there some way (with either PHP or any way really) to have an image be replaced after a certain amount of time (say 5 seconds) with another image?

In other words, when a page loads, the animated GIF will load first and after 5 seconds of that initial animation, the GIF logo will switch to a much clearer PNG logo file.

Yes, I know I should just learn Flash and recreate the animation in Flash, but I don't have that ability right now

Thanks everyone!

Hi.
I have a query that determines if user is online/offline. Works perfectly when page loads. I want to change to auto run query every X seconds.
NOTES:
- The query is on a .php page with multiple other queries.
-IF it is possible to still run the query with-in this page? or make a separate file and include in an iframe? i would like to avoid the iframe and just $output the result of query every X seconds.

Here is my $query code:

      $query = "SELECT `manager_id` FROM #__profiles_xref WHERE profileid = '$profid'";
      $onofflineid=doSelectSql($query,1);
      foreach ($onofflineid as $isonoffline){
      $profmanagerid=$isonoffline->manager_id;
      }
      
      $query = "SELECT `session_id` FROM table_session WHERE userid = '$propmanagerid'";
      $onofflinestatus=doSelectSql($query,1);
      if (count($onofflinestatus)>0)
         {
         $output['PROPSTATUS']='Online';
      } else {
         $output['PROPSTATUS']='Offline';
         }
   

Hey guys!
I have the following doubt,
I have a Date value and I want to add to that date 30 seconds plus.
Example:

Code: [Select]
$last_time = date('D M j H:i:s \G\M\TO Y'); //echo: Thu Mar 10 18:33:48 GMT-0300 2011

I need the following date: Thu Mar 10 18:33:48 GMT-0300 2011 to become:
Thu Mar 10 18:34:18 GMT-0300 2011
This means that the retrieved Date now has 30 more seconds...

Any ideas??
Looking forward to any help,

Thanks a lot in advance,
Cheers!

Hello!   I am trying to display content that will only be displayed for 30 seconds to each visitor. I want to have a  unique ID given to each user that visits my page and also add that assigned ID to the end of the URL.  If the page is loaded again after 30 seconds, I want the unique user ID to redirect using header();    So When a suer visits my page, I want the end of the url to have “userid=“ like this: 

http://example.com/page.php?userid=0000000001

If that user comes back to the same url after 30 seconds, I want to redirect using header();   How do I do this? what is the best way?
Edited by supertooper, 01 September 2014 - 10:41 PM.

Hi,

I have some queries that update some statistics in a table I have. I need these queries to run only after 15 seconds have passed however. This way if the user leaves before the 15 seconds, the queries won't run. I've tried using Sleep, however it seems to just stop all the code all together for the allotted time. There must be a way to do this.

Hi All,

When a user saves the page, I want to have the page refresh to show the new record and then have a message saying "Success!" or something like that.

The only way I know how to do this is to set a session var after the record is created, but I would then need to unset it automatically so it doesn't keep showing.

Any suggestions?

Does anyone know why this isn't working?


$body = "
Dear ".if ($row['customertitle'] != '') {echo $row['customertitle'].' '.$row['customerlastname'];} else (echo $row['customerfirstname'];}."
<BR>
This is a test. ".$_SERVER['SERVER_ADDR']."
<BR>
".echo $accessinformation."
";

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=343671.0

I wrote a function that grabs the elapsed time of a recently uploaded video. However, the time does not seem to increment. For example, if I upload a video, the time will display as '1 second'.

However, if I continuously refresh the page, the time does not increment or increase. Any way to fix this? I figured I'd have to put it in some kind of loop (I do call the function in another class).

 

function getElapsedTime($time) {
	
	$time = time() - $time; // get time since video upload date
	$time = ($time < 1) ? 1 : $time;
	$tokens = array(
	    31536000 => 'year',
	    2592000  => 'month',
	    604800   => 'week',
	    86400    => 'day',
	    3600     => 'hour',
	    60       => 'minute',
	    1        => 'second'
	);
	
	foreach ($tokens as $unit => $text) {
	    if ($time < $unit) continue;
	    $numberOfUnits = floor($time / $unit);
	    return $numberOfUnits . ' ' . $text . (($numberOfUnits > 1) ? 's' : '');
    }
}