php - Date/Time Field In Mysql table -

php - Date/Time Field In Mysql table -

i have next code in php inserts start date , end date date , time . date , time added via iphone date , time wheel when selecting input field. problem if select 1pm local time start date , 2pm end date submit record 6pm , 7pm. coding issue, date/time field issue or form issue? variables of $start_date , $end_date pulled straight input form.

$query = "insert events (event_id, event_name, user_name, id_user, start_date, end_date, details, location, dresscode,private) values ('null', '".$event_name."', '".$user_name."', '".$user_id."', '".$start_date."','".$end_date."','".$time."','".$location."','".$dresscode."','".$private_id."')"; mysql_query ($query);

php mysql datetime