DGet.php

Go to the documentation of this file.

<?php
 
namespace PhpOffice\PhpSpreadsheet\Calculation\Database;
 
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
 
class DGet extends DatabaseAbstract
{
    public static function evaluate($database, $field, $criteria)
    {
        $field = self::fieldExtract($database, $field);
        if ($field === null) {
            return null;
        }
 
        $columnData = self::getFilteredColumn($database, $field, $criteria);
        if (count($columnData) > 1) {
            return Functions::NAN();
        }
 
        $row = array_pop($columnData);
 
        return array_pop($row);
    }
}