public function postFramework() { // check database connections $conn = $this->databaseConnection(); if ($conn) { $id = trim($_POST['ID']); $birthDate = trim($_POST['BirthDate']); $firstName = trim($_POST['FirstName']); $lastName = trim($_POST['LastName']); $gender = trim($_POST['Gender']); $hireDate = trim($_POST['HireDate']); $queries = new Queries(); $sqlCheck = $queries->checkFrameworkIfExistsById($id); $checkResult = mysqli_query($conn, $sqlCheck); if (mysqli_num_rows($checkResult) > 0) { echo json_encode(array('error' => $id . ' already Exists.')); } else { $sqlQuery = $queries->newFrameworkAddition($id, $birthDate, $firstName, $lastName, $gender, $hireDate); $result = mysqli_query($conn, $sqlQuery); if ($result) { echo json_encode(array('success' => 'Created New Entry.')); } else { echo json_encode(array('error' => 'Unable to Add Request.')); } } } else { $connection = false; echo "There was an error, please contact web administrator."; return false; } }
public function postFramework() { // check database connections $conn = $this->databaseConnection(); if ($conn) { $framework = trim($_POST['framework']); $language = trim($_POST['language']); $link = trim($_POST['link']); $description = trim($_POST['description']); $queries = new Queries(); $sqlCheck = $queries->checkFrameworkIfExists($framework); $checkResult = mysqli_query($conn, $sqlCheck); if (mysqli_num_rows($checkResult) > 0) { echo json_encode(array('error' => $framework . ' already Exists.')); } else { $sqlQuery = $queries->newFrameworkAddition($framework, $language, $link, $description); $result = mysqli_query($conn, $sqlQuery); if ($result) { echo json_encode(array('success' => 'Created Framework Entry.')); } else { echo json_encode(array('error' => 'Unable to Add Request.')); } } } else { $connection = false; echo "There was an error, please contact web administrator."; return false; } }