public function addSportInvolveAction()
{
$studentSP = new Entity\SportInvolve();
$studentSP->setSportId($_GET["sportId"]);
$studentSP->setStudentId($_GET["student_id"]);
$studentSP->setIsActive($_GET["status"]);
$studentSP->setRole($_GET["role"]);
$status = StudentDBaccess::addSportInvolveDetails($studentSP);
return new JsonResponse(['status' => $status]);
}
public static function addSportInvolveDetails(SportInvolve $sportInvolve)
{
try {
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$sql = $con->prepare("INSERT INTO SportInvolve VALUES (?,?,?,?)");
$studentId = $sportInvolve->getStudentId();
$sportId = $sportInvolve->getSportId();
$status = $sportInvolve->getIsActive();
$role = $sportInvolve->getRole();
$sql->bind_param("ssis", $studentId, $sportId, $status, $role);
if ($sql->execute() == TRUE) {
echo "New record created successfully";
return true;
} else {
//echo "Error: " . $sql . "<br>";
return false;
}
} catch (Exception $e) {
return false;
} finally {
$con->close();
}
}
