laatste reactie

He ,

ik heb dus een database gemaakt waar de gebruikers via datatime geupdate worden en dan komt het er zo in : 2012-02-02 19:28:34

en het word er zo uitgehaald :

$leden = mysql::query("SELECT * FROM leden WHERE tijd_bezocht > (NOW() - INTERVAL 5 MINUTE)")or die(mysql_error());

heeft alleen iemand een idee hoe ik bijvoorbeeld zou kunnen zeggen :

gebruikersnaam Laatste reactie
smiegles 2 minuten 13 seconde

mvg ,

Smiegles

In whear systeem staat in de index.php de datenl function, altijd handig.

[COLOR= #0000BB]<?php
$date[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"2012-02-02 19:28:34"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]60[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$min[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR]/[COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$sec[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$date[/COLOR][COLOR= #007700]-([/COLOR][COLOR= #0000BB]$min[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$min[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" minuten "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$sec[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" seconde"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$sec[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$date[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$sec[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" seconde"[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Eleky schreef:

[COLOR= #0000BB]<?php
$date[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"2012-02-02 19:28:34"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]60[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$min[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR]/[COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$sec[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$date[/COLOR][COLOR= #007700]-([/COLOR][COLOR= #0000BB]$min[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$min[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" minuten "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$sec[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" seconde"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$sec[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$date[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$sec[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" seconde"[/COLOR][COLOR= #007700];
}[/COLOR]
?>

het is seconden

Good For You