i love strtotime but it is no use in New Zealand

[windandwaves]

Hi Folk

I love the strtotime function, because I can make a date field in a form and
just tell my users to enter whatever they want and as long as it is a date,
it will work.

HOWEVER, this obviously does not work for the day/month vs month/day
scenario. That is, in New Zealand we use day/month/year, while the function
assumes it to be month/day/year.

Does anyone have a simple function that helps me close that loophole (I am
using PHP 4.4).

I copied the function below from php.net, but I dont think it will work in
all cases.

Cheers
[color=blue]
> Nicolaas[/color]
# Returns a timestamp from a string based on the given format and default
timezone if it's ambiguous.
# %Y - year as a decimal number including the century
# %m - month as a decimal number (range 01 to 12)
# %d - day of the month as a decimal number (range 01 to 31)
# %H - hour as a decimal number using a 24-hour clock (range 00 to 23)
# %M - minute as a decimal number

function parseDate( $date, $format = "%d/%m/%Y") {
// Builds up date pattern from the given $format, keeping delimiters in
place.
if( !preg_match_all ( "/%([YmdHMp])([^%])*/", $format, $formatTokens,
PREG_SET_ORDER ) ) {
return false;
}
foreach( $formatTokens as $formatToken ) {
$delimiter = preg_quote( $formatToken[2], "/" );
$datePattern .= "(.*)".$delimit er;
}

// Splits up the given $date
if( !preg_match( "/".$datePattern. "/", $date, $dateTokens) ) {
return false;
}
$dateSegments = array();
for($i = 0; $i < count($formatTo kens); $i++) {
$dateSegments[$formatTokens[$i][1]] = $dateTokens[$i+1];
}

// Reformats the given $date into US English date format, suitable for
strtotime()
if( $dateSegments["Y"] && $dateSegments["m"] && $dateSegments["d"] ) {
$dateReformated =
$dateSegments["Y"]."-".$dateSegm ents["m"]."-".$dateSegm ents["d"];
}
else {
return false;
}
if( $dateSegments["H"] && $dateSegments["M"] ) {
$dateReformated .= " ".$dateSegm ents["H"].":".$dateSegme nts["M"];
}

return strtotime( $dateReformated );
}

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

windandwaves wrote:
it could probably be as simple as writing a regular expression that changes
around anything like
11/12/2006 to 12/11/2006
and
11-12-2006 to 12-11-2006
and
27-05-2006 to 05-27-2006
but leaves
05-30-2006, because 30 > 12 and therefore is the day in the right place.

TIA
[color=blue]
> Nicolaas[/color]

[lifesizeandrew@gmail.com]

Re: i love strtotime but it is no use in New Zealand


windandwaves wrote:[color=blue]
> windandwaves wrote:
> it could probably be as simple as writing a regular expression that changes
> around anything like
> 11/12/2006 to 12/11/2006
> and
> 11-12-2006 to 12-11-2006
> and
> 27-05-2006 to 05-27-2006
> but leaves
> 05-30-2006, because 30 > 12 and therefore is the day in the right place.
>
> TIA
>[color=green]
> > Nicolaas[/color][/color]

There is no real way of knowing if someone ment Dec. or Nov. if they
enter 12/11/2006. I think your solution lies in providing seperate form
fields for day month and year, OR providing a key that says the desired
format (dd/mm/yyyy)

-Andy

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

windandwaves wrote:
This is what I came up with:

function eurostrtotime($ d) {
// regular expression version
if
(preg_match('!( 0[1-9]|[1-2]{1}[0-9]{1}|3[0-1]{1})/(0[1-9]{1}|1[0-2]{1})/(19[0-9]{1}[0-9]{1}|200[0-9]{1})!',
$d, $matches)) {
list(,$d,$m,$y) = $matches;
$ts = mktime(0,0,0,$m ,$d,$y);
}
else {
$ts = strtotime($d);
}
return $ts;
}


Can anyone tell me how to include other formats in the regular expression.

Right now, it picks up 27/05/2006, but I would like it to include 27/05/06
and the like.

TIA
[color=blue]
> Nicolaas[/color]

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

lifesizeandrew@ gmail.com wrote:
....[color=blue]
> There is no real way of knowing if someone ment Dec. or Nov. if they
> enter 12/11/2006.[/color]
....

There is, because all users are from New Zealand and in New Zealand no-one
in the right frame of mind would enter 12/11/2006 if they meant Dec 11 2006
and if they did then they would understand it was their mistake and enter it
correctly next time. On the other hand, if the web application would
interpret their date in the US format then they would be disappointed with
the site as it did not cater for the New Zealand format.

What I like about strtotime is that you do not have to have some set format.
You can just enter tomorrow, next week or whatever and it will pick it up.
I think that is just awesome!

Thanks for your reply.
[color=blue]
> Nicolaas[/color]

[Mladen Gogala]

Re: i love strtotime but it is no use in New Zealand

On Tue, 25 Apr 2006 13:41:31 +1200, windandwaves wrote:
[color=blue]
> HOWEVER, this obviously does not work for the day/month vs month/day
> scenario. That is, in New Zealand we use day/month/year, while the function
> assumes it to be month/day/year.[/color]

Have you considered moving to Wyoming or Iowa? No waves there, but no
great white sharks, either. Alternatively, you can use PEAR::Date class
which contains different functions to format dates and time.

--

http://www.mgogala.com

[Toby Inkster]

Re: i love strtotime but it is no use in New Zealand

windandwaves wrote:
[color=blue]
> HOWEVER, this obviously does not work for the day/month vs month/day
> scenario. That is, in New Zealand we use day/month/year, while the function
> assumes it to be month/day/year.[/color]

Generally what I do is something like this (pseudo-code):

<?php

function mystrtotime($da te)
{
if ($date is "??/??/??" || $date is "??-??-??")
{
list($d, $m, $y) = preg_split('/\/\-/', $date);
if ($y<70)
$y += 2000;
else
$y += 1900;
}
elseif ($date is "??/??/????" || $date is "??-??-????")
list($d, $m, $y) = preg_split('/\/\-/', $date);

if (isset($d))
$date = sprintf("%04d-%02d-%02d", $y, $m, $d);

return strtotime($date );
}
?>

I'll let you work out the regular expressions for the conditionals
yourself. :-)

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

[Erwin Moller]

Re: i love strtotime but it is no use in New Zealand

windandwaves wrote:
[color=blue]
> Hi Folk
>
> I love the strtotime function, because I can make a date field in a form
> and just tell my users to enter whatever they want and as long as it is a
> date, it will work.
>
> HOWEVER, this obviously does not work for the day/month vs month/day
> scenario. That is, in New Zealand we use day/month/year, while the
> function assumes it to be month/day/year.[/color]

And that's a pain, isn't it?

I always solve this problem in one of the following ways:
1) Ask the user 3 inputfields, day/month/year, or whatever order is
appropriate in some country.
2) Make my own datestring for the database-insert, or make my own date for
PHP purposes, which is easy once you know what field is what.

Alernatively, if you want to offer your visitor ONE field for a date, just
make sure YOU parse it the way it should be before using.
eg:
[html]

format: d/m/y
<input type="text" name="somedate" >

[php]
$dateparts = split("/",$_POST["somedate"]);
// now reasssemble any way you want: eg:
DateForPostgres = $dateparts[1]."/"$dateparts[0]."/".$datepart s[2];

(assuming Postgres is set to take m/d/y dates.)

Regards,
Erwin Moller

[color=blue]
>
> Does anyone have a simple function that helps me close that loophole (I am
> using PHP 4.4).
>
> I copied the function below from php.net, but I dont think it will work in
> all cases.
>
> Cheers
>[color=green]
>> Nicolaas[/color]
> # Returns a timestamp from a string based on the given format and default
> timezone if it's ambiguous.
> # %Y - year as a decimal number including the century
> # %m - month as a decimal number (range 01 to 12)
> # %d - day of the month as a decimal number (range 01 to 31)
> # %H - hour as a decimal number using a 24-hour clock (range 00 to 23)
> # %M - minute as a decimal number
>
> function parseDate( $date, $format = "%d/%m/%Y") {
> // Builds up date pattern from the given $format, keeping delimiters in
> place.
> if( !preg_match_all ( "/%([YmdHMp])([^%])*/", $format, $formatTokens,
> PREG_SET_ORDER ) ) {
> return false;
> }
> foreach( $formatTokens as $formatToken ) {
> $delimiter = preg_quote( $formatToken[2], "/" );
> $datePattern .= "(.*)".$delimit er;
> }
>
> // Splits up the given $date
> if( !preg_match( "/".$datePattern. "/", $date, $dateTokens) ) {
> return false;
> }
> $dateSegments = array();
> for($i = 0; $i < count($formatTo kens); $i++) {
> $dateSegments[$formatTokens[$i][1]] = $dateTokens[$i+1];
> }
>
> // Reformats the given $date into US English date format, suitable for
> strtotime()
> if( $dateSegments["Y"] && $dateSegments["m"] && $dateSegments["d"] ) {
> $dateReformated =
> $dateSegments["Y"]."-".$dateSegm ents["m"]."-".$dateSegm ents["d"];
> }
> else {
> return false;
> }
> if( $dateSegments["H"] && $dateSegments["M"] ) {
> $dateReformated .= " ".$dateSegm ents["H"].":".$dateSegme nts["M"];
> }
>
> return strtotime( $dateReformated );
> }[/color]

[fletch]

Re: i love strtotime but it is no use in New Zealand

> HOWEVER, this obviously does not work for the day/month vs month/day[color=blue]
> scenario. That is, in New Zealand we use day/month/year, while the function
> assumes it to be month/day/year.[/color]

Doesn't setlocale() sort this out? What locale is the server your using
running? I always thought strtotime() obeyed the current locale
settings, strftime() certainly does.

[Erwin Moller]

Re: i love strtotime but it is no use in New Zealand

Erwin Moller wrote:

[typocorrection]

$DateForPostgre s = $dateparts[1]."/".$datepart s[0]."/".$datepart s[2];

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

Toby Inkster wrote:
....
[color=blue]
> I'll let you work out the regular expressions for the conditionals
> yourself. :-)[/color]


Thanks Toby, especially because that is the one thing I really suck at most.
Do you know the best way to learn regex? I have been looking on the net a
lot but never found a good tutorial.

Thanks again man!
[color=blue]
> Nicolaas[/color]

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

Mladen Gogala wrote:[color=blue]
> On Tue, 25 Apr 2006 13:41:31 +1200, windandwaves wrote:
>[color=green]
>> HOWEVER, this obviously does not work for the day/month vs month/day
>> scenario. That is, in New Zealand we use day/month/year, while the
>> function assumes it to be month/day/year.[/color]
>
> Have you considered moving to Wyoming or Iowa? No waves there, but no
> great white sharks, either. Alternatively, you can use PEAR::Date
> class which contains different functions to format dates and time.[/color]


hmmm, i dont control the server ... so no Pear I think.

[Chris Hope]

Re: i love strtotime but it is no use in New Zealand

windandwaves wrote:
[color=blue]
> Mladen Gogala wrote:[color=green]
>> On Tue, 25 Apr 2006 13:41:31 +1200, windandwaves wrote:
>>[color=darkred]
>>> HOWEVER, this obviously does not work for the day/month vs month/day
>>> scenario. That is, in New Zealand we use day/month/year, while the
>>> function assumes it to be month/day/year.[/color]
>>
>> Have you considered moving to Wyoming or Iowa? No waves there, but no
>> great white sharks, either. Alternatively, you can use PEAR::Date
>> class which contains different functions to format dates and time.[/color]
>
> hmmm, i dont control the server ... so no Pear I think.[/color]

You can still download the PEAR libraries you require and put them in a
directory in your web tree (eg called 'pear') and then add that to your
include path. I've done this many times before for PEAR libraries that
a third party host does not have.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[windandwaves]

Re: i love strtotime but it is no use in New Zealand

Chris Hope wrote:
......
[color=blue]
> You can still download the PEAR libraries you require and put them in
> a directory in your web tree (eg called 'pear') and then add that to
> your include path. I've done this many times before for PEAR
> libraries that a third party host does not have.[/color]

HMMMM, that is way cool! Thanks for that. Superuseful!

[Adam]

Re: i love strtotime but it is no use in New Zealand

On Tue, 25 Apr 2006 04:55:54 GMT, Mladen Gogala wrote:
[color=blue]
>On Tue, 25 Apr 2006 13:41:31 +1200, windandwaves wrote:
>[color=green]
>> HOWEVER, this obviously does not work for the day/month vs month/day
>> scenario. That is, in New Zealand we use day/month/year, while the function
>> assumes it to be month/day/year.[/color]
>
>Have you considered moving to Wyoming or Iowa? No waves there, but no
>great white sharks, either. Alternatively, you can use PEAR::Date class
>which contains different functions to format dates and time.[/color]

Aaah yes ... but are there any *sheep*???

Adam (also in NZ).