Date_time naar Vandaag

Gestart doorMarv31 mei 201224 reacties36 weergaven

25 berichten · pagina 1 van 2

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 18:46

Heleu,

Naar aanleiding van mijn vorige topic over datetime, had ik er nog een vraag over.

Ik gebruik het nu altijd zo:

DATE_FORMAT(datum, %d %M %Y, om %H:%i) AS datum

En dan krijg ik mooi altijd:

19 Februari 2012, om 18:45

Maar als die tijd nu vandaag is of gister, dan zou ik het graag zo willen:

Vandaag, om 18:45

of Gister:

Gisteren, om 18:45

En voor de rest van de dagen gewoon:

19 Februari 2012, om 18:45

Zoja, Hoe doe ik dit?

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

31 mei 2012, 18:51

strtotime()

http://php.net/manual/en/function.strtotime.php

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 18:53

Sevvlor schreef:
strtotime()

http://php.net/manual/en/function.strtotime.php

en dat werkt op manier...... ?

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

31 mei 2012, 18:55

Marvinguich schreef:
Eerdere citaten tonen
Sevvlor schreef:
strtotime()
http://php.net/manual/en/function.strtotime.php

en dat werkt op manier...... ?

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"now"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"10 September 2000"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 day"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 week"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 week 2 days 4 hours 2 seconds"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"next Thursday"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"last Monday"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
?>

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 18:59

Sevvlor schreef:

Eerdere citaten tonen

Marvinguich schreef:
Eerdere citaten tonen
Sevvlor schreef:
strtotime()
http://php.net/manual/en/function.strtotime.php

en dat werkt op manier...... ?

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"now"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"10 September 2000"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 day"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 week"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"+1 week 2 days 4 hours 2 seconds"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"next Thursday"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"last Monday"[/COLOR][COLOR= #007700]),[/COLOR] [COLOR= #DD0000]"n"[/COLOR][COLOR= #007700];[/COLOR]
?>

mooi dat 10 september etc. maar ik heb nog geen antwoord op mijn vraag hoe ik Vandaag tevoorschijn haal.

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

31 mei 2012, 19:00

Dat is van een relatieve datum/bepaalde string naar een UNIX timestamp.
Niks wat de TS zoekt.

Ik heb een leuke SQL gevonden:

SELECT date_field, IF (DATEDIFF( NOW(), date_field) < 1, IF ( TIMEDIFF( NOW(), date_field ) < 01:00:00, CONCAT(MINUTE(TIMEDIFF(NOW(), date_field)),  minutes), CONCAT(HOUR(TIMEDIFF(NOW(), date_field )),  hours)), date_field) AS occurred

Via PHP, kan het ook:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// verleden[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"geleden"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]// toekomst[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"te gaan"[/COLOR][COLOR= #007700];
    }[/COLOR]       
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]].=[/COLOR] [COLOR= #DD0000]"s"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$ending[/COLOR]"[COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Vergeet niet even je timestamp te voeren aan strtotime(), waarna je de timestamp in de RelativeTime() functie kan stoppen.

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 19:02

Aarclay schreef:
Dat is van een relatieve datum/bepaalde string naar een UNIX timestamp.
Niks wat de TS zoekt.

Ik heb een leuke SQL gevonden:
SELECT date_field, IF (DATEDIFF( NOW(), date_field) < 1, IF ( TIMEDIFF( NOW(), date_field ) < 01:00:00, CONCAT(MINUTE(TIMEDIFF(NOW(), date_field)),  minutes), CONCAT(HOUR(TIMEDIFF(NOW(), date_field )),  hours)), date_field) AS occurred

Via PHP, kan het ook:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// this was in the past[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"ago"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]// this was in the future[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"to go"[/COLOR][COLOR= #007700];
    }[/COLOR]       
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]].=[/COLOR] [COLOR= #DD0000]"s"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"$difference $periods[$j] $ending"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Vergeet niet even je timestamp te voeren aan strtotime(), waarna je de timestamp in de RelativeTime() functie kan stoppen.

Die SQL is makkelijker ofniet?

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

31 mei 2012, 19:03

Zat te slapen, sorry daar voor.

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

31 mei 2012, 19:04

Marvinguich schreef:

Eerdere citaten tonen

Aarclay schreef:
Dat is van een relatieve datum/bepaalde string naar een UNIX timestamp.

Niks wat de TS zoekt.

Ik heb een leuke SQL gevonden:

SELECT date_field, IF (DATEDIFF( NOW(), date_field) < 1, IF ( TIMEDIFF( NOW(), date_field ) < 01:00:00, CONCAT(MINUTE(TIMEDIFF(NOW(), date_field)),  minutes), CONCAT(HOUR(TIMEDIFF(NOW(), date_field )),  hours)), date_field) AS occurred

Via PHP, kan het ook:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// this was in the past[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"ago"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]// this was in the future[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"to go"[/COLOR][COLOR= #007700];
    }[/COLOR]       
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]].=[/COLOR] [COLOR= #DD0000]"s"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"$difference $periods[$j] $ending"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Vergeet niet even je timestamp te voeren aan strtotime(), waarna je de timestamp in de RelativeTime() functie kan stoppen.

Die SQL is makkelijker ofniet?

Het is waar je van houdt....

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 19:05

#10

Aarclay schreef:

Eerdere citaten tonen

Marvinguich schreef:

Eerdere citaten tonen

Aarclay schreef:
Dat is van een relatieve datum/bepaalde string naar een UNIX timestamp.

Niks wat de TS zoekt.

Ik heb een leuke SQL gevonden:

SELECT date_field, IF (DATEDIFF( NOW(), date_field) < 1, IF ( TIMEDIFF( NOW(), date_field ) < 01:00:00, CONCAT(MINUTE(TIMEDIFF(NOW(), date_field)),  minutes), CONCAT(HOUR(TIMEDIFF(NOW(), date_field )),  hours)), date_field) AS occurred

Via PHP, kan het ook:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// this was in the past[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"ago"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]// this was in the future[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"to go"[/COLOR][COLOR= #007700];
    }[/COLOR]       
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]].=[/COLOR] [COLOR= #DD0000]"s"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"$difference $periods[$j] $ending"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Vergeet niet even je timestamp te voeren aan strtotime(), waarna je de timestamp in de RelativeTime() functie kan stoppen.

Die SQL is makkelijker ofniet?

Het is waar je van houdt....

maar met die sql, date_field is mijn datetimeveld? en vandaag etc haalt hij automatisch op?

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

31 mei 2012, 19:06

#11

Jep, try and see

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 19:09

#12

Aarclay schreef:
Jep, try and see

ik krijg nu te zien 1 hours .. dus werkt niet

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

31 mei 2012, 19:35

#13

Als je het met PHP op wilt lossen:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$periods_full[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dagen"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"weken"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maanden"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]

    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// verleden[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"geweest"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]//toekomst[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"te gaan"[/COLOR][COLOR= #007700];
    }[/COLOR]      
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]

    [COLOR= #0000BB]$period[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]] :[/COLOR]  [COLOR= #0000BB]$periods_full[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$period[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ending[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Jvdw

Lid

Berichten: 4.321
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 13 sep 2025

31 mei 2012, 19:40

#14

En dit?

[COLOR= #0000BB]<?php
$days_old[/COLOR] [COLOR= #007700]= ([/COLOR]current_time[COLOR= #007700]([/COLOR]timestamp[COLOR= #007700]) -[/COLOR] get_the_time[COLOR= #007700]([/COLOR][COLOR= #DD0000]U[/COLOR][COLOR= #007700]) - ([/COLOR]get_settings[COLOR= #007700]([/COLOR][COLOR= #DD0000]gmt_offset[/COLOR][COLOR= #007700]) *[/COLOR][COLOR= #0000BB]3600[/COLOR] [COLOR= #007700]) )[/COLOR] / [COLOR= #007700]([/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]24[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]<=[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Today[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&[/COLOR] [COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Yesterday[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
  the_time[COLOR= #007700]([/COLOR][COLOR= #DD0000]F jS, Y[/COLOR][COLOR= #007700]);
}[/COLOR]
?>

Marv

Lid · Topicstarter

Berichten: 3.092
Reputatie: 1
Punten: 0,21

Lid sinds: 2009
Laatst gezien: 8 jul 2025

31 mei 2012, 20:40

#15

Jvdw schreef:

En dit?

[COLOR= #0000BB]<?php
$days_old[/COLOR] [COLOR= #007700]= ([/COLOR]current_time[COLOR= #007700]([/COLOR]timestamp[COLOR= #007700]) -[/COLOR] get_the_time[COLOR= #007700]([/COLOR][COLOR= #DD0000]U[/COLOR][COLOR= #007700]) - ([/COLOR]get_settings[COLOR= #007700]([/COLOR][COLOR= #DD0000]gmt_offset[/COLOR][COLOR= #007700]) *[/COLOR][COLOR= #0000BB]3600[/COLOR] [COLOR= #007700]) )[/COLOR] / [COLOR= #007700]([/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]24[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]<=[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Today[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&[/COLOR] [COLOR= #0000BB]$days_old[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Yesterday[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
  the_time[COLOR= #007700]([/COLOR][COLOR= #DD0000]F jS, Y[/COLOR][COLOR= #007700]);
}[/COLOR]
?>

Waar moet ik NOW() neer drukken dan?

Aarclay schreef:
Als je het met PHP op wilt lossen:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] RelativeTime[COLOR= #007700]([/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() -[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$periods[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dag"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"week"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maand"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$periods_full[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"sec"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"min"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"uur"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"dagen"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"weken"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"maanden"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"jaar"[/COLOR][COLOR= #007700]);[/COLOR]

    [COLOR= #0000BB]$lengths[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"60"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"24"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"7"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"4.35"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]"12"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR] [COLOR= #FF8000]// verleden[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"geweest"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR] [COLOR= #FF8000]//toekomst[/COLOR]
        [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]= -[/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$ending[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"te gaan"[/COLOR][COLOR= #007700];
    }[/COLOR]      
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++)[/COLOR] [COLOR= #0000BB]$difference[/COLOR] /[COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$lengths[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$difference[/COLOR][COLOR= #007700]);[/COLOR]

    [COLOR= #0000BB]$period[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$difference[/COLOR] [COLOR= #007700]==[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$periods[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]] :[/COLOR]  [COLOR= #0000BB]$periods_full[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$text[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$difference[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$period[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ending[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$text[/COLOR][COLOR= #007700];
}[/COLOR]
?>

hier snap ik helemaal niks van. 1 dag te gaan...?

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.