note 46864 deleted from function.date by didou
| From: | didou@php.net | Date: | Tue, 26 Oct 2004 11:02:10 +0000 |
| Subject: | note 46864 deleted from function.date by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-79116@lists.php.net to get a copy of this message | ||
Note Submitter:
----
For making timestamps out of MySQL dates in PHP rather than SQL - use this function:
function mysql2time ( $timestamp ) {
$year = substr( $timestamp, 0, 4 );
$month = substr( $timestamp, 4, 2 );
$day = substr( $timestamp, 6, 2 );
$hour = substr( $timestamp, 8, 2 );
$minute = substr( $timestamp, 10, 2 );
$second = substr( $timestamp, 12, 2 );
$time = mktime ( $hour, $minute, $second, $month, $day, $year );
return $time;
};
----
Reason: bad code