Illuminate\Database\Connection::selectOne PHP Method

selectOne() public method

Run a select statement and return a single result.
public selectOne ( string $query, array $bindings = [] ) : mixed | null
$query string
$bindings array
return mixed | null
    public function selectOne($query, $bindings = [])
    {
        $records = $this->select($query, $bindings);
        return array_shift($records);
    }

Usage Example

 /**
  * {@inheritdoc}
  */
 public function findMask(RequesterInterface $requester, ResourceInterface $resource)
 {
     $oldFetchMode = $this->connection->getFetchMode();
     $this->connection->setFetchMode(\PDO::FETCH_COLUMN);
     if (null === ($mask = $this->connection->selectOne('SELECT mask FROM ' . $this->getAclSchema()->getPermissionsTableName() . ' WHERE requester = :requester AND resource = :resource', ['requester' => $requester->getAclRequesterIdentifier(), 'resource' => $resource->getAclResourceIdentifier()]))) {
         $this->connection->setFetchMode($oldFetchMode);
         throw new MaskNotFoundException();
     }
     $this->connection->setFetchMode($oldFetchMode);
     return (int) $mask;
 }
All Usage Examples Of Illuminate\Database\Connection::selectOne