[Resolved] was there a better way to flip this date?

[jasonmills58]

So, I'm getting my date from MySQL in the yyyy-mm-dd format into the variable $a_row['date'] and I wanted to display it as Jan 15, 2004 so I did this:

PHP Code:

$date = explode ( "-", $a_row['date'] );
$year = $date[0];
$month = $date[1];
$day = $date[2];
$ts = mktime( 0, 0, 0, $month, $day, $year );
$date = date( "F j Y", $ts );
$date = explode( " ", $date );
$month = substr( $date[0], 0, 3 );
$date = $month." ".$date[1].", ".$date[2];
print $date;


It works perfectly. First try, even! *pulls muscle patting self on back* I was just wondering if anyone could think of a more concise way of doing this.

I know I could change this:

PHP Code:

$year = $date[0];
$month = $date[1];
$day = $date[2];
$ts = mktime( 0, 0, 0, $month, $day, $year );


to:

PHP Code:

$ts = mktime( 0, 0, 0, $date[1], $date[2], $date[0] );


but I guess i liked the clarity of $ts = mktime( 0, 0, 0, $month, $day, $year );

[cosminb]

strtotime & date

[jasonmills58]

yes, thank you. Unfortunately strtotime() does not know what to do with 2004-01-18. And in regards to date(), I believe I used it correctly in my example, but I am of course open to critiques...

thanks again.

[cosminb]

Originally posted by jasonmills58
... Unfortunately strtotime() does not know what to do with 2004-01-18. ...

what are you talking about ???.
try this:

PHP Code:

echo date('r', strtotime('2004-01-18'));


[cosminb]

... so I guess all your 9 lines of code could be replaced by one:

PHP Code:

print date('F j Y', strtotime($a_row['date']));


[LordShryku]

You could also use date_format in your SQL

[jasonmills58]

Thanks for the ideas guys. I think like how mine has it all layed out. I get too easily confused...

And I can't use "print date('F j Y', strtotime($a_row['date']));" because the whole reason i did this was to have three letter month names like Jan, Feb, etc ( pretty lame, huh? ).

cheers!
jason

[Moonglobe]

then use the "M" modifier of date

[jasonmills58]

o.o -.- o.o -.- o.o

but I looked for that. I could have sworn it wasn't there. I thought to myself, "Self, there has to be a month abbreviator." but I couldn't find it. and it was right there the whole time.

*is most embarrased* but thank you moonglobe, i appreciate it.

so, is there a way to tell PHP that $a_row['eventdate'] is populated with a MySQL date value to shorten this:

PHP Code:

$date = explode ( "-", $a_row['eventdate'] );
$year = $date[0];
$month = $date[1];
$day = $date[2];
$ts = mktime( 0, 0, 0, $month, $day, $year );
$date = date( "M j, Y", $ts );


[Weedpacket]

Originally posted by jasonmills58
"Self, there has to be a month abbreviator." but I couldn't find it. and it was right there the whole time.

I was thinking "Who in their right mind has a use for 'B'?"

so, is there a way to tell PHP that $a_row['eventdate'] is populated with a MySQL date value to shorten this:

Well, that's what [this] is doing . Here are three suggestions:

1. I tend to use sscanf() and list() rather than explode() and all that.
2. YYYY-MM-DD is a format that is recognised by strtotime().
3. You can have MySQL format the date to your specification before returning it with its own date formatting function.