/** * Add trainer to training session */ public static function addTrainerToTraining($trainer_id, $training_id, $duration_days) { $tableObj = new TrainingToTrainer(); $select = $tableObj->select()->from($tableObj->_name, array('doesExist' => 'COUNT(*)'))->setIntegrityCheck(false)->where("trainer_id = {$trainer_id} AND training_id = {$training_id}"); $row = $tableObj->fetchRow($select); if ($row->doesExist) { return -1; } else { $data['trainer_id'] = $trainer_id; $data['training_id'] = $training_id; $data['duration_days'] = $duration_days; try { return $tableObj->insert($data); } catch (Zend_Exception $e) { error_log($e); } } }