PHP - How To Show How Many Minutes Are Left In The Current Hour

Hi guys

Just wanted to knw whats the php logic needed to create this function which shows current users viewing a topic

I knw we can have a database table which stores the topic ID as well as user id and that way we can record who is viewing a topic but what happens when they leave?

some users can just close there browser in which case I would never know when they left?


thank you guys

Hi,

I have a problem. i want to show the current date and time in my tables of the database. I want to show it because i want to show it on my report generated in php.

By the way i do not have a "date" field in my form. Can anyone help me out?

Thanks,
Heshan.

show list of files uploaded by current session user to the database. I want to show different users when they log in to the website...they can see a list of old files that they have uploaded. can anyone tell me the code/script to this.....please, ty

Hello

I have a timestamp formated as : "2011-10-20 12:37:21"

I need to show days left till this date (disregard the hours, minutes, seconds..), so I'll end up with 'there is "X" days left untill'

I really cannot figure you all this date/time stuff, but hopefully this is not to difficult 

Anyone got a "quick" code for this?

    

i get this error Warning: current() [function.current]: Passed variable is not an array or object..

for this
Code: [Select]
$lastblock = current( ${"s".$row} );
print_r($lastblock);
when i change to this it works..
Code: [Select]
$lastblock = current( $s0 );
print_r($lastblock);
The problem is i won't know the $row seeing as it is in a while loop.  Solution?

Hello - I've come to an issue with something I'm working on and have searched around with no luck.

When editing user accounts I want it to not be able to change the e-mail address into existing ones on other rows, but when submitting the form it takes into account that this particular rows email address is the same as the one which was sent via $_POST and throws up the error.

The desired behaviour I want is for it to ignore the ID of the row which was posted, but take into account every other row.

Here's the code as it stands at the moment:

$email = $_POST['email'];
        $checkemail = mysql_query("SELECT email FROM users WHERE email='$email'");

} if (mysql_num_rows($checkemail) > 0) {

return $this->error("The e-mail address you provided is already associated with an account.");
}

Hi,

I'm wanting to find rows whose date is within the next week of the current month of the current year. The format of the date is, for example: 2010-10-28

Any ideas guys?

Thanks lots!

To get current date and time I use:

$date = date("d-M-Y h:i:s");

But how can I get date and time which was before 5 minutes.

Hi i have this drop down list current the year is 2010 and downwards but i want to change the list to 2010 upwards u can notice on the 50-- so shows current year minus so current is 2010 to 61 how can i change 2010 to 2030 or sunfin??

echo '<select name="year_of_birth">',"\n";
    $year = date("Y");
    for ($i = $year;$i > $year-50;$i--) {
      if($i == $thisYear) { 
        $s = ' selected'; 
      } else { 
        $s='';
      }
      echo '<option value="' ,$i, '"',$s,'>' ,$i, '</option>',"\n";
    }
  echo '</select>',"\n";

I have a database with Users as a table. It has the normal stuff, id, username, password, and I have anther in it called lastactive. It is int(11) , and I am wondering how I would make a sql query select the users in the database 'users' and see who has been active in the past 15 mins.

By the way, the lastactive time gets updated by the function time()

Here is my code:

<?php
$online = mysql_query("SELECT * from users WHERE (TIMESTAMPDIFF(MINUTE, `lastactive`, NOW()) < 15) ORDER by lastactive DESC") or die (mysql_error());
while($online = mysql_fetch_assoc($online)) {
echo '<a style="color:#F0CD87;" href="profile?id='.$online['user_id'].'">';
echo ucFirst($online['username']);
echo '</a>, ';
}
?>


Here is how the last active gets updated.

<?php
if(isset($_SESSION['logged'])) {
mysql_query("UPDATE `users` SET `lastactive`='" . time() . "' WHERE `username`='" . $_SESSION['username'] . "'");
}
?>


Again its not showing the users that have been on since 15 minutes ago, even tho it updates the users last active on every page since its in the footer.php part. which is on every page.

Thanks for the upcoming help.

I'm trying to add some minutes ($interval) to any given time, but my results aren't as expected...

Code: [Select]
<?php
$year="2012";
$opentime="09";
$interval="10";
$thedate = "$year:01:01 $opentime:00:00";
$startdate = strtotime($thedate);

$date = date("Y-m-d",$startdate);
$time = date("g:i a",$startdate);

$newtime = strtotime("+$interval", $time);
$nexttime = date("g:i a",$newtime);

echo $date;
echo "<br>";
echo $time;
echo "<br>";
echo $nexttime;
is returning:
2012-01-01
9:00 am
7:10 pm

I was expecting the last to be 9:10 am.
Can someone point me in the right direction? Thanks.

I have a forum script I made that has thread bumping for the thread creator only. I am trying to limit the amout of time the creator can bump to be every 10 minutes.

Here's my code.

list($title, $creator, $locked, $hidden, $moved, $lastbump) = mysql_fetch_row(mysql_query('SELECT title, creator, locked, hidden, moved, lastbump FROM forum_threads WHERE id="'.$_GET['threadid'].'"'));

if(($locked == 1 || $hidden == 1 || $moved == 1) && !$_SESSION['rights'] == 2){

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

} else {

if($creator == $_SESSION['username']){

mysql_query("UPDATE forum_threads SET lastbump = NOW() WHERE id='".$_GET['threadid']."'");

} else {

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

}

}

I've created a demo page for my CMS, and I want to delete itself and make a fresh content install.

I got the delete part figured out, but what about uploading fresh content files? (only a few text files).

Here's the delete part:

Code: [Select]
<?php
$expiretime=720; // minutes (in how many minutes it deletes the files)

$tmpFolder="tmp/"; // where to delete the files - be careful with this.
$fileTypes="*.*";

foreach (glob($tmpFolder . $fileTypes) as $Filename) {

$FileCreationTime = filectime($Filename);
$FileAge = time() - $FileCreationTime; 

if ($FileAge > ($expiretime * 60)){

//deleting files:
unlink($Filename);
}

}
?>

hello, if i have the following, how would i display it?

Code: [Select]
function minutes_round ($hour = "$signintime", $minutes = '5', $format = "H:i")
{
    $seconds = strtotime($hour);
    $rounded = round($seconds / ($minutes * 60)) * ($minutes * 60);
    return date($format, $rounded);
}