public static function saveToAchievement(Achievement $achievement) { $conn = cont\connection::getConnectionObject(); $con = $conn->getConnection(); $sql = $con->prepare("INSERT INTO achievement VALUES (?,?,?,? )"); $sport_id = $achievement->getSportId(); $achievement_id = $achievement->getAchievementId(); $description = $achievement->getDescription(); $date = $achievement->getDate(); echo $sport_id; echo $achievement_id; echo $description; echo $date; $sql->bind_param("ssss", $sport_id, $achievement_id, $description, $date); $sql->execute(); if ($sql->errno) { echo "FAILURE!!! " . $sql->error; } else { echo "Updated {$sql->affected_rows} rows"; } }
public function addStudentAction() { $sport_id = $_POST["Sport"]; $achievement_id = $_POST["achievement_id"]; $description = $_POST["description"]; $date = $_POST["date"]; $achievement = new Entity\Achievement(); $achievement->setDate($date); $achievement->setAchievementId($achievement_id); $achievement->setDescription($description); $achievement->setSportId($sport_id); cont\AchievementDBaccess::saveToAchievement($achievement); return $this->render('applicationStudentBundle:Default:index.html.twig'); }