Menu
Community /Pin to ProfileBookmark
@NogDogMar 08.2009 — #Assuming $startHr will be an integer from 1-12 and $startAmPm will be either "AM" or "PM", You could do:
php mysql time value
Hi
I want to sent a time value from avariable to a mysql database. the column in mysql wil be formated as time. I have the following information that is being based from a form that I want to enter into the mysql database. My question is how do I format t the values be for sending them
$startHr = $_POST[‘startHr’];
$startMin = $
$startAmPm = $_POST[‘startAmPm’];
I want to create a variable $startTime that I can use to pass the time to the database. I will write a If statement to convert the time to a military time.
any help is great
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogMar 08.2009 — #Assuming $startHr will be an integer from 1-12 and $startAmPm will be either "AM" or "PM", You could do:[code=php]
if($startAmPm == "PM")
{
$startHr += 12;
}
if($startHr == 12 and $startAmPm == "AM")
{
$startHr = 0;
}
$dbTime = sprintf("%02d:%02d", $startHr, $startMin);
[/code]