cakephp saving dates in datetime format code example

Example: Add 2 hours to current time in cakephp

DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '

if (isset($data_search["time_start"]) && !empty(trim($data_search["time_start"]))) {
  $conditions['TIME(MemberBookFacility.time) >= '] = $data_search["time_start"];	// date('H:i', strtotime($data_search["time_start"]));
}

if (isset($data_search["time_end"]) && !empty(trim($data_search["time_end"]))) {
  $conditions['DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '] = $data_search["time_end"];	// date('H:i', strtotime($data_search["time_end"]));
}

Tags:

Php Example