public function getTravelAdvisory($travelAdvisoryId) { $connection = parent::connect(); $selectSQL = "SELECT * FROM TRAVELADVISORY WHERE TRAVELADVISORYID=:traveladvisoryid"; $travelAdvisory = ""; try { $statement = $connection->prepare($selectSQL); $statement->bindValue(":traveladvisoryid", $travelAdvisoryId, PDO::PARAM_INT); $statement->execute(); $row = $statement->fetch(); $travelAdvisory = new TravelAdvisory(); $travelAdvisory->setTravelAdvisoryId($row[0]); $travelAdvisory->setTravelAdvisorySourceName($row[1]); $travelAdvisory->setTravelAdvisorySourceLink($row[2]); $travelAdvisory->setTravelAdvisorySourceLinkType($row[3]); parent::disconnect($connection); } catch (PDOException $exception) { echo "exception Message" . $exception->getMessage(); parent::disconnect($connection); print_r($connection->errorInfo()); } return $travelAdvisory; }
<?php require_once "TravelAdvisoryPDO.php"; require_once "TravelAdvisory.php"; if (isset($_POST['submit'])) { $traveladvisoryid = $_POST["traveladvisoryid"]; $traveladvisorysourcename = $_POST["traveladvisorysourcename"]; // echo $username . "<br>\n"; $traveladvisorysourcelink = $_POST["traveladvisorysourcelink"]; //echo $password ."<br>\n"; $traveladvisorysourcelinktype = $_POST["traveladvisorysourcelinktype"]; if ($traveladvisorysourcename != '' && $traveladvisorysourcelink != '' && $traveladvisorysourcelinktype != '') { $traveladvisoryPDO = new TravelAdvisoryPDO(); $travelAdvisory = new TravelAdvisory(); $travelAdvisory->setTravelAdvisoryId($traveladvisoryid); $travelAdvisory->setTravelAdvisorySourceName($traveladvisorysourcename); $travelAdvisory->setTravelAdvisorySourceLink($traveladvisorysourcelink); $travelAdvisory->setTravelAdvisorySourceLinkType($traveladvisorysourcelinktype); $traveladvisoryPDO->updateTravelAdvisory($travelAdvisory); echo "<html>"; echo "<head>"; echo "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' >"; echo "<link rel='stylesheet' type='text/css' href='menu.css'>"; echo "<title>News Portal - Insert Travel Advisory</title>"; echo "</head>"; echo "<body>"; include "menu.php"; echo "Created a Travel Advisory </br>"; echo "<a href='Home.php'> Back to Home</a>"; echo "</body>"; echo "</html";
<?php require_once "TravelAdvisoryPDO.php"; require_once "TravelAdvisory.php"; if (isset($_POST['submit'])) { $traveladvisorysourcename = $_POST["traveladvisorysourcename"]; // echo $username . "<br>\n"; $traveladvisorysourcelink = $_POST["traveladvisorysourcelink"]; //echo $password ."<br>\n"; $traveladvisorysourcelinktype = $_POST["traveladvisorysourcelinktype"]; if ($traveladvisorysourcename != '' && $traveladvisorysourcelink != '' && $traveladvisorysourcelinktype != '') { $traveladvisoryPDO = new TravelAdvisoryPDO(); $travelAdvisory = new TravelAdvisory(); $travelAdvisory->setTravelAdvisorySourceName($traveladvisorysourcename); $travelAdvisory->setTravelAdvisorySourceLink($traveladvisorysourcelink); $travelAdvisory->setTravelAdvisorySourceLinkType($traveladvisorysourcelinktype); $traveladvisoryPDO->insertTravelAdvisory($travelAdvisory); echo "<html>"; echo "<head>"; echo "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' >"; echo "<link rel='stylesheet' type='text/css' href='menu.css'>"; echo "<title>News Portal - Insert Travel Advisory</title>"; echo "</head>"; echo "<body>"; include "menu.php"; echo "Created a Travel Advisory </br>"; echo "<a href='index.php'> Back to Home</a>"; echo "</body>"; echo "</html"; } else { echo "Please fill all of the fields" . "<br>\n";