public static function getAllSports() { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT sport_id,name FROM Sport"); // // $result = mysqli_query($con,$sql); // // $stm->execute(); $result = $stm->get_result(); // $equipmentArray = array(); while ($row = $result->fetch_assoc()) { $eqOb = new Sport(); $eqOb->setName($row["name"]); $eqOb->setSportId($row["sport_id"]); $equipmentArray[] = $eqOb; } return $equipmentArray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); // $stm->close(); } }
public static function getAllSport() { $stm = null; try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("select * from sport"); $stm->execute(); $result = $stm->get_result(); $sportArray = array(); while ($row = $result->fetch_assoc()) { $sport = new Sport(); $sport->setSportId($row["sport_id"]); $sport->setName($row["name"]); $sportArray[] = $sport; } return $sportArray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); //$stm->close(); } }
public static function getAllLocations() { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT resource_id ,locationName FROM location"); // // $stm->execute(); $result = $stm->get_result(); // $locationarray = array(); $count = 0; while ($row = $result->fetch_assoc()) { $location = new Location(); $location->setName($row["locationName"]); $location->setResourceid($row["resource_id"]); $locationarray[] = $location; } return $locationarray; } catch (Exception $e) { return "error"; } finally { //$conn->close(); $stm->close(); } }
public static function updateRequestResources($resourcesArray) { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); foreach ($resourcesArray as $value) { $sql = $con->prepare("UPDATE requestresource set state=? WHERE resource_id=? and request_id=? and itemBorrowingDate=?"); $sql->bind_param("isss", $value->getStatus(), $value->getResourceId(), $value->getRequestId(), $value->getItemBorrowingDate()); if ($sql->execute() == TRUE) { echo "New record created successfully in RESOURCE table"; } else { echo "Error in resource adding: <br>"; } } }
public static function getLastStudentID() { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT request_id FROM request ORDER BY request_id DESC limit 1"); $stm->execute(); $result = $stm->get_result(); while ($row = $result->fetch_assoc()) { $r = $row["request_id"]; } $s = substr($r, 2) + 1; return $s; }
public static function getSportName($id) { try { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $stm = $con->stmt_init(); $stm->prepare("SELECT name FROM sport WHERE sport_id=" + $id); $stm->execute(); $result = $stm->get_result(); echo 'ID: ' . $result['name'] . '<br>'; return $result; } catch (Exception $e) { return "error"; } finally { } }
public static function getLastResourceID() { $conn = cont\connection::getConnectionObject(); $con = $conn->getConnection(); $sql = "SELECT max(resource_id) FROM resource"; if ($result = mysqli_query($con, $sql)) { $row = mysqli_fetch_row($result); if ($row[0] == null) { $r = 0; } else { $r = $row[0]; } mysqli_free_result($result); } return $r + 1; }
public static function saveToSupplier(Supplier $spp) { $conn = cont\connection::getConnectionObject(); $con = $conn->getConnection(); $sql = $con->prepare("INSERT INTO Supplier VALUES (?,?,?,? )"); $supplierId = $spp->getSupplierId(); $name = $spp->getName(); $contactNo = $spp->getContactNo(); $Nic = $spp->getNic(); $sql->bind_param("ssss", $supplierId, $name, $contactNo, $Nic); if ($sql->execute() == TRUE) { echo "New record created successfully"; return true; } else { echo "not working"; echo "Error: " . $sql . "<br>"; return false; } }
public static function saveToAchievement(Achievement $achievement) { $conn = cont\connection::getConnectionObject(); $con = $conn->getConnection(); $sql = $con->prepare("INSERT INTO achievement VALUES (?,?,?,? )"); $sport_id = $achievement->getSportId(); $achievement_id = $achievement->getAchievementId(); $description = $achievement->getDescription(); $date = $achievement->getDate(); echo $sport_id; echo $achievement_id; echo $description; echo $date; $sql->bind_param("ssss", $sport_id, $achievement_id, $description, $date); $sql->execute(); if ($sql->errno) { echo "FAILURE!!! " . $sql->error; } else { echo "Updated {$sql->affected_rows} rows"; } }
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; }
public static function getLastStudentID() { $conn = connection::getConnectionObject(); $con = $conn->getConnection(); $sql = "SELECT student_id FROM student ORDER BY student_id DESC limit 1"; if ($result = mysqli_query($con, $sql)) { $row = mysqli_fetch_row($result); if ($row[0] == null) { $r = 0; } else { $r = $row[0]; } mysqli_free_result($result); } return $r + 1; }