class.ilLikeMediaPoolSearch.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
class ilLikeMediaPoolSearch extends ilMediaPoolSearch
{
    public function __createAndCondition(): string
    {
        $concat = $this->db->concat(
            array(
                array('title','text')
                )
        );
 
 
        $and = "  AND ( ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR";
            }
            #$and .= $concat;
            #$and .= ("LIKE ('%".$word."%')");
            #$and .= $ilDB->like($concat,'text','%'.$word.'%');
            $and .= $this->db->like('title', 'text', '%' . $word . '%');
        }
        return $and . ") ";
    }
 
    public function __createKeywordAndCondition(): string
    {
        $concat = ' keyword ';
 
        $and = "  WHERE  ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }
            $and .= $this->db->like($concat, 'text', '%' . $word . '%');
        }
        return $and;
    }
}