class.ilLikeMediaCastSearch.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilLikeMediaCastSearch extends ilMediaCastSearch
{
    public function __createWhereCondition(): string
    {
        $and = "  WHERE context_obj_type='mcst' AND (  ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }
            #$and .= $concat;
            #$and .= ("LIKE ('%".$word."%')");
            $and .= $this->db->like('title', 'text', '%' . $word . '%');
            $and .= ' OR ';
            $and .= $this->db->like('content', 'clob', '%' . $word . '%');
        }
        return $and . ") ";
    }
}