public static function getAllSports() { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT sport_id,name FROM Sport"); // // $result = mysqli_query($con,$sql); // // $stm->execute(); $result = $stm->get_result(); // $equipmentArray = array(); while ($row = $result->fetch_assoc()) { $eqOb = new Sport(); $eqOb->setName($row["name"]); $eqOb->setSportId($row["sport_id"]); $equipmentArray[] = $eqOb; } return $equipmentArray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); // $stm->close(); } }
public static function getAllSports() { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT name,sport_id FROM Sport"); $stm->execute(); $result = $stm->get_result(); $sportArray = array(); $count = 0; while ($row = $result->fetch_assoc()) { $sport = new Sport(); $sport->setName($row["name"]); $sport->setSportId($row["sport_id"]); $sportArray[] = $sport; } return $sportArray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); $stm->close(); } }
public function saveSportAction() { $spr = new en\Sport(); $sportName = $_POST["sportname"]; $sportId = $_POST["sportid"]; if ($sportName == NULL) { echo "Please enter valid a Sport Name"; return $this->render('SportBundle:AddSport:addSport.html.twig'); } else { $spr->setName($sportName); $spr->setSportId($sportId); cont\SportDBaccess::saveSport($spr); return $this->render('SportBundle:Message:dbsave.html.twig'); } }