[RESOLVED] Time for db

zzz

I have a form that has 3 fields for time:

$h = 11;
$m = 22;
$AmPm = 'PM';

How do I store this as one field in the database?
And how do I get it back into the format above from db?

Horizon88

Well, you could concatenate them and use strtotime() and date() to put them into the database, then probably explode() to get them back into the three-variable format. What field type are you using to store them in the database currently? Just a varchar?

Edit: substr() may also be acceptable, instead of explode(), depending on how you format the string.

dagon

use field type time

add 12 if its pm

zzz

OK, the whole time/date thingy is always a bit confusing for me.

I tried strtotime() and got some numerical string (1243879200), however when I look into my db it expects something like: 2009-06-01 14:39:19.

Here's my poor attempt:

$eventStart = strtotime($_SESSION['event']['eventDate'].' '.$_SESSION['event']['eventStart_h'] .':'. $_SESSION['event']['eventStart_m'] . $_SESSION['event']['eventStart_ampm']);

Where did I take the wrong turn?

zzz

OK, I changed field to time. Now it's looking for 00:00:00.

I can construct 11:33:00 PM. So how do I make it work? I think I'm close, just miss something...

zzz

dagon;10916758 wrote:
add 12 if its pm

Where do I add 12?

dagon

the original post said hour and minute only, so do you know want date?

otherwise--

if($$_SESSION['event']['eventStart_ampm']=='PM'){
	$_SESSION['event']['eventStart_h']=$_SESSION['event']['eventStart_h']+12;
}

$time=$_SESSION['event']['eventStart_h'].':'.$_SESSION['event']['eventStart_m'];


$sql="INSERT in to foo set time='$time' WHERE bar";

to get it back

select from foo TIME_FORMAT(time, '%H') as hour, TIME_FORMAT(time, '%i') as minute, TIME_FORMAT(time, '%p') as am_pm

zzz

Ah, brilliant. How did I manage have such a gap in my otherwise satisfactory PHP education? Great stuff!