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