PHP Zend\Db\Sql\Sql::delete示例

示例#1

文件： DbObject.php 项目： scriptkitties/NekoPHP

 /**
  * @return bool
  */
 public function delete()
 {
     $id = $this->getIdentifier();
     $db = $this->createZendDb();
     $sql = new \Zend\Db\Sql\Sql($db);
     $query = $sql->delete()->from(self::getTableName())->where([$id['column'] => $id['value']]);
     $stmt = $sql->prepareStatementForSqlObject($query);
     $result = $stmt->execute();
     return $result->getAffectedRows() > 0;
 }

示例#2

文件： PostRepositoryImpl.php 项目： samija/Deeplifec4tk

 /**
  * @param $postId int
  *
  * @return void
  */
 public function delete($postId)
 {
     $sql = new \Zend\Db\Sql\Sql($this->adapter);
     $delete = $sql->delete()->from('news')->where(array('id' => $postId));
     $statement = $sql->prepareStatementForSqlObject($delete);
     $statement->execute();
 }