public function __construct() { $this->app = Factory::getSlimApp(); $this->container = $this->app->getContainer(); $this->logger = $this->container->logger; $this->db = Factory::getDb(); }
public static function deleteFromTable($filter, $table) { $logger = Factory::getSlimApp()->getContainer()->logger; try { $db = Factory::getDb(); $deleteStatement = $db->delete()->from($table)->where(...$filter); $affectedRows = $deleteStatement->execute(); $logger->info("affected rows are " . $affectedRows); if ($affectedRows) { return ["success" => true, "message" => "Delete successful."]; } else { return ["success" => false, "message" => "Delete failed for " . json_encode($filter) . " from {$table}.\n SQL: " . $deleteStatement->__toString() . "\n" . json_encode($db->errorInfo())]; } } catch (Exception $e) { throw $e; } }