Current Time

[johnbruce]

Hi all,

 

I currently have the following code that writes values back to a mysql database, as you can see the last 2 fields are date and time. The date field works fine and writes the current date back to the db, how do I write the current time back to the last field?

 

$date = date("Y-m-d ");
$query = "INSERT INTO applicants VALUES ('','$title','$first','$last','$phone','$mobile','$site','$email','$avaliable','$experience','$date','time()')";

 

Regards,

John

[clown[NOR]]

date("h:i:s a") <- show's 12hrs with lowercase am/pm at the end

date("H:i:s") <- shows 24hrs without am/pm

[johnbruce]

Thanks, It wrote back a time but it wasn't our local time. Any idea how to solve this?

[clown[NOR]]

hmm.. i'm not sure, but it might be that since the php is server-side scripting it returns the current time on the server... but i belive, correct me if I'm way off here, that JavaScript will get the current time from the users computer

[johnbruce]

I'm not sure. Is there anyway to add a set amount of hours to the time before it gets submitted to the database?

 

For example, the server time + 5 hours

[taith]

here... just activate this function... it'll change your servers default timezone :-)

<?php
function set_timezone($timezone="0"){
switch($timezone){
  case "-12": date_default_timezone_set('Etc/GMT+12'); break;
  case "-11": date_default_timezone_set('Etc/GMT+11'); break;
  case "-10": date_default_timezone_set('Etc/GMT+10'); break;
  case "-9": date_default_timezone_set('Etc/GMT+9'); break;
  case "-8": date_default_timezone_set('Etc/GMT+8'); break;
  case "-7": date_default_timezone_set('Etc/GMT+7'); break;
  case "-6": date_default_timezone_set('Etc/GMT+6'); break;
  case "-6": date_default_timezone_set('Etc/GMT+5'); break;
  case "-4": date_default_timezone_set('Etc/GMT+4'); break;
  case "-3": date_default_timezone_set('Etc/GMT+3'); break;
  case "-2": date_default_timezone_set('Etc/GMT+2'); break;
  case "-1": date_default_timezone_set('Etc/GMT+1'); break;
  case "0": date_default_timezone_set('GMT'); break;
  case "1": date_default_timezone_set('Etc/GMT-1'); break;
  case "2": date_default_timezone_set('Etc/GMT-2'); break;
  case "3": date_default_timezone_set('Etc/GMT-3'); break;
  case "4": date_default_timezone_set('Etc/GMT-4'); break;
  case "5": date_default_timezone_set('Etc/GMT-5'); break;
  case "6": date_default_timezone_set('Etc/GMT-6'); break;
  case "7": date_default_timezone_set('Etc/GMT-7'); break;
  case "8": date_default_timezone_set('Etc/GMT-8'); break;
  case "9": date_default_timezone_set('Etc/GMT-9'); break;
  case "10": date_default_timezone_set('Etc/GMT-10'); break;
  case "11": date_default_timezone_set('Etc/GMT-11'); break;
  case "12": date_default_timezone_set('Etc/GMT-12'); break;
}
}
set_timezone('-5');
?>