[LakkadBabu]

I am excepting date from the user in a format "d/m/Y" (eg. "22/03/2007")
and want to submit in the format "Y/m/d" ("2007/03/22")
because Mysql store date in this format
Please help

[job0107]

Like this:

PHP Code:

<?php
$date = "22/03/2007";
$temp_date = explode("/",$date);
$stamp = mktime(0,0,0,$temp_date[1],$temp_date[0],$temp_date[2]);
$new_date = date('Y/m/d',$stamp);
echo $new_date;
?>

[mab]

Here is a different method that also validates the format (but not the actual values) and is also not limited by the Unix timestamp min/max values -

PHP Code:

    if(preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) == 1)

    {

        // This puts the d (or dd), m (or mm), and year in $parts[1] through $parts[3]

        // have a valid date, put into yyyy-mm-dd format

        $mysql = sprintf("%d-%02d-%02d",$parts[3],$parts[2],$parts[1]);

        echo "Before: $date, after: $mysql<br />";

    } else {

        echo "The date format: $date was invalid<br />";

    } 

[LakkadBabu]

Originally Posted by job0107

Like this:

PHP Code:

<?php

$date = "22/03/2007";

$temp_date = explode("/",$date);

$stamp = mktime(0,0,0,$temp_date[1],$temp_date[0],$temp_date[2]);

$new_date = date('Y/m/d',$stamp);

echo $new_date;

?>

Thanks I tried this code and it worked.

[job0107]

mab's code works real good to. And you can put it all on one line using boolean logic.

PHP Code:

<?php
$date = "22/03/2007";
$new_date = preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) ? sprintf("%d/%02d/%02d",$parts[3],$parts[2],$parts[1]) : "The date format: $date was invalid<br />";
echo $new_date;
?>

But there is one drawback, if you had a date like this "22/13/2007" (ie:d/m/Y), it would also validate
even though the month is set to 13.

And this date "22/00/2007" would also validate even though the month is 00.

However, it will not roll forward or backward to compensate.

But you can check for these erroneous values if you don't want it to roll backword or forward.

And mab's code isn't restricted to the starting and ending years that mktime() is.

[mab]

Version which adds date validation. No human enters dates expecting out of range rollover/rollback. Such values would indicate a typo was made and should not be processed further. -

PHP Code:

    if(preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) == 1)

    {

        // This puts the d (or dd), m (or mm), and year $parts[1] through $parts[3]

        // echo "<pre>",print_r($parts),"</pre>";

        // have a valid date, put into yyyy-mm-dd format

        $mysql = sprintf("%d-%02d-%02d",$parts[3],$parts[2],$parts[1]);

        if(!checkdate($parts[2], $parts[1], $parts[3]))

        {

            echo "The date: $mysql is invalid<br />";

        } else {

            echo "Before: $date, after: $mysql<br />";

        }

    } else {

        echo "The date format: $date is invalid<br />";

    } 

[job0107]

Originally Posted by mab

Version which adds date validation. No human enters dates expecting out of range rollover/rollback. Such values would indicate a typo was made and should not be processed further. -

PHP Code:

    if(preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) == 1)
    {
        // This puts the d (or dd), m (or mm), and year $parts[1] through $parts[3]
        // echo "<pre>",print_r($parts),"</pre>";
        // have a valid date, put into yyyy-mm-dd format
        $mysql = sprintf("%d-%02d-%02d",$parts[3],$parts[2],$parts[1]);
        if(!checkdate($parts[2], $parts[1], $parts[3]))
        {
            echo "The date: $mysql is invalid<br />";
        } else {
            echo "Before: $date, after: $mysql<br />";
        }
    } else {
        echo "The date format: $date is invalid<br />";
    } 

Yes, that works good.

Here's the same thing in boolean logic.

PHP Code:

$mysql = preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) ? checkdate($parts[2], $parts[1], $parts[3]) ? sprintf("%d/%02d/%02d",$parts[3],$parts[2],$parts[1]) : "The date format: $date is invalid<br />" : "";
if(!is_numeric($mysql[0])){echo $mysql."<br />";}
else
{
 // Do something with $mysql. Like store it in a database.
 echo $mysql;
 } 

Or you could check for the "T" in the error message:

PHP Code:

$mysql = preg_match('@(\d{1,2})/(\d{1,2})/(\d{4})@',$date,$parts) ? checkdate($parts[2], $parts[1], $parts[3]) ? sprintf("%d/%02d/%02d",$parts[3],$parts[2],$parts[1]) : "The date format: $date is invalid<br />" : "";
if($mysql[0] == "T"){echo $mysql."<br />";}
else
{
 // Do something with $mysql. Like store it in a database.
 echo $mysql;
 }