note 81664 modified in function.strftime by danbrown
| From: | danbrown@php.net | Date: | Sun, 20 Jul 2008 03:43:31 +0000 |
| Subject: | note 81664 modified in function.strftime by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142085@lists.php.net to get a copy of this message | ||
Here's a simple version for date formating i use between displaying in HTML and converting back
to MYSQL format:
<?php
function format_date($original='', $format="%m/%d/%Y") {
$format = ($format=='date' ? "%m-%d-%Y" : $format);
$format = ($format=='datetime' ? "%m-%d-%Y %H:%M:%S" : $format);
$format = ($format=='mysql-date' ? "%Y-%m-%d" : $format);
$format = ($format=='mysql-datetime' ? "%Y-%m-%d %H:%M:%S" : $format);
return (!empty($original) ? strftime($format, strtotime($original)) : "" );
}
?>
example (in HTML or webapp):
[grab from database]...
$dbase_stored_date = "2007-03-15";
$display_html_date = format_date($dbase_stored_date);
... displays as "03/15/2007"
example (saving form via on POST/GET):
$update_date = format_date($_POST['display_html_date'], 'mysql-date');
// converts back to '2007-03-15'
.... [your mysql update here]
Don't forget to sanitize your POST/GET's =)
--was--
Here's a simple version for date formating i use between displaying in HTML and converting back
to MYSQL format:
function format_date($original='', $format="%m/%d/%Y") {
$format = ($format=='date' ? "%m-%d-%Y" : $format);
$format = ($format=='datetime' ? "%m-%d-%Y %H:%M:%S" : $format);
$format = ($format=='mysql-date' ? "%Y-%m-%d" : $format);
$format = ($format=='mysql-datetime' ? "%Y-%m-%d %H:%M:%S" : $format);
return (!empty($original) ? strftime($format, strtotime($original)) : "" );
}
example (in HTML or webapp):
[grab from database]...
$dbase_stored_date = "2007-03-15";
$display_html_date = format_date($dbase_stored_date);
... displays as "03/15/2007"
example (saving form via on POST/GET):
$update_date = format_date($_POST['display_html_date'], 'mysql-date');
// converts back to '2007-03-15'
.... [your mysql update here]
Don't forget to sanitize your POST/GET's =)
http://php.net/manual/en/function.strftime.php