public static function addRequestResource($con, RequestResource $requestResource) { try { $sql = $con->prepare("INSERT INTO RequestResource VALUES(?,?,?,?,?,?,?)"); $requestId = $requestResource->getRequestId(); $resourceId = $requestResource->getResourceId(); $qty = $requestResource->getQty(); $borrowingDate = $requestResource->getItemBorrowingDate(); $issueDate = date('Y-m-d'); $returnDate = $requestResource->getReturnDate(); $status = 1; $sql->bind_param("ssisssi", $requestId, $resourceId, $qty, $borrowingDate, $issueDate, $returnDate, $status); if ($sql->execute() == TRUE) { return true; } else { return false; } } catch (Exception $w) { return false; } }