public function delete($id) { $pdo = Connection::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $q = $pdo->prepare($this->deleteUserQuery); $q->execute(array($id)); Connection::disconnect(); }
public function upsert() { $user = AuthController::auth(); if ($this->isValid($_POST)) { $instanceRepo = new InstanceRepository(); $pdo = Connection::connect(); $pdo->beginTransaction(); try { if ($_POST['id'] != "") { $instance = $instanceRepo->get($_POST['id']); $instance->name = $_POST['name']; $instance->description = $_POST['description']; $instanceRepo->update($instance); $_SESSION['success'] = ['Successfully update an instance.']; } else { $instance = new Instance(); $instance->id = $this->generateId(); $instance->password = $this->generatePassword(); $instance->userId = $user->id; $instance->name = $_POST['name']; $instance->description = $_POST['description']; $instanceRepo->insert($instance); $_SESSION['success'] = ['Successfully add an instance.']; } $pdo->commit(); } catch (\Exception $e) { $pdo->rollBack(); unset($_SESSION['success']); } header('Location: /'); } else { if ($_POST['id'] != "") { header('Location: /instance/edit?id=' . $_POST['id']); } else { header('Location: /instance/edit'); } } }