Home > Archive > PHP DB > May 2006 > RE: [PHP-DB] Date Conversion
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: [PHP-DB] Date Conversion
|
|
| Ralph Brickley 2006-05-16, 7:00 pm |
| A simple associate array would work as well, although not quite as elegent.
$months_arr = array("January"=>01, "February"=>02...);
-----Original Message-----
From: Mark Bomgardner [mailto:mbomgardner@kletc.org]
Sent: Tuesday, May 16, 2006 12:35 PM
To: Php-Db
Subject: [PHP-DB] Date Conversion
PHP 4.4/MySQL 4.0
I am tying to convert a date to put into a database from a string (ie:
January, February) to a numeric value (ie: 01,02). I am taking the
value from a form, which is a drop down menu listing the months.
$sMonth1 = $_POST['Smonth']; returns the money selected from the form.
When I go to format the month from a string to numeric with
date('m',strtotime($sMonth1));
it returns 12, no matter which month I select.
In reading the docs at php.net, date('m',strtotime($sMonth1)); is
correct to reformat from a string to a time format.
What am I missing.
mark bomgardner
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
| |
| Ralph Brickley 2006-05-16, 7:00 pm |
| ADDENDUM:
To Convert your date string, use the associate array:
$months_arr = array("January"=>01, "February
=>02...);
$month = $months_arr["February"];
* Replace $months_arr["February"] with $_POST["Month"];
// Output
$month = 01;
Ralph Brickley
-----Original Message-----
From: Ralph Brickley [mailto:ralphbrickley@verizon.net]
Sent: Tuesday, May 16, 2006 1:29 PM
To: mbomgardner@kletc.org; 'Php-Db'
Subject: RE: [PHP-DB] Date Conversion
A simple associate array would work as well, although not quite as elegent.
$months_arr = array("January"=>01, "February"=>02...);
-----Original Message-----
From: Mark Bomgardner [mailto:mbomgardner@kletc.org]
Sent: Tuesday, May 16, 2006 12:35 PM
To: Php-Db
Subject: [PHP-DB] Date Conversion
PHP 4.4/MySQL 4.0
I am tying to convert a date to put into a database from a string (ie:
January, February) to a numeric value (ie: 01,02). I am taking the
value from a form, which is a drop down menu listing the months.
$sMonth1 = $_POST['Smonth']; returns the money selected from the form.
When I go to format the month from a string to numeric with
date('m',strtotime($sMonth1));
it returns 12, no matter which month I select.
In reading the docs at php.net, date('m',strtotime($sMonth1)); is
correct to reformat from a string to a time format.
What am I missing.
mark bomgardner
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|
|
|
|
|