class.ilLikeObjectSearch.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilLikeObjectSearch extends ilObjectSearch
{
    public function __createWhereCondition(): string
    {
        $concat = $this->db->concat(
            array(
                array('title','text'),
                array('description','text'))
        );
        $where = "WHERE (";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $where .= "OR";
            }

            $where .= $this->db->like($concat, 'text', '%' . $word . '%');
        }
        $where .= ') ';
        return $where;
    }
}