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');
}
