PHP - Online Now Script (compare Timestamps)

Hey everyone,

I'm currently working on a friends online script and i have a slight problem that i need help with.

Basically the code first searches "TBL_Friends" to see if you have any friends added. If it returns results it then turns your friends ID's into a variable. It then searches "TBL_Users_Online" to see if any body is logged based on the friend's ID it returned before. The first bit of the code works and it retrieves all the friends i got added. The second half is odd, if i have one or two friends added it will show that one is online. If i have more then three friends added it returns no results. I know my code is a bit sloppy and probably not the best way of writing it, im still learning PHP.

Anyways this is the code, any help is appreciated.

Code: [Select]
<?php
$FriendsOnline = mysql_query("SELECT Sender_ID FROM TBL_User_Friends WHERE Reciever_ID = $UserID");
while($fo=mysql_fetch_array($FriendsOnline))
{
     $FriendsOnlineID = $fo[Sender_ID];

     $FriendsOnlineNumber = mysql_query("SELECT * FROM TBL_Users_Online WHERE User_ID = $FriendsOnlineID");
     $FriendsNumber = mysql_num_rows($FriendsOnlineNumber);

     echo $FriendsNumber;
}
?>
$SenderID = Friends ID
$Reciever_ID = User ID
$UserID = User ID

I've been looking for a simple script that would connect to a game server to see if it is still online. I've found many, but not one of them work. They will permanently send back the text "Online", or "Offline". This is the simplest code I have found:


<?php
$ip = "66.79.190.40"; 
$port = "27960"; 
if (! $sock = @fsockopen($ip, $port, $num, $error, 5)) 
echo '<B><FONT COLOR=red>Offline</b></FONT>'; 
else{ 
echo '<B><FONT COLOR=lime>Online</b></FONT>'; 
fclose($sock); 
} 
?>

I'm also looking into getting it to pull the map name and player-list, but I should be able to figure that out on my own once I get this working. If it helps, this script is supposed to connect to the original Quake games(One, two, and three).

I almost posted this in the freelancing forum, because I am looking for it to be created, but I first needed more info on what a coder would need to know about the project.

I have a script that is designed for a single person, and I want a coder to design it to become an online service with user registration, etc.

I'm weary of posting publicly the details about what the script does, but is something like that needed in order for a php programmer to take on a job? Could something like that be left out, until actually giving the coder the job?

Do I have to give at least a vague idea of what the script does?

I don't understand enough about what a programmer would need to know, but at the same time, I don't want to reveal my idea either.

Can somebody help me on how much I am going to need to reveal?

Thanks.

Hello,

input: I have a timestamp 1309438800 at GMT 1pm (2011-06-30 13:00:00 PM)

output:
how to make this timestamp at 1pm PST?

cheers!

PLEASE NOTE: I did check the PHP manual, although it was a bit too confusing for beginners with timestamps.

I'm creating a simple bank interest system for my PHP game. Say I have a 2% interest in my bank, and I want to run it every 20 minutes. How would I do this? Please provide an example as I'm a bit...too lost. :/

ok so i am using relative timestamps on my forum. if a post was created less than 1 hour ago then it will display something like 32 minutes ago. If it was posted more than 1 hour ago it will display "posted today at 10:00pm", or if it was older than 1 day then it will display the absolute time stamp. My question is how do i get them to update automatically like facebook does? i would like to use jquery for this but after searching i cant make heads or tales of any of it.

so to sumarise i would like the timestamps to update without having to refresh the page.

Thanks

Hi,

I have 2 db fields with timestamp datatype (ClockingInDate and ClockingOutDate) and i am trying to get the difference between them then update the new db called duration with float datatype field.

PHP:

if (isset($_POST["clockout"])){
		
		$result3=mysqli_query($con, "select * from attendance_records where OracleID='$session_id'")or die('Error In Session');
		$row3=mysqli_fetch_array($result3);
		
		$end_date =  $row3['ClockingOutDate'];
		$startdate = $row3['ClockingInDate'];
		$diff = strtotime($end_date) - strtotime($startdate);
		$fullDays    = floor($diff/(60*60*24));
		$fullHours   = floor(($diff-($fullDays*60*60*24))/(60*60));   
		$fullMinutes = floor(($diff-($fullDays*60*60*24)-($fullHours*60*60))/60);  

		$duration = $fullMinutes;
		$query3=mysqli_query($con, "update attendance_records set Duration = '$duration' where OracleID='$session_id' and isdone='$isdone'")or die('Error In Session');
		header('location:index.php');
		
	}

 

* come to think of that again, i always get zero, is it because it never reaches days in my program! I am using this for attendance system so only hours and minutes are used. Please help.

Edited March 13, 2020 by ramiwahdan
thoughts

As you may of guessed, it's a nightmare.
If my birthday is on 10th June GMT, it would still be my birthday on the 11th June in Australian time. Though.. the 11th June, is not my birthday. It's not hard to understand this bit as Australia is like.. many hours ahead. Though when it comes to PHP... if I used some Timezone plug-in then this would bring up the same result as it does now. Though when that persons age is displayed... if my birthday is 10th June at 1AM, in America, it would be the 9th June. There for, they won't see my age change to 18 until it is 10th June their time.

To prevent this, is when calculating the persons age, you would be adding their timezone offset onto their birthday timestamp. So regardless on what day it is around the world, if they are celebrating their birthday... then it's their birthday all around the world even though it's different times.

To do this, i would need timezone offsets. I would have a field in the database I assume. I would convert their DOB to timestamp. I would add their offset onto that timestamp or take it away and display whatever result that gives to every user. This would display their age as whatever to every user.

The next problem is... strtotime works in MM/DD/YYYY, so how do I make it work with DD/MM/YYYY ?

I'm actually not making much sense, how would you work with Timestamps and Ages? Also for my next question question, if I had someones DOB, how do I bring up their next birthday out of it for when I am displaying "Bobs birthday is on the..."

Now for final, apparently on 19th Jan 2038 the UNIX Timestamp will cease to work due to a 32-bit overflow. How can this be true when converting a date in the year 2500 still brings a timestamp?

Why doesn't this code work...

echo '<p>time() = ' . time() . ' seconds</p>';
echo '<p>$lastActivity = ' . $lastActivity . '</p>';
echo '<p>Seconds Active: ' . time() - $lastActivity . ' seconds</p>';

...where $lastActivity comes from my database.


When I run my script I see...
Quote

time() = 1331187131 seconds

$lastActivity = 1331186745
-1331186745 seconds


The last line is dropping the label and there is now Date Math?!


Debbie

Hi,

Hope this is the right place for this...

I have php routines that print itineraries.  For some reason the timestamp (1351378800) returns the same date Sunday 28th October (2012) as the time stamp (1351465200).

$count = 0;
while ($count <= ($nights+1))
              {
              echo date ('l', $startdate1)." (".$startdate1.")";
   echo "<br>";
   echo date ('jS F', $startdate1);
   $startdate1 += 86400;
               
               // more code
              }

Any ideas?

Many thanks,
Peter
 

hi, there.

I have a timestamp in my mysql database called timestamp and it'll record the current timestamp. however it also records the time etc how do i use php to take apart these for example if i wanted to echo the date and time in a different order or if i only wanted to echo the date not the time.

how is this possible?

Thanks for reading.

Ok sorry if this is a proper newbie question but say i have a timestamp saved in a database in a table called "news" and the field is called "date" how do i get the month and year only from example if the time stamp is 2011-03-29 13:57:05.

And i want to list all news articles from the month 03 and the year 2011 how would i go about doing this?


Thank you for reading

Getting the difference in seconds between two timestamps is easy.  Taking the seconds and doing a breakdown of time frames is also easy.
Code: [Select]
<?php

echo '<p>There are a total of ' . round($seconds) . ' seconds between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round($seconds / 60) . ' minutes between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round(($seconds / 60) / 1440) . ' days between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((($seconds / 60) / 1440) / 7) . ' weeks between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((((($seconds / 60) / 1440) / 7) / 30)) . ' months between Timestamp 1 and Timestamp 2.</p>';
echo '<p>The total breakdown of time from Timestamp 1 to Timestamp 2 is .</p>';
?>
What I am trying to figure out, is get a collective amount as well....
X years X months X weeks X days X minutes and X seconds.
Does anyone have any good algorithm for handling that, or have any feedback on where to start to handle this type of math.

Okay guys.

My brain has completely froze and I can't figure out how to do this.

I have one date, that is somewhat static it doesn't change regularly but it changes. Anyway let's say this timestamp is:

2011-07-12 10:30:00

and the current timestamp is

2011-07-13 10:30:00

That's exactly a day difference, which will produce 86400 seconds.

How would I write this in PHP?