time converter

[auriaks]

Hi, maybe someone can help me with this...
I have
include('db_conn.php');
$queryget = mysql_query("SELECT * FROM reg_users ORDER BY `time` LIMIT 10") or die("Error with query");
while ($row = mysql_fetch_array($queryget))
{
$date = $row['date'];
$time = $row['time'];
$datet = date("Y-m-d");
$timet = date("H:i:s");

time's are saved as you can see: H:i:s (23:10:55)
so, i need to convert $time = $row['time']; and $timet = date("H:i:s"); to seconds... is there an option? THANKS

[Nile]

You can do this two ways (I suggest the second)

#1
(To get seconds

$seconds = explode(':', $timet)[2]; 

#2 (highly suggested)
Instead of saving times as H:i:s, I would save times($row['time']) using the time() function. Then when getting the time as H:i:s you would do:

$time = date("H:i:s", $row['time']);
echo $time; // 23:10:55
$seconds = date("s", $row['time']);
echo $seconds; //55 

Feel free to ask questions.

[auriaks]

what does it means [2] ?? because of that i got an error and i cant open my page

[Nile]

Sorry. :/

$seconds = explode(':', $timet);
$seconds = $seconds[2]; 

[auriaks]

it works, but takes only seconds. I need all time convert to seconds like 2H 5m 32s = 7532 seconds

[auriaks]

what i have to write?

[Nile]

Haha, sorry:

$total_seconds = 0;
$seconds = explode(':', $timet);
$total_seconds += $seconds[0] * (60 * 60);
$total_seconds += $seconds[1] * 60;
$total_seconds += $seconds[2];
echo $total_seconds;

It is not tested!

[auriaks]

Yea, it's working

[auriaks]

Hi,
I faced problem of this function, but don't know where
I use this: [also I update their mysql time in every move]

...

function timeDiff($firstTime,$lastTime) {
 $firstTime=strtotime($firstTime);
 $lastTime=strtotime($lastTime);
 $timeDiff=$lastTime-$firstTime;
 return $timeDiff;
 echo "$timeDiff";
}  

while ($row = mysql_fetch_array($queryget)) 
{ 
    $nick = $row['nick'];    
    $time = $row['time'];
    $timet = date("H:i:s");
    $id = $row['id'];
    
if (timeDiff($time,$timet) <= 300) {
if (timeDiff($time,$timet) >= -1) {
    $var = '1';
    echo "
    $nick user is online
    "; 
}}} 
if ($var < 1) {echo "noone is online";} 

and no users are online ALWAYS.
Thanks

[Nile]

First of all

 return $timeDiff;
 echo "$timeDiff"; 

Onc you return something, the whole function is stopped.

Second of all

if (timeDiff($time,$timet) <= 300) {
if (timeDiff($time,$timet) >= -1) { 

Whats the point of that, just do:

if ((timeDiff($time,$timet) <= 300) AND timeDiff($time,$timet) >= -1) { 

Next,

$var = '1'; 

Even though PHP works with strings as numbers, you may want to do:

$var = 1; 

Instead.

And finally - what problem are you facing?