Change Date from dd/mm/yyyy to yyyy-dd-mm for MYSQL Friendly is simple. $date_array = explode(“/”,$date); //