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