/** * @param string $key */ public function clearExpiredLock($key = null) { $currDate = date($this->options->getDbDateTimeFormat()); $delete = $this->gateway->getSql()->delete(); $pred = $delete->where->lessThanOrEqualTo('end_datetime', $currDate); if ($key) { $pred = $pred->and->equalTo('key', $key); } $this->gateway->deleteWith($delete); }
public function index09Action() { $table = "user"; $adapter = $this->getServiceLocator()->get("db_books"); $tableGateway = new TableGateway($table, $adapter); $deleteObj = new Delete("user"); $deleteObj->where->equalTo("id", "6"); echo $tableGateway->deleteWith($deleteObj); return false; }