Hoe roep je de functie aan?
Date_time naar Vandaag
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// Komt uit Whear script[/COLOR]
[COLOR= #007700]function[/COLOR] datenl[COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]=-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Onbekend"[/COLOR][COLOR= #007700]; }[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]==-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700](); }[/COLOR]
[COLOR= #0000BB]$datefrom[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/switch"]switch[/URL][COLOR= #007700]([/COLOR]true[COLOR= #007700])
{
case([/COLOR][COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nu[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-5 seconds[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nu[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 min[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] seconde geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] seconden geleden[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]zonet[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 hour[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] / [COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] minuut geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] minuten geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 day[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] / [COLOR= #0000BB]60[/COLOR] / [COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] uur geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] uren geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 week[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$day_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] day[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700]++;
}[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]Gisteren[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] dagen geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 month[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$week_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] week[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700]++;
}[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]laatste week[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] weken geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$months_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] month[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700]++;
}[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] maand geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] maanden geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$year_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700]++;
}[/COLOR]
[COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] jaar geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] jaar geleden[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$res[/COLOR][COLOR= #007700];
}[/COLOR]
?> Werkt op zowat elke datum.
echo datenl(timestamp);
Aarclay schreef:Hoe roep je de functie aan?
$MijnKliksFetch[occurred] Antonn schreef:Werkt op zowat elke datum.[COLOR= #0000BB]<?php[/COLOR] [COLOR= #FF8000]// Komt uit Whear script[/COLOR] [COLOR= #007700]function[/COLOR] datenl[COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]=-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Onbekend"[/COLOR][COLOR= #007700]; }[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]==-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700](); }[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/switch"]switch[/URL][COLOR= #007700]([/COLOR]true[COLOR= #007700]) { case([/COLOR][COLOR= #0000BB]$dateto[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nu[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-5 seconds[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nu[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 min[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] seconde geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] seconden geleden[/COLOR][COLOR= #007700]; }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]zonet[/COLOR][COLOR= #007700]; }[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 hour[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] / [COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] minuut geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] minuten geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 day[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] / [COLOR= #0000BB]60[/COLOR] / [COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] uur geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] uren geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 week[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$day_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] day[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700]++; }[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$day_difference[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]Gisteren[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] dagen geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 month[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$week_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] week[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700]++; }[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$week_difference[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]laatste week[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] weken geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$months_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] month[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700]++; }[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$months_difference[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] maand geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] maanden geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; case([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-1 year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]):[/COLOR] [COLOR= #0000BB]$year_difference[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] year[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dateto[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]$datefrom[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700]++; }[/COLOR] [COLOR= #0000BB]$datediff[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$year_difference[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] jaar geleden[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$datediff[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] jaar geleden[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/break"]break[/URL][COLOR= #007700]; }[/COLOR] [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$res[/COLOR][COLOR= #007700]; }[/COLOR] ?>
echo datenl(timestamp);
Als je mn startpost leest, wil ik alleen Vandaag, om 17:45 en Gisteren, om 17:45 voor de rest gewoon 12 Februari 2012, om 17:45....
Marvinguich schreef:En je snapt ook dat ik wil weten wat er in die variabele zit?Eerdere citaten tonen
Aarclay schreef:Hoe roep je de functie aan?$MijnKliksFetch[occurred]
Aarclay schreef:En je snapt ook dat ik wil weten wat er in die variabele zit?Eerdere citaten tonen
Marvinguich schreef:Eerdere citaten tonen
Aarclay schreef:Hoe roep je de functie aan?$MijnKliksFetch[occurred]
$MijnKliks = $mysql->query("SELECT gekeurt,IF (DATEDIFF( NOW(), datum) < 1, IF ( TIMEDIFF( NOW(), datum ) < 01:00:00, CONCAT(MINUTE(TIMEDIFF(NOW(), datum)), minutes), CONCAT(HOUR(TIMEDIFF(NOW(), datum )), hours)), datum) AS occurred FROM adv_doeads_kliks WHERE doead = " . $_GET[bekijk] . " AND ipadres = ".$_SERVER[REMOTE_ADDR].""); Huh??????
Lees mijn vraag nog eens?
En trouwens, het waren twee mogelijk oplossing, geen bijelkaar horende oplossingen.
Dus gooit een unix-timestamp door mijn functie heen, en zie....
Lees mijn vraag nog eens?
En trouwens, het waren twee mogelijk oplossing, geen bijelkaar horende oplossingen.
Dus gooit een unix-timestamp door mijn functie heen, en zie....
Aarclay schreef:Een DATETIME veld, als jij nou eens mijn beginpost leest, zie je ook DATETIME staan.Huh??????
Lees mijn vraag nog eens?
En trouwens, het waren twee mogelijk oplossing, geen bijelkaar horende oplossingen.
Dus gooit een unix-timestamp door mijn functie heen, en zie....
maar er wordt een unix timestamp verwacht voor die functie.
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp
Aarclay schreef:ik vraag om iets met datetime, al mijn datums staan erin en met de eerste functie die ik altijd gebruikte werkte dat altijd goed.maar er wordt een unix timestamp verwacht voor die functie.
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp
Je kan in je SELECT query je DATETIME toch herschrijven naar een UNIXtimestamp?
Kleine moeite en je kan direct de functie toepassen....
Je hoeft echt niet je hele database op de schop te gooien, als je dat denkt.
strtotime() kan je ook in die functie implementeren als je dat liever hebt.
Kleine moeite en je kan direct de functie toepassen....
Je hoeft echt niet je hele database op de schop te gooien, als je dat denkt.
strtotime() kan je ook in die functie implementeren als je dat liever hebt.