class.ilLikeExerciseSearch.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilLikeExerciseSearch extends ilExerciseSearch
{
    public function __createWhereCondition(): string
    {
        $concat = $this->db->concat(
            array(
                array('title','text'),
                array('instruction','text'))
        );

        $and = "  WHERE ( ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }
            $and .= $this->db->like($concat, 'clob', '%' . $word . '%', false);
        }
        return $and . ") ";
    }
}