$password = "******"; // Mysql password $db_name = "coderdojo"; // Database name // Create connection $conn = mysqli_connect($host, $username, $password, $db_name); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } //Passed Data $postdata = file_get_contents("php://input"); $request = json_decode($postdata); $BookingID = $request->BookingID; $CourseID = $request->CourseID; if (UpdateTickets($CourseID, $conn)) { if (DeleteRecord($conn, $BookingID)) { echo "Success"; } else { echo "Fail Delete Record"; } } else { echo "Fail Update Tickets"; } //Increase the amount of available tickets when cancelling booking function UpdateTickets($CourseID, $conn) { $sql = "UPDATE course SET AvailableTickets = AvailableTickets + 1 WHERE CourseID = {$CourseID}"; if (mysqli_query($conn, $sql)) { return true; } else {
//Booking Object class BookingDetails { public $CourseID = 0; public $StudentID = ""; public $TermID = ""; } $booking = new BookingDetails(); $booking->TermID = $request->TermID; $booking->StudentID = $request->StudentID; $booking->CourseID = $request->CourseID; if (AvailableTickets($booking->CourseID, $conn) > 0) { if (ExistenceCheck($booking, $conn)) { $sql = "INSERT INTO `coderdojo`.`booking` (`BookingID`, `CourseID`, `StudentID`, `TermID`) VALUES (NULL, '{$booking->CourseID}', '{$booking->StudentID}', '{$booking->TermID}');"; if (mysqli_query($conn, $sql)) { UpdateTickets($booking->CourseID, $conn); echo "Success"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } else { echo "Exists"; } } else { echo "No Tickets Available"; } //Check if the booking has already been made function ExistenceCheck($booking, $conn) { $sql = "SELECT BookingID, StudentID, CourseID, TermID FROM booking WHERE StudentID = {$booking->StudentID} AND TermID={$booking->TermID}"; $CheckResult = mysqli_query($conn, $sql);