public static function addStudentRequest(Request $request, array $requestResource) { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $con->autocommit(false); $sql = $con->prepare("INSERT INTO Request VALUES (?,?,?,?)"); $requestId = $request->getRequestId(); $studentId = $request->getStudentId(); $date = $request->getRequestDate(); $status = "pending"; $sql->bind_param("ssss", $requestId, $studentId, $date, $status); if ($sql->execute() == TRUE) { foreach ($requestResource as $value) { $isAdded = StudentRequestDBaccess::addRequestResource($con, $value); if ($isAdded == false) { $con->rollback(); return false; } } } else { $con->rollback(); return false; } $con->commit(); return true; } catch (Exception $e) { $con->rollback(); return false; } finally { $con->autocommit(true); $con->close(); } }
public static function getRequestResource(en\Request $request) { $request_id = $request->getRequestId(); $conn = cont\connection::getConnectionObject(); $con = $conn->getConnection(); $sql = $con->prepare("SELECT * FROM RequestResource WHERE request_id={$request_id}"); $sql->bind_param('s', $request_id); $sql->execute(); $result = $sql->get_result(); // $requestResources = array(); $res_num = 0; while ($row = $result->fetch_assoc()) { $requestResource = new en\RequestResource(); $requestResource->setResourceId($row[1]); $requestResource->setItemBorrowingDate($row[2]); $requestResource->setIssueDate($row[3]); $requestResource->setReturnDate($row[4]); $requestResource->setStatus($row[5]); $requestResources[$res_num] = $requestResource; $res_num++; } return $requestResources; }