public function indexAction() { $practiceSchedule = new en\PracticeSchedule(); $practiceSchedule->setSportId($_POST["sport"]); $practiceSchedule->setResourceId($_POST["location"]); $practiceSchedule->setPractiseDate($_POST["date"] + "-" + $_POST["month"] + "2016"); $practiceSchedule->setPractiseStartTime($_POST["start_hour"] . ":" . $_POST["start_minutes"] . ":00"); $practiceSchedule->setPractiseEndTime($_POST["end_hour"] . ":" . $_POST["end_minutes"] . ":00"); $practiceSchedule->setAuthor($_POST["author"]); $practiceSchedule->setStatus("Active"); $isEventAdded = cont\PracticeScheduleDBaccess::saveScheduledEvent($practiceSchedule); if ($isEventAdded) { return $this->render('SportBundle:Default:success.html.twig'); } else { return $this->render('SportBundle:Default:success.html.twig'); } }
public static function getAllLocationSchedule($resource_id) { $stm = null; try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT sport_id,practiceDate,practiceStartTime,locationName,author,status,practiceEndTime FROM practiceschedule NATURAL JOIN location where location.resource_id=?"); $stm->bind_param("s", $resource_id); $stm->execute(); $result = $stm->get_result(); $practiceScheduleArray = array(); while ($row = $result->fetch_assoc()) { $practiceSchedule = new PracticeSchedule(); $stm_sport = $con->stmt_init(); $stm_sport->prepare("SELECT name FROM sport where sport.sport_id=?"); $stm_sport->bind_param("s", $row["sport_id"]); $stm_sport->execute(); $result_sport = $stm_sport->get_result(); $row_sport = $result_sport->fetch_assoc(); $practiceSchedule->setSportName($row_sport["name"]); $practiceSchedule->setPractiseDate($row["practiceDate"]); $practiceSchedule->setPractiseStartTime($row["practiceStartTime"]); $practiceSchedule->setResourceName($row["locationName"]); $practiceSchedule->setPractiseEndTime($row["practiceEndTime"]); $practiceSchedule->setAuthor($row["author"]); $practiceSchedule->setStatus($row["status"]); $practiceScheduleArray[] = $practiceSchedule; //array_push($practiceScheduleArray, ); } return $practiceScheduleArray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); //$stm->close(); } }