$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);
